15 Nov
2006
15 Nov
'06
3: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/