Project

General

Profile

Actions

Bug #68512

closed

Mysql error running Upgrade Wizard

Added by sa mari over 9 years ago. Updated about 9 years ago.

Status:
Closed
Priority:
Must have
Category:
Install Tool
Target version:
-
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;


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #66104: ext_tables.sql all fields-names should be properly escapedClosedMorton Jonuschat2015-03-27

Actions
Actions

Also available in: Atom PDF