Opened 16 years ago

Closed 16 years ago

#112 closed defect (invalid)

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

Reported by: anonymous Owned by: rjl
Priority: high Milestone: 1.0.0
Component: SQL scripts Version: 1.0.0 RC5
Severity: blocker Keywords: mysql 4.1 id default
Cc:

Description

Hi!

I'm trying to create the Maia database with the following command:

cd /root/maia-1.0.0-rc5-2 /usr/local/mysql/bin/mysql -u root --password=<myPassword> <maia-mysql.sql

and I get the following error:

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

I use MySQL v4.1.7.

Thanks,

  • Mike Nadeau

Change History (1)

comment:1 Changed 16 years ago by rjl

  • Keywords mysql 4.1 id default added
  • Resolution set to invalid
  • Status changed from new to closed

Use the maia-mysql.sql script from the subversion repository. This version removes the "DEFAULT" clauses from auto_increment columns, which cause problems with MySQL 4.1.

Note: See TracTickets for help on using tickets.