Issue Bug Closed

#21408Various crashes in SQL parsing when using install tool to compare and fix database.

Karsten Dambekalns 10/30/09, 11:07 updated 11/12/09, 13:37

Description

I tried updating a rather outdated TYPO3 database and got a few errors.

When updating a table where the engine type is the only difference I get:
ERROR: Query could not be parsed: “SQL engine parse ERROR: No action CHANGE, DROP or ADD found!: near “ENGINE=InnoDB “”. Query: “ALTER TABLE cache_hash ENGINE=InnoDB;”

When removing a field by prefixing the field type is missing:
ERROR: Query could not be parsed: “SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near “(250) default ‘’ ”“. Query: “ALTER TABLE cache_hash CHANGE identifier zzz_deleted_identifier (250) default ‘’;”

When dropping all tables and setting up from scratch a compare gives tons of differences in engine type and field defaults…

PHP 5.3.0, MySQL 5.0.86, TYPO3 4.x trunk as of today, 11:00+1
(issue imported from #M12404)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.