#2 Install Problem

[Brad Jensen]

Trying to install your software and think I have the
pre-requisites all locked up but running into a problem
when trying to run the .sql script to build the DB. I
get the following error:

ERROR 1067 (42000) at line 18: Invalid default value
for 'id'

Trying to install this with the following:

Apache 2.x
PHP 4.3.11
Perl 5.8.5 (Net::IP and Net::DNS installed)
MySQL 4.1.11

OS - Fedora Core 3

Sure this is something stupid I am missing but your
help would be greatly appreciated.

Thanks -

Brad

[Marcos Daniel Marado Torres]

Logged In: YES
user_id=512911
Originator: NO

This happens because you're using a recent version of MySQL (5). To support MySQL 5, the packaging should include this .sql file in it's next version:

[Marcos Daniel Marado Torres]

Logged In: YES
user_id=512911
Originator: NO

Erm, here's the file (I can't find a way of submit an attachment :-/ )
http://noori.abismo.org/mktables-mysql5.sql

[Tim (TJ) Snider]

This is due to a mysql issue, you can't have a default value for auto incrementing fields, remove all the default values for fields with auto-increment.