From: Leoncini X. <xa...@ny...> - 2006-01-23 23:29:37
|
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 |
From: Blake C. <li...@li...> - 2006-01-24 02:26:57
|
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 > > |
From: Leoncini X. <xa...@ny...> - 2006-01-25 00:02:17
|
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 |
From: Jamie M. <ja...@mc...> - 2006-01-27 00:28:42
|
xa...@ny... (Leoncini Xavier) writes: > So I put the default values at 'O' and things went ok. =46ixed in CVS, thanks. > Also all the als related tables do not have a drop before they > are create which causes trouble when trying a second install. A second install in the same database? Follow the "UNINSTALLING" section at the end of the INSTALL file. When doing an uninstall you should DROP the database. --=20 Jamie McCarthy http://mccarthy.vg/ ja...@mc... |
From: Leoncini X. <xa...@ny...> - 2006-01-27 19:21:30
|
Hello, I notioced this when I had forgotten to drop the database. the install slash had failed and stopped due to the previous reasons, and = I=20 reran it right after. I think it should not matter for a frsh install if all tables are droped=20 before being recreated. Le Vendredi 27 Janvier 2006 01:24, Jamie McCarthy a =E9crit : > xa...@ny... (Leoncini Xavier) writes: > > So I put the default values at 'O' and things went ok. > > Fixed in CVS, thanks. > > > Also all the als related tables do not have a drop before they > > are create which causes trouble when trying a second install. > > A second install in the same database? Follow the "UNINSTALLING" > section at the end of the INSTALL file. When doing an uninstall > you should DROP the database. |
From: shane <sh...@lo...> - 2006-01-27 22:31:05
|
On Jan 27, 2006, at 2:11 PM, Leoncini Xavier wrote: > Hello, > I notioced this when I had forgotten to drop the database. > the install slash had failed and stopped due to the previous =20 > reasons, and I > reran it right after. > I think it should not matter for a frsh install if all tables are =20 > droped > before being recreated. > > Le Vendredi 27 Janvier 2006 01:24, Jamie McCarthy a =E9crit : >> xa...@ny... (Leoncini Xavier) writes: >>> So I put the default values at 'O' and things went ok. >> >> Fixed in CVS, thanks. >> >>> Also all the als related tables do not have a drop before they >>> are create which causes trouble when trying a second install. >> >> A second install in the same database? Follow the "UNINSTALLING" >> section at the end of the INSTALL file. When doing an uninstall >> you should DROP the database. the thing of it is that when you 'uninstall' a slash site, it is not =20= just a matter of dropping the database. there's also definitions of =20 the site in slash's slash.sites data file, etc. two useful scripts here: 1. backup a slash site's db: http://slash.lottadot.com/files/backupslashdb.plx 2. uninstall a slash-site: http://slash.lottadot.com/files/uninstallslashsite.plx Shane -- My slashcode stuff: http://slash.lottadot.com/ |