#86861Database analyzer > Database analysis failed - provided SQL is OK
Description
Hi,
in the install tool of my Typo3 8.7 instance, I keep getting this error when I try to run the Database analyzer:
[SQL Error] line 0, col 1335: Error: Expected NOT, NULL, DEFAULT, AUTO_INCREMENT, UNIQUE, PRIMARY, COMMENT, COLUMN_FORMAT, STORAGE or REFERENCES, got ‘ON’ in statement:
CREATE TABLE `tablename` ( `Kennummer` INT NOT NULL AUTO_INCREMENT, `SKZ` INT NULL DEFAULT NULL, `LAND` VARCHAR NULL DEFAULT NULL, `NAME` VARCHAR NULL DEFAULT NULL, `STRASSE` VARCHAR NULL DEFAULT NULL, `PLZ` DOUBLE NULL DEFAULT NULL, `ORT` VARCHAR NULL DEFAULT NULL, `EMAIL` VARCHAR NULL DEFAULT NULL, `URL_HTTP` VARCHAR NULL DEFAULT NULL, `URL` VARCHAR NULL DEFAULT NULL, `TYP1` VARCHAR NULL DEFAULT NULL, `TYP2` VARCHAR NULL DEFAULT NULL, `TYP3` VARCHAR NULL DEFAULT NULL, `TYP4` VARCHAR NULL DEFAULT NULL, `subtyp1` VARCHAR NULL DEFAULT NULL, `subtyp2` VARCHAR NULL DEFAULT NULL, `subtyp3` VARCHAR NULL DEFAULT NULL, `subtyp4` VARCHAR NULL DEFAULT NULL, `subtyp5` VARCHAR NULL DEFAULT NULL, `subtyp_lernmit` VARCHAR NULL DEFAULT NULL, `TEST` DOUBLE NULL DEFAULT NULL, `TESTDATUM` DATETIME NULL DEFAULT NULL, `NEU` DOUBLE NULL DEFAULT NULL, `NEUDATUM` DATETIME NULL DEFAULT NULL, `KNOTEN` DOUBLE NULL DEFAULT NULL, `KOMMENTAR` VARCHAR NULL DEFAULT NULL, `NAME2` VARCHAR NULL DEFAULT NULL, `URL2` VARCHAR NULL DEFAULT NULL, `EMAIL2` VARCHAR NULL DEFAULT NULL, `TEST2` DOUBLE NULL DEFAULT NULL, `Expositur` CHAR NULL DEFAULT NULL, `letztesedit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `Tel1` VARCHAR NULL DEFAULT NULL, `FAX` VARCHAR NULL DEFAULT NULL, `kontakt` VARCHAR NULL DEFAULT NULL, `name_kurzform` VARCHAR NULL DEFAULT NULL, PRIMARY KEY (`Kennummer`), INDEX `URL` (`URL`), INDEX `SKZ` (`SKZ`), FULLTEXT INDEX `NAME` (`NAME`) ) COLLATE=‘utf8_general_ci’ ENGINE=MyISAM ;
When I manually run the create query in an sql tool against the same database (only changing the tablename) everything is working as expected.
SQL more readable:
CREATE TABLE `tablename` (
`Kennummer` INT NOT NULL AUTO_INCREMENT,
`SKZ` INT NULL DEFAULT NULL,
`LAND` VARCHAR NULL DEFAULT NULL,
`NAME` VARCHAR NULL DEFAULT NULL,
`STRASSE` VARCHAR NULL DEFAULT NULL,
`PLZ` DOUBLE NULL DEFAULT NULL,
`ORT` VARCHAR NULL DEFAULT NULL,
`EMAIL` VARCHAR NULL DEFAULT NULL,
`URL_HTTP` VARCHAR NULL DEFAULT NULL,
`URL` VARCHAR NULL DEFAULT NULL,
`TYP1` VARCHAR NULL DEFAULT NULL,
`TYP2` VARCHAR NULL DEFAULT NULL,
`TYP3` VARCHAR NULL DEFAULT NULL,
`TYP4` VARCHAR NULL DEFAULT NULL,
`subtyp1` VARCHAR NULL DEFAULT NULL,
`subtyp2` VARCHAR NULL DEFAULT NULL,
`subtyp3` VARCHAR NULL DEFAULT NULL,
`subtyp4` VARCHAR NULL DEFAULT NULL,
`subtyp5` VARCHAR NULL DEFAULT NULL,
`subtyp_lernmit` VARCHAR NULL DEFAULT NULL,
`TEST` DOUBLE NULL DEFAULT NULL,
`TESTDATUM` DATETIME NULL DEFAULT NULL,
`NEU` DOUBLE NULL DEFAULT NULL,
`NEUDATUM` DATETIME NULL DEFAULT NULL,
`KNOTEN` DOUBLE NULL DEFAULT NULL,
`KOMMENTAR` VARCHAR NULL DEFAULT NULL,
`NAME2` VARCHAR NULL DEFAULT NULL,
`URL2` VARCHAR NULL DEFAULT NULL,
`EMAIL2` VARCHAR NULL DEFAULT NULL,
`TEST2` DOUBLE NULL DEFAULT NULL,
`Expositur` CHAR NULL DEFAULT NULL,
`letztesedit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`Tel1` VARCHAR NULL DEFAULT NULL,
`FAX` VARCHAR NULL DEFAULT NULL,
`kontakt` VARCHAR NULL DEFAULT NULL,
`name_kurzform` VARCHAR NULL DEFAULT NULL,
PRIMARY KEY (`Kennummer`),
INDEX `URL` (`URL`),
INDEX `SKZ` (`SKZ`),
FULLTEXT INDEX `NAME` (`NAME`)
)
COLLATE=‘utf8_general_ci’
ENGINE=MyISAM
;
TIMESTAMP INITIALIZATION: https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.