mikebt26 Posted November 18, 2012 Share Posted November 18, 2012 I have just tried to upgrade to version 1.5 through the 1 click upgrade for the second time now in the last month with no luck. Below are the message I receive on the 1 click upgrade page after it has completed Upgrade Complete, but warnings has been found. [ERROR] SQL 1.5.0.0 1064 in INSERT INTO `group_group_shop` (id_group_shop, id_group) (SELECT 1, id_group FROM group): 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 'group)' at line 1 Warning detected during upgrade. Upgrade complete, but warnings has been found. Please restore your shop. When I open a new tab and try to go to my prestashop admin login page I get this message Server error The website encountered an error while retrieving https://www.tackleaustralia.com.au/admin363/index.php?controller=AdminLogin. It may be down for maintenance or configured incorrectly. Here are some suggestions: Reload this webpage later.HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request. Can anyone please help me with what the problem might be? Thanks, Mike Link to comment Share on other sites More sharing options...
vynx Posted November 18, 2012 Share Posted November 18, 2012 do you have backup ? Link to comment Share on other sites More sharing options...
Mr S Posted November 18, 2012 Share Posted November 18, 2012 (edited) I had the same error its because i did not have any prefixes for my DB tables. So you could add a prefix to your tables than run the upgrade. The bug has been fixed for next PrestaShop release: http://forge.prestas...owse/PSCFV-5331 INSERT INTO `group_group_shop` (id_group_shop, id_group) (SELECT 1, id_group FROM group) FROM group ::FROM `group` Edited November 18, 2012 by HA!*!*Y (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts