Hi!
The problem is located at /usr/share/slash/sql/mysql/schema.sql --
there is a create statement which is a little bit strange:
CREATE TABLE moderatorlog (
id int UNSIGNED NOT NULL auto_increment,
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,
m2count mediumint UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY sid (sid,cid),
KEY sid_2 (sid,uid,cid),
KEY cid (cid)
) TYPE = myisam;
I'm not sure, if we just can set the default to 0 or if it's better to
remove the "NOT NULL" and make "NULL" the default. But an int which
defaults to the empty string is a strange idea of numbers. ;-)
I'll test it.
Regards, Axel
--
Axel Beckert - [EMAIL PROTECTED] - http://abe.home.pages.de/
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
