Quote:
|
Originally Posted by void4ever
CREATE TABLE `invite_users` (
`ftp_user` varchar(255) NOT NULL default '', -- FTP user name.
`irc_user` varchar(255) default NULL, -- IRC user name.
`online` tinyint(1) NOT NULL default '0', -- Indicates if the user is on IRC.
`password` varchar(255) default NULL, -- Password hash (PKCS #5 v2 based).
`time` int(10) NOT NULL default '0', -- Time stamp of last activity.
PRIMARY KEY (`ftp_user`)
);
|
In this case, the key is based on the ftp_user field and thus the key is 255 chars long.
Quote:
|
Originally Posted by void4ever
CREATE TABLE `invite_hosts` (
`ftp_user` varchar(255) NOT NULL default '', -- FTP user name.
`hostmask` varchar(255) NOT NULL default '', -- IRC host mask (ident@host).
PRIMARY KEY (`ftp_user`,`hostmask`)
);
|
In this case, the key is based on both the ftp_user
and the hostmask fields and thus it's 2 * 255 = 510 chars long. It looks like this version of mysql can't handle more than 500 chars for the key.
If you're sure both versions are identical, it might be something else like an ini setting. I'm afraid I can't help you much with the mysql daemon configuration. I'm using databases, I'm not administrating them.