tags 391825 +patch thanks Hi!
On Mon, Oct 09, 2006 at 11:12:16AM +0200, Axel Beckert wrote: > The problem is located at /usr/share/slash/sql/mysql/schema.sql -- > there is a create statement which is a little bit strange: > > [...] > sid mediumint UNSIGNED DEFAULT '' NOT NULL, > ^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^ > [...] > > 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. ;-) Defaulting sid to 0 seems to work fine. Installation then works, too. The patch is attached. Regards, Axel -- Axel Beckert - [EMAIL PROTECTED] - http://abe.home.pages.de/
--- slash-2.2.6/sql/mysql/slashschema_create.sql 2006-10-09 11:06:55.000000000 +0200 +++ /usr/share/slash/sql/mysql/schema.sql 2006-10-09 11:58:47.000000000 +0200 @@ -332,7 +332,7 @@ id int UNSIGNED NOT NULL auto_increment, uid mediumint UNSIGNED NOT NULL, val tinyint DEFAULT '0' NOT NULL, - sid mediumint UNSIGNED DEFAULT '' NOT NULL, + sid mediumint UNSIGNED DEFAULT '0' NOT NULL, ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, cid mediumint UNSIGNED NOT NULL, cuid mediumint UNSIGNED NOT NULL,