migration to new server

[netamis]

Hello all,

 

I need some help with migration Presta on a new server. I copy all my files Presta v 1.5.6, on new server , setup in host on my computer new IP . I delete all files from cache/ smarty and mytheme/cache.

As I get a blank page - but not getting any errors - I decided to upgrade on v1.6 . After upgrade I get error:

 

Fatal error: Uncaught Unknown column 'module_shop.enable_device' in 'on clause'<br /><br /><pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` </pre> thrown in .../public_html/classes/db/Db.php on line 635

 

Any advice - how can I fixed?  

Thanks

Edited April 13, 2014 by netamis (see edit history)

[netamis]

hello all, 
 

Where I can found list of changes at database level for prestashop 1.6. I just realize , my database was not upgrade and is same structure as in 1.5 .

 

Thanks ,

[bellini13]

I have no idea why you think upgrading would be the better route to take here.  I would ensure you can get the store to work properly before you try to upgrade it.

 

to answer your question, look in the folder \install\upgrade\sql and you will find all the database changes that are made for each release

[netamis]

Hello , 

Finally I manage to upgrade and enter in back-end. Thank you