Page 1 of 1

Problem: serendipity_permalinks - Specified key was too long

Posted: Fri Jun 03, 2005 10:49 am
by hitzi
I just upgraded to 0.9-alpha2. The update script told that there had to run a sql.

After running that i got following message.
Calling serendipity_buildPermalinks ...
Bei der Einrichtung der Installation traten einige Fehler auf:

-
CREATE INDEX plcomb_idx ON serendipity_permalinks (permalink, type);
/ Specified key was too long. Max key length is 500


Die Serendipity-Installation ist nun auf die Version 0.9-alpha2 aktualisiert.
Is that a big problem or can I use my blog still without any problems?

With best regards
Thomas

Re: Problem: serendipity_permalinks - Specified key was too

Posted: Fri Jun 03, 2005 1:28 pm
by garvinhicking
Which database and version do you use? You can still use it, the error is nonfatal. But I don't understand why it would think that the key length needs to be larger than 500.

Regards,
Garvin

Posted: Fri Jun 03, 2005 3:38 pm
by hitzi
PHP Version 5.0.4
Apache 2.0 Handler
mySQL Client API Version: 4.0.20

Posted: Fri Jun 03, 2005 4:11 pm
by garvinhicking
And which MySQL version? You only listed the client API version...

Regards,
Garvin

Posted: Fri Jun 03, 2005 5:22 pm
by hitzi
MySQL 4.0.23-Max-log