Thread:Project:Support desk/mysql error 1064 when run update.php

Hello,

I try to update my mediawiki from Version 1.11.2 to Version 1.15.5. When I run update.php I get following error: Creating protected_titles table...Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage lautete: „CREATE TABLE `protected_titles` ( pt_namespace int NOT NULL, pt_title varchar(255) binary NOT NULL, pt_user int unsigned NOT NULL, pt_reason tinyblob, pt_timestamp binary(14) NOT NULL, pt_expiry varbinary(14) NOT NULL default '', pt_create_perm varbinary(60) NOT NULL, PRIMARY KEY (pt_namespace,pt_title), KEY pt_timestamp (pt_timestamp) ) TYPE=InnoDB “ aus der Funktion „Database::sourceStream“. Die Datenbank meldete den Fehler: „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 'TYPE=InnoDB' at line 11 (carl.springfield)“.

I use MySQL 5.5.32 now, before it was MySQL 5.0. I hope you can help me with this issue.

Thanks imker25