Error when upgrading
Permalink 1 user found helpful
I get this message after upgrading to 5.4 from 5.3.3.1:
Anyone know how to solve this? Thanks.
An Unexpected Error occurred while upgrading: mysql error: [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 'columns INTEGER(3) NOT NULL DEFAULT 3, breakpoints ' at line 4] in EXECUTE("CREATE TABLE Layouts ( layoutID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, rows INTEGER(5) NOT NULL DEFAULT 3, columns INTEGER(3) NOT NULL DEFAULT 3, breakpoints VARCHAR(255) NOT NULL DEFAULT '', locked TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (layoutID) )")
Anyone know how to solve this? Thanks.
An Unexpected Error occurred while upgrading: mysql error: [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 'columns INTEGER(3) NOT NULL DEFAULT 3, breakpoints ' at line 4] in EXECUTE("CREATE TABLE Layouts ( layoutID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, rows INTEGER(5) NOT NULL DEFAULT 3, columns INTEGER(3) NOT NULL DEFAULT 3, breakpoints VARCHAR(255) NOT NULL DEFAULT '', locked TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (layoutID) )")
Thanks for your reply. I've been in touch with my web provider to update MySql on my site.
I'm having the same problem and also on a Netfirms server. Netfirms recently migrated all of my sites to their new data facility. I'm guessing this may have involved a change in MySQL versions. Does anybody know what version of MySQL works with C5 v5.4? It appears I'm running under version: 5.0.77 of MySQL on Netfirms.
try and upgrade to 5.1+ (mysql)
i use 5.1.48
i use 5.1.48
It appears that the table name "columns" is a reserved word in some versions of MySQL. That table name will probably be changed to "cols" or something similar in the final version of 5.4.
As reported in the other threads, you might be able to get around the issue by upgrading to the latest version of MySQL.