[Slashcode-general] One Error Fixed, one new one now.

[Blake C. <li...@li...>]

I installed and reinstalled mysql, using rpms, which was my problem before
that shane caught.

MySQL-client-standard-4.1.15-0.rhel3
MySQL-shared-standard-4.1.15-0.rhel3
perl-DBD-MySQL-2.1021-3
MySQL-python-0.9.1-6
MySQL-server-standard-4.1.15-0.rhel3
libdbi-dbd-mysql-0.6.5-5
MySQL-devel-4.1.15-0.glibc23


/DBIx/Password.pm seems to be ok
I can connect to MySQL as the user/password listed in there.

Here's the error I get after running install-slashcode:
But the odd thing that's confusing me is, I "show tables" in the slash db
in mysql, and it shows
abusers....templates 53 rows in set (0.00 sec)
So it's like it makes 53 tables, gets to topics, and fails.


DBD::mysql::db do failed: Invalid default value for 'tid' at
./install-slashsite line 395.
The CREATE TABLE command below failed.  This almost certainly means
the rest of the slashsite installation will fail, so we're aborting.
This is probably because your SQL user associated with your
DBIx::Password user 'slash' lacks CREATE and/or DROP permissions.
Fix this, or whatever the problem is, and rerun install-slashsite.
Failed command: CREATE TABLE topics (   tid smallint UNSIGNED NOT NULL
DEFAULT 0 auto_increment,        parent_topic smallint UNSIGNED DEFAULT 0
NOT NULL,      name char(20) NOT NULL,        alttext char(40),      
default_image mediumint UNSIGNED DEFAULT 0 NOT NULL,    series tinyint
DEFAULT 0 NOT NULL,      PRIMARY KEY (tid)) TYPE=InnoDB