Actions
Bug #68512
closedMysql error running Upgrade Wizard
Start date:
2015-07-24
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
Update failed! SQL-ERROR: 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 '( type varchar(16) NOT NULL, tKey varchar(8) NOT NULL, tValue varchar(128) NOT N' at line 1 Update database schema: Create tables and fields CREATE TABLE IF ( type varchar(16) NOT NULL, tKey varchar(8) NOT NULL, tValue varchar(128) NOT NULL, index int(8) NOT NULL, id int(11) NOT NULL, deleted tinyint(4) NOT NULL default '0', rootPage int(11) NOT NULL, entityId int(11) NOT NULL, position int(11) NOT NULL, headline varchar(18) CHARACTER SET utf8 NOT NULL, subHeadline varchar(64) CHARACTER SET utf8 NOT NULL, link varchar(256) CHARACTER SET utf8 NOT NULL, name varchar(256) NOT NULL, clearName varchar(64) default NULL, placeholderId int(11) NOT NULL, picturePath varchar(256) CHARACTER SET utf8 NOT NULL, originalHeight int(11) NOT NULL, originalWidth int(11) NOT NULL, text varchar(2048) NOT NULL, iata varchar(3) NOT NULL ) ENGINE=MEMORY;
Following Code works:
CREATE TABLE `IF` ( type varchar(16) NOT NULL, tKey varchar(8) NOT NULL, tValue varchar(128) NOT NULL, index int(8) NOT NULL, id
int(11) NOT NULL, deleted tinyint(4) NOT NULL default '0', rootPage int(11) NOT NULL, entityId int(11) NOT NULL, position int(11)
NOT NULL, headline varchar(18) CHARACTER SET utf8 NOT NULL, subHeadline varchar(64) CHARACTER SET utf8 NOT NULL, link
varchar(256) CHARACTER SET utf8 NOT NULL, name varchar(256) NOT NULL, clearName varchar(64) default NULL, placeholderId int(11)
NOT NULL, picturePath varchar(256) CHARACTER SET utf8 NOT NULL, originalHeight int(11) NOT NULL, originalWidth int(11) NOT NULL,
text varchar(2048) NOT NULL, iata varchar(3) NOT NULL ) ENGINE=MEMORY;
Actions