cmat Posted January 16, 2013 Share Posted January 16, 2013 long story short i attempted to upgrade from 1.4 to 1.5 and from what i have read the tables dont match up. here is my issue i have reloaded my files via ftp but i have two db backups 1 from prestashop and 1 from phpmyadmin. they each give me a different error when i try to import. first is when i import the ps back up: Error MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 16 here is the error for phpmyadmin backup import: fatal error memory exhausted ( dont remember the exact error) i cant log in to the back office also all my items are gone 500+ please help!!!!! Link to comment Share on other sites More sharing options...
Dh42 Posted January 16, 2013 Share Posted January 16, 2013 try increasing your memory limit in your php.ini and then try re importing through phpmyadmin Link to comment Share on other sites More sharing options...
vekia Posted January 16, 2013 Share Posted January 16, 2013 cmat if you don't know how to change it, or if you haven't got access to this file - try to ask your hosting provider for help, the solution is in php.ini memory limit value, exactly as Dh42 says Link to comment Share on other sites More sharing options...
cmat Posted January 16, 2013 Author Share Posted January 16, 2013 Dh42 can you point me to location and line of code for php.ini? And what value should I increase to? Thanks Link to comment Share on other sites More sharing options...
Dh42 Posted January 16, 2013 Share Posted January 16, 2013 Here is a great blog post on it by presto changeo http://presto-changeo.tumblr.com/post/17589539698/understanding-php-ini-how-and-why-you-need-one Link to comment Share on other sites More sharing options...
El Patron Posted January 16, 2013 Share Posted January 16, 2013 along with the above advice you can contact your hosting provider, you can also take your phpmyadmin sql dump and breat it into multiple parts that you can import Link to comment Share on other sites More sharing options...
cmat Posted January 16, 2013 Author Share Posted January 16, 2013 @dh42 thanks for the link I will give it a try! @elpatron how would I break up the SQL dump without corrupting it Link to comment Share on other sites More sharing options...
El Patron Posted January 16, 2013 Share Posted January 16, 2013 re breaking it up... just break it at the CREATE TABLE IF NOT EXISTS Link to comment Share on other sites More sharing options...
cmat Posted January 21, 2013 Author Share Posted January 21, 2013 So here is what I did: 1. Backup current site 2. Wipe out current site on host 3. Made new db installed 1.5 with demo products 4. Imported ps_products to new db 5. BO shows multiple products but with "--" in title description etc. Is there other tables I have to import in order to get title description what not? Also what about categories and manufactures?? Link to comment Share on other sites More sharing options...
cmat Posted January 23, 2013 Author Share Posted January 23, 2013 No one can put any insight?? Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts