anson.c Posted February 13, 2011 Share Posted February 13, 2011 I recently tried to upgrade from 1.3.1 to 1.4 and it failed. Half of the store front modules were disappeared and gone in the backoffice as well. So I tried to redo it with 1.3.6 instead. On the last step of installation it got an error message saying there were 8 SQL errors occurred. (Attached is the log.) And the store front error message: Invalid loadTaxZones() SQL query! Even I tried to restore it to 1.3.1 it's still not working Somebody help pleeeease?! log.txt Link to comment Share on other sites More sharing options...
Yann - Prestaplugins Posted February 13, 2011 Share Posted February 13, 2011 When you say "restore", it includes database restoration with a complete backup ? Link to comment Share on other sites More sharing options...
scottyboy Posted February 13, 2011 Share Posted February 13, 2011 Ok, before you think about doing anything drastic, do you have a backup file of your database? Don't worry, it's not the end of the world if the answer is no. Link to comment Share on other sites More sharing options...
anson.c Posted February 13, 2011 Author Share Posted February 13, 2011 Nope. I didn't make any backup. Link to comment Share on other sites More sharing options...
Yann - Prestaplugins Posted February 13, 2011 Share Posted February 13, 2011 A pro could probably reverse the changes made to the database by the 1.4 update... :coolsmirk: Link to comment Share on other sites More sharing options...
anson.c Posted February 14, 2011 Author Share Posted February 14, 2011 What should I do now? :*( Link to comment Share on other sites More sharing options...
scottyboy Posted February 14, 2011 Share Posted February 14, 2011 I've come across this scenario before when I upgraded from version 1.2 to 1.3. You need to save your database right more and don't attempt to upgrade anything until this is complete. Do you have access to PHPmyadmin on the host server? Link to comment Share on other sites More sharing options...
anson.c Posted February 14, 2011 Author Share Posted February 14, 2011 I have access to Manage MySQL... is it the same thing?sorry I'm kind of amateur Link to comment Share on other sites More sharing options...
Paul C Posted February 14, 2011 Share Posted February 14, 2011 My suggestion would be to first take a deep breath In the admin preferences screens did you set the option to force Smarty 2 to "Yes". If you didn't, then do that now and you may find that your store isn't as bad as you thought it was Also disable any custom modules for now (and don't at this stage replace any standard modules with modified ones).If that fails to impress.....I would never personally contemplate going back a version, but the database upgrade may not have done too much "damage" so after taking yet another backup (just to be sure) you could try just reverting the files and see what happens.... from memory the changes made in 1.4 likely will just be able to be ignored. Remember to manually edit the setting.inc.php file version back to what the old version was. This will make sure any necessary recalculations will be applied the next time you try and upgrade.Paul Link to comment Share on other sites More sharing options...
anson.c Posted February 14, 2011 Author Share Posted February 14, 2011 I think I already fail the first step I can't find the force smarty 2 thing... Link to comment Share on other sites More sharing options...
Patric Posted February 14, 2011 Share Posted February 14, 2011 Please edit your topic's title to comply with the forum's rules. Else I will close that topic. Thanks. Link to comment Share on other sites More sharing options...
Paul C Posted February 14, 2011 Share Posted February 14, 2011 anson,After you change your subject line I was talking about the Prestashop Admin screens -> The smarty 2 compatibility setting is in the Preferences tab. I'm trying to see if your upgrade is ok but your theme and modules are causing the problem....If you have given up on getting 1.4 to work, then as a first step I would ignore phpmyadmin and just restore the files back to the version you were using. The database may well be ok, and not to be rude, but if you're not sure what you're doing then messing about in there might just make things worse.Paul Link to comment Share on other sites More sharing options...
anson.c Posted February 20, 2011 Author Share Posted February 20, 2011 I think it's too late now! I'm no longer able to access the store front nor the back office.... the error message is all I got "Invalid loadTaxZones() SQL query! "I've tried to restore the old version PS onto my ftp but it did not solve the problem so I guess something in my database got damaged!!I'm trying to restore my db but I always lost connection when I try to import the backup file onto the phpadminit is beyond frustrating and I'm so afraid that I may lose the entire site! Link to comment Share on other sites More sharing options...
anson.c Posted February 21, 2011 Author Share Posted February 21, 2011 I restored my site FINALLY!!! *reliefffffNow I have one question left to ask - Does it worth the trouble and risk to upgrade from my 1.31 to 1.4 or 1.37?What good will I see really?Anyway.... thank you very much Paul!! You know how scary it was when things are down and you have to deal with them on your own! Link to comment Share on other sites More sharing options...
ScubaLessonsInc Posted February 23, 2011 Share Posted February 23, 2011 Can you share how you did it for others who are just as stressed (e.g. me!) I did a full install version 1.3.7 and it worked great~! Installed some modules, still fine. Installed a theme and lost connection in the middle of that and it crashed my back office and front office with a SERVER 500 error. I tried deleting the database and all the files and just starting from stcratch as this was a new install but NOOO, still giving me 500 insternal server error. I tried checking hte .htaccess file and recreating that, no change, then I tried checking file permissions 777, on the ones on the install instructions list are all there. Not sure what else to do, still getting server 500 error! I have messed with this for 6 hours and ready to pull my hair out. I have prestashop on 7 other sites with no probs ever. By the way the problem theme was the free mobile theme from template monster. Anybody who can help me I would be SOO GRATEFUL! FREE SCUBA LESSON IF YOUR IN FLORIDA if it solves my issue! Thanks, Tina O'Connell Link to comment Share on other sites More sharing options...
Paul C Posted February 23, 2011 Share Posted February 23, 2011 It's likely that setting the permissions to 777 is what's actually causing the http 500 error. Try setting the directories to 755 and files to 644 and that should fix it.Some servers don't like 777 on directories or on files (and files should never be an odd numbered permission unless they're executable, which php files are not).Paul Link to comment Share on other sites More sharing options...
Stylish Posted March 15, 2011 Share Posted March 15, 2011 Hello everybody!I've the same problem as 'anson.c' I did an update from the version 1.4.0.3 to the newest one 1.3.7.0Just after the update, my site didn't workSo I transfer on my FTP the oldest files that I had backup the day beforeAnd now I see an error on my website : Invalid loadTaxZones() SQL query!That's like this since March 3rdI searched every day for a solution, but no one I need my website, please anyone can help me..?Thank you a loooot !Sorry for my english, I'm french.. Link to comment Share on other sites More sharing options...
anson.c Posted March 16, 2011 Author Share Posted March 16, 2011 Hey did you back up your database?I fixed mine by storing the database. Restoring those ftp files won't help at all! Link to comment Share on other sites More sharing options...
oscarm Posted March 18, 2011 Share Posted March 18, 2011 Hi there. I am having the exact same problem. I installed prestashop 1.4 into a new folder on my site so as to avoid messing with the live site.I backed up my database too. After installing 1.4 I went back to have a look at the live site, and all I get is "Invalid loadTaxZones() SQL query".I didn't make any changes to the live site though so I don't get it.I can't access the admin section either. If I can'access the admin, i'm not sure how to import the backed up database.On phpMyAdmin I went to the Import option, uploaded the *.sql file, Character set utf8, used the SQL format, Left SQL compatibility modeset to NONE and ticked "Do not use AUTO_INCREMENT for zero values". but I get this error:/* Scheme for table ps_access */ CREATE TABLE `ps_access` (`id_profile` int( 10 ) unsigned NOT NULL ,`id_tab` int( 10 ) unsigned NOT NULL ,`view` int( 11 ) NOT NULL ,`add` int( 11 ) NOT NULL ,`edit` int( 11 ) NOT NULL ,`delete` int( 11 ) NOT NULL ,PRIMARY KEY ( `id_profile` , `id_tab` )) ENGINE = MYISAM DEFAULT CHARSET = utf8;Any ideas? Link to comment Share on other sites More sharing options...
Stylish Posted March 20, 2011 Share Posted March 20, 2011 @ anson.cNo I didn't have a backup of my database...Do you think that a professionnal can resolve this problem ?I called a friend, if he makes my website go back to life, I'll tell you ! Link to comment Share on other sites More sharing options...
Lustfull Posted March 21, 2011 Share Posted March 21, 2011 Have same problems. since update from 1.3.7 to 1.4 didn´t work I removed the update and tried to upload the older version. Had a complete backup of all files and also a backup of database from the back office.Removed all entry's of new version and used ftp to upload to backup files from version 1.3.7.then I tried to access to my BO and got the same error message that so many other get: Invalid loadTaxZones() SQL query! Since I dont understand a bit about changing things in PHPmyadmin don´t know what to do.All suggestions are welcome.RSusanne Link to comment Share on other sites More sharing options...
R0BJ3 Posted March 21, 2011 Share Posted March 21, 2011 Hi there. I am having the exact same problem. I installed prestashop 1.4 into a new folder on my site so as to avoid messing with the live site.I backed up my database too. After installing 1.4 I went back to have a look at the live site, and all I get is "Invalid loadTaxZones() SQL query".I didn't make any changes to the live site though so I don't get it.I can't access the admin section either. If I can'access the admin, i'm not sure how to import the backed up database.On phpMyAdmin I went to the Import option, uploaded the *.sql file, Character set utf8, used the SQL format, Left SQL compatibility modeset to NONE and ticked "Do not use AUTO_INCREMENT for zero values". but I get this error:/* Scheme for table ps_access */ CREATE TABLE `ps_access` (`id_profile` int( 10 ) unsigned NOT NULL ,`id_tab` int( 10 ) unsigned NOT NULL ,`view` int( 11 ) NOT NULL ,`add` int( 11 ) NOT NULL ,`edit` int( 11 ) NOT NULL ,`delete` int( 11 ) NOT NULL ,PRIMARY KEY ( `id_profile` , `id_tab` )) ENGINE = MYISAM DEFAULT CHARSET = utf8;Any ideas? I'm having the same problem. :-(Can someone please help?Many thanks in advance! Link to comment Share on other sites More sharing options...
peanut Posted March 21, 2011 Share Posted March 21, 2011 Hi there. I am having the exact same problem. I installed prestashop 1.4 into a new folder on my site so as to avoid messing with the live site.I backed up my database too. After installing 1.4 I went back to have a look at the live site, and all I get is "Invalid loadTaxZones() SQL query".I didn't make any changes to the live site though so I don't get it.I can't access the admin section either. Similar issue here. Any idea how to solve this? Link to comment Share on other sites More sharing options...
R0BJ3 Posted March 21, 2011 Share Posted March 21, 2011 Hi there. I am having the exact same problem. I installed prestashop 1.4 into a new folder on my site so as to avoid messing with the live site.I backed up my database too. After installing 1.4 I went back to have a look at the live site, and all I get is "Invalid loadTaxZones() SQL query".I didn't make any changes to the live site though so I don't get it.I can't access the admin section either. If I can'access the admin, i'm not sure how to import the backed up database.On phpMyAdmin I went to the Import option, uploaded the *.sql file, Character set utf8, used the SQL format, Left SQL compatibility modeset to NONE and ticked "Do not use AUTO_INCREMENT for zero values". but I get this error:/* Scheme for table ps_access */ CREATE TABLE `ps_access` (`id_profile` int( 10 ) unsigned NOT NULL ,`id_tab` int( 10 ) unsigned NOT NULL ,`view` int( 11 ) NOT NULL ,`add` int( 11 ) NOT NULL ,`edit` int( 11 ) NOT NULL ,`delete` int( 11 ) NOT NULL ,PRIMARY KEY ( `id_profile` , `id_tab` )) ENGINE = MYISAM DEFAULT CHARSET = utf8;Any ideas? I'm having the same problem. :-(Can someone please help?Many thanks in advance! I managed to fix this issue. This did the trick for me: 1. Go to phpmyadmin2. Select your database3. Scroll down and select "select all" 4. In the dropdown menu a little bit on the right, select "drop" (or delete) (do this also for the next pages if you have a larger database)5. Now you have an empty database6. Go to Import in the uppermenu7. Select your backup file and click "start"This way I imported my backup succesfully. Link to comment Share on other sites More sharing options...
peanut Posted March 22, 2011 Share Posted March 22, 2011 I managed to restore my backup & can access the back office but the store / front office gives an error: Unknown column 'reduction_price' in 'where clause' SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, i.`id_image`, il.`legend`, t.`rate` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_tax` t ON t.`id_tax` = p.`id_tax` WHERE (`reduction_price` > 0 OR `reduction_percent` > 0) AND (`reduction_from` = `reduction_to` OR (`reduction_from` <= '2011-03-22 10:03:12' AND `reduction_to` >= '2011-03-22 10:03:12')) AND p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `ps_category_group` cg LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) ORDER BY RAND()I don't understand this. Any ideas? Link to comment Share on other sites More sharing options...
Stylish Posted March 26, 2011 Share Posted March 26, 2011 I didn't solve the problem by myself so I ask help to my friend at this website :http://www.magavenue.com/blog/contactez-nousHe solve my problem in 2 hoursHe's french like me, but he must understand you! You can see the results on my website : www.stylish-chrono.fr Link to comment Share on other sites More sharing options...
JohnADK Posted March 26, 2011 Share Posted March 26, 2011 Like peanut, I have restored 1.3.7 again from my backup files and database backup. back office works fine, database looks good, but if I try to access my shop, I just get a 403 Forbidden error: You don't have permission to access /webshoppen/ on this server.There must be one little file, or setting, I'm still missing to correct.Anyone know what that might be? Link to comment Share on other sites More sharing options...
karban Posted March 27, 2011 Share Posted March 27, 2011 Hi John,Just a guess, but might it perhaps be something to do with a new feature, "webshppen" introduced in 1.4 and that is perhaps still installed / activated after you rolled back??? - I've had a different problem (our modules page disappeared in back-end after reverting back to 1.3......) & the solution for our problem was to delete loads of unnecessary modules from the v1.4 upgrade (about 20 of them - it seems that lots of new modules that were added in v1.4 are not being deleted after rolling back to 1.3.....). Hope this suggestion works for you, or that someone else can give you a solution. Good luck. Link to comment Share on other sites More sharing options...
JohnADK Posted March 27, 2011 Share Posted March 27, 2011 Thanks for the suggestion. I actually found out (finally!) that my backup was missing a few files in the root folder (I did have some troubles with my ftp file transfer during backup). Once I added the missing files, I was back where I started - whew!Now I will wait a bit more and see whether to try the upgrade again, or just continue with 1.3.7. Link to comment Share on other sites More sharing options...
FireHawk Posted April 12, 2011 Share Posted April 12, 2011 OMG - Tried to upgrade from 1.3 to the new 1.4 and all hell went loose.Got one picture showing and nothing else.Decided after playing about that i would just simply delete all folders/files from my host and upload the copy i took before i started the upgrade.Now i can get back onto my site but all my products are gone!I have no idea what to do now.I did a database backup too before i tried the upgrade but i have no idea what to do with the file it created.Can anyone help please? 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