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

[Leoncini X. <xa...@ny...>]

Not taking of the not null did not do the trick
So I put the default values at 'O' and things went ok.
Also all the als related tables do not have a drop before they are created=
=20
which causes trouble when trying a second install.
There is also a similar problem as the not null one in the bob plugin for t=
he=20
table story_files or something like that.
All of these may be related to the mysql 5.0 I use, I do not know.
Thanks for your help anyway, it helped me dare to change the schema
Xavier
Le Mardi 24 Janvier 2006 03:26, Blake Carver a =E9crit :
> 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 dateti=
me
> > 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=3DInnoDB
> >
> > 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 kn=
ow
> > 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=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> > _______________________________________________
> > Slashcode-general mailing list
> > Sla...@li...
> > https://lists.sourceforge.net/lists/listinfo/slashcode-general
>
> -------------------------------------------------------
> 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=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general