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/

_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to