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,
