After a long hassle of splitting .sql files and importing them into that fucking stupid one.com host. I finally got it upgraded to Prestashop 8.0.0.
However 1 more bug:
If I set this line to false again, links to products / categories (the rest works) lead me back to the localhost. I have changed ns_shop_url urls and ps_configuration ssl and normal url
define('_PS_MODE_DEV_', false);
BUG SOLVED,
Deleted both var/cache/dev and var/cache/prod