[ php-blog-Bugs-1739682 ] serendipity_exits has too long primary key

Bugs item #1739682, was opened at 2007-06-19 14:03
Message generated for change (Comment added) made by kink
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1739682&group_id=75065

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Installer/Upgrader
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Thijs Kinkhorst (kink)
Assigned to: Nobody/Anonymous (nobody)
Summary: serendipity_exits has too long primary key

Initial Comment:
Hello,

When using the current (sy9 1.1.3) DB schema with a recent MySQL version (5.0.41), I get the following MySQL error:

"Specified key was too long; max key length is 1000 bytes"

The problem is with "PRIMARY KEY  (host,path,day,entry_id)". When using that with a multibyte charset in MySQL, the key length exceeds the default 1000.

Since multibyte charsets are something that should be supported in an international world, I think s9y should be fixed to cope with this.

The best solution in my opinion is to just remove the primary key. A key is only useful if it's relatively short; a key of such great a length doesn't add much value I think.

Alternatively the table could get an auto_incrementing column.


thanks,
Thijs

----------------------------------------------------------------------

>Comment By: Thijs Kinkhorst (kink)
Date: 2007-06-19 14:12

Message:
Logged In: YES 
user_id=285765
Originator: YES

It actually applies to some other keys aswell. Having keys of lengths >>
255 chars does not add much value I think, but may break stuff.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1739682&group_id=75065

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/