Hi,
This is about a contribution I have developed for Zen Cart.
On an upgrade SQL script I have created as part of an upgrade package for current users to update to the latest version, I am getting some people reporting a 1064 MySQL error on the following statement.
Here is the exact error:
1064 You have an error in your SQL syntax near ' configuration_group SET configuration.configuration_group_id = configuration_gr' at line 1
Here is the SQL *edit: broke the statement up cause it was expanding the forum too far*:
Code:
UPDATE configuration, configuration_group
SET configuration.configuration_group_id = configuration_group.configuration_group_id
WHERE configuration_group.configuration_group_title = 'News & Articles Management'
AND configuration.configuration_group_id = '2504';
The statement runs fine on mySQL 4.0.21 for me. I don't see what is causing the error, unless certain version of mySQL do not support such a statement. Any ideas?
Top
