Re: [Slashcode-general] Problem with install slash site

[Blake C. <li...@li...>]

sid mediumint UNSIGNED DEFAULT '' NOT NULL,

I think it's  that NOT NULL, some versions of MySQL will take it and some 
won't for a default ''
If I remember right, this has been fixed in CVS, this was a problem in 2 or 
three tables I think.

--------------
Blake Carver
LISNews.org
Librarian & Information Science News
http://www.lisnews.org

----- Original Message ----- 
From: "Leoncini Xavier" <xa...@ny...>
To: <sla...@li...>
Sent: Monday, January 23, 2006 6:26 PM
Subject: [Slashcode-general] Problem with install slash site


> Hello,
> I have the following problem when trying to install a new slash system 
> with
> cvs T_2_5_0_95 same with 96
> I use mysql 5
> The script fails at the following command saying my vuser lacks drop and
> create privileges
>
>
> CREATE TABLE moderatorlog (     id int UNSIGNED NOT NULL auto_increment,
> ipid char(32) DEFAULT '' NOT NULL,      subnetid char(32) DEFAULT '' NOT
> NULL,        uid mediumint UNSIGNED NOT NULL,        val tinyint DEFAULT 
> '0'
> NOT NULL,       sid mediumint UNSIGNED DEFAULT '' NOT NULL,   ts datetime
> DEFAULT '0000-00-00 00:00:00' NOT NULL,     cid mediumint UNSIGNED NOT 
> NULL,
> cuid mediumint UNSIGNED NOT NULL,       reason tinyint UNSIGNED DEFAULT 
> '0',
> active tinyint DEFAULT '1' NOT NULL,    spent tinyint DEFAULT '1' NOT 
> NULL,
> m2count mediumint UNSIGNED DEFAULT '0' NOT NULL,      m2needed mediumint
> UNSIGNED DEFAULT '0' NOT NULL,       m2status tinyint DEFAULT '0' NOT 
> NULL,
> points_orig tinyint DEFAULT NULL,    PRIMARY KEY (id),        KEY sid
> (sid,cid),      KEY sid_2 (sid,uid,cid),        KEY cid (cid),  KEY ipid
> (ipid),        KEY subnetid (subnetid),     KEY uid (uid),   KEY cuid 
> (cuid),
> KEY m2stat_act (m2status,active),       KEY ts_uid_sid (ts,uid,sid))
> TYPE=InnoDB
>
> When typed directly in the mysql prompt the error is:
>
> ERROR 1067 (42000): Invalid default value for 'sid'
>
> If I put '0' instead of '' then the command passes. I however do not know
> which default value is best to put.
> Thanks in advance
> Xavier
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log 
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>
>