Failed upgrade to Prestashop 1.5.2

[mikebt26]

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

[vynx]

do you have backup ?

[Mr S]

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)