Manual talk:Upgrading to 1.10/de

Mein Upgrade via Web-Installer von 1.9.3 nach 1.10.0 scheitert mit folgenden Meldungen:

Notice: Undefined property: stdClass::$Collation in /www/htdocs/w00776d8/config/index.php on line 850 Notice: Undefined property: stdClass::$Collation in /www/htdocs/w00776d8/config/index.php on line 852 Notice: Undefined property: stdClass::$Collation in /www/htdocs/w00776d8/config/index.php on line 854
 * 1) Warning: Unrecognised existing collation

Adding pr_id field to table page_restrictions...Query "ALTER TABLE `wiki_page_restrictions` ADD COLUMN pr_id int unsigned not null auto_increment,  ADD UNIQUE KEY pr_id (pr_id) " failed with error code "Specified key was too long. Max key length is 500 (localhost)".

Die Rückkehr (Neuinstallation) zu 1.9.3 funktioniert.

Was mache ich falsch?

Hallo,

ich habe denselben Fehler beum Upgrade bekommen. Auf der Page http://www.calivia.com/blog/mike/mysql-innodb-specified-key-was-too-long-when-using-utf8-encoding habe ich die folgenden Fix gefunden.

Reduce the key size for job_cmd and job_title from 255 to 160. This allows the total key size to remain below the 1000 bytes (3x (160+9+160) = 987).

I patched maintenance/tables.sql and maintenance/archives/patch-job.sql to cover first-time installation and upgrades.

- KEY (job_cmd, job_namespace, job_title) + KEY (job_cmd(160), job_namespace, job_title(160))

--195.124.178.100 08:35, 4 July 2007 (UTC)