15 Nov
2006
15 Nov
'06
6:38 p.m.
Hi,
The primary key of the watchers is too long with this version of MySQL:
"Specified key was too long; max key length is 1000 bytes"
Downgrading "[pw]_domain" from 128 to 96. Works.
CREATE TABLE `watchers` (
`p_user` varchar(64) NOT NULL,
`p_domain` varchar(96) NOT NULL,
`w_user` varchar(64) NOT NULL,
`w_domain` varchar(96) NOT NULL,
`subs_status` varchar(64) NOT NULL,
`reason` varchar(64) NOT NULL,
PRIMARY KEY (`p_user`,`p_domain`,`w_user`,`w_domain`)
) ENGINE=MyISAM;
Regards
--
Nicolas Palix
http://phoenix.labri.fr/people/palix/