Problem: serendipity_permalinks - Specified key was too long

Having trouble installing serendipity?
Post Reply
hitzi
Regular
Posts: 5
Joined: Fri Jun 03, 2005 10:46 am

Problem: serendipity_permalinks - Specified key was too long

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Problem: serendipity_permalinks - Specified key was too

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
hitzi
Regular
Posts: 5
Joined: Fri Jun 03, 2005 10:46 am

Post by hitzi »

PHP Version 5.0.4
Apache 2.0 Handler
mySQL Client API Version: 4.0.20
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

And which MySQL version? You only listed the client API version...

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
hitzi
Regular
Posts: 5
Joined: Fri Jun 03, 2005 10:46 am

Post by hitzi »

MySQL 4.0.23-Max-log
Post Reply