masterblaster Posted November 19, 2013 Share Posted November 19, 2013 Hello, Today I tried to upgrade my shop from 1.4.9.0 to 1.5.6.1 version using 1-click-upgrade module. I use the very last autoupgrade module version (1.2.4) downloaded just today from addons website. I ran the module and after 10 minutes of work I got no errors at all (only a warning about deleting "backward compatibility module" being not compatible with 1.5), but I had a major issue on orders... I had 4000+ valid orders in my 1.4.9.0 that got vanished after upgrade. I checked DB and I found that : ps_orders table had only 24 records against the correct 1.4 DB that had 4000+ records)... The ID of the remaining orders were very strange too : 213, 413, 616 , 816, 1017 , 1217 ... It seemed like autoupgrade had deleted a lot of records and keep them only 200 by 200. In addition , ps_order_detail is completely empty after upgrade and 1.5 backoffice was missing of "ORDERS" tab in top-horizontal menu (I managed to found "ORDERS" under "Advanced Settings" Menu... Very strange) Some ideas on how to solve it ? Of course my idea is to re-run the upgrade module again , but now I am rolled back to 1.4 installation. Thanks Link to comment Share on other sites More sharing options...
laurapessoa Posted November 20, 2013 Share Posted November 20, 2013 Same here, I have only 1 order... Link to comment Share on other sites More sharing options...
masterblaster Posted November 20, 2013 Author Share Posted November 20, 2013 I also tried upgrading by steps 1.4.9 -> 1.4.11 went OK with all orders1.4.11 -> 1.5.6.1 did the same mess (only 20 orders kept) Also tried to delete / uninstall all third party modules before upgrading, but still the same issue. I kept the upgrade log and saw that all queries went ok. There is a bunch of queries about altering ps_order* table in order to add new 1.5 fields , but I really can't figure how the ps_order_detail could be dropped. Link to comment Share on other sites More sharing options...
Spotted Projects Posted November 20, 2013 Share Posted November 20, 2013 (edited) Same here. The upgrade from 1.4.9 to 1.4.11 works. From 1.4.9 or 1.4.11 to 1.5.6.1 finishes without errors but only 7 orders remain. All the other ones have disappeared. This is really an issue... Can anyone help? Greetings Robin Edited November 20, 2013 by Spotted Projects (see edit history) Link to comment Share on other sites More sharing options...
masterblaster Posted November 20, 2013 Author Share Posted November 20, 2013 It had been confirmed to be a bug in 1.5.6.1 "migrate_order" php function... Hopefully somebody is working to fix it ( forge issue PSCFV-11063 ) Link to comment Share on other sites More sharing options...
Gregory Roussac Posted November 21, 2013 Share Posted November 21, 2013 Dear all,Can you please try to update your autoupgrade module to 1.2.5 version from this zip ?https://github.com/PrestaShop/PrestaShop-modules/archive/master.zipThis fix should fix this issuehttps://github.com/PrestaShop/PrestaShop-modules/commit/5bc941d03be121d69120bbaade60d2d74e018445Please let me know if this worked for your upgrade.Best regards Link to comment Share on other sites More sharing options...
contaseberloques Posted November 23, 2013 Share Posted November 23, 2013 I have the same problem here. Link to comment Share on other sites More sharing options...
Spotted Projects Posted November 24, 2013 Share Posted November 24, 2013 Try to upgrade the autograde module. Then do the upgrade again. You will see that all orders will be available. 1 Link to comment Share on other sites More sharing options...
contaseberloques Posted November 24, 2013 Share Posted November 24, 2013 It was solved by the solution in the link that Gregory post, worked for me, thanks. Link to comment Share on other sites More sharing options...
masterblaster Posted November 27, 2013 Author Share Posted November 27, 2013 Hello, I confirm that the problem is solved with Autoupgrade module 1.2.5 , thanks Gregory for the quick fix ! Link to comment Share on other sites More sharing options...
laurapessoa Posted November 27, 2013 Share Posted November 27, 2013 For me it worked only partially. Now I have all the customers, but still 1 order. Is possible to take that orders from a copy of the DB of PS 1.4. or the tables are different? If I restore the old copy, I will lose new orders and customers? Thank you. Link to comment Share on other sites More sharing options...
tuk66 Posted November 29, 2013 Share Posted November 29, 2013 It would be nice to have a live message within this module where a new version and issues in old version are described. Something like A new version of Autoupgrade module is available. : Download 1.2.5 stable ! Don't use this old version !!! Link to comment Share on other sites More sharing options...
Gregory Roussac Posted November 29, 2013 Share Posted November 29, 2013 There is one, but this file needs to be updated https://api.prestashop.com/xml/channel.xml manually and sometimes the person in charge just forget to update it. Regards Link to comment Share on other sites More sharing options...
Divyesh Prajapati Posted November 29, 2013 Share Posted November 29, 2013 I have same issue, Found only 2 orders. Please some one help. Link to comment Share on other sites More sharing options...
goosedesign Posted December 23, 2013 Share Posted December 23, 2013 I have the same issue but with manual rather than auto upgrade (which just failed completely). Is there a similar bug somewhere in the install/upgrade folder? Link to comment Share on other sites More sharing options...
hermit75 Posted January 8, 2014 Share Posted January 8, 2014 Ditto, how to make a similar adjustment in the Install directory so that order migration will succeed in a manual upgrade? Link to comment Share on other sites More sharing options...
goosedesign Posted January 9, 2014 Share Posted January 9, 2014 Most of my upgrade problems turned out to be caused by insufficient resources in the PHP configuration file. I bumped it all up in MAMP and the auto upgrade module worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now