Posted by Denis Gerina on 06/08/07 21:44

Gilles Ganault wrote:
> Hello
>
> (Sorry for asking this in a PHP ng, but I already asked in a MySQL
> forum, but got no definitive answer):
>
> I'm trying to install the authlib module that's required for
> the open-source iOutliner web-based outliner (http://ioutliner.com),
> but it fails halfway through when creating the tables:
>
> //Bad! /* SQL Error: Invalid default value for 'id' */
> $query = mysql_query("CREATE TABLE authlib_data (
> id int(11) DEFAULT '0' NOT NULL auto_increment,
> name text NOT NULL,
> email text NOT NULL,
> age int(3) DEFAULT '0' NOT NULL,
> sex text NOT NULL,
> school text NOT NULL,
> PRIMARY KEY (id)
> )");
>
> //Bad! /* SQL Error: Invalid default value for 'id' */
> $query = mysql_query("CREATE TABLE authlib_login (
> id int(11) DEFAULT '0' NOT NULL auto_increment,
> username text NOT NULL,
> password text NOT NULL,
> PRIMARY KEY (id)
> )");
>
> According to Google, DEFAULT '(0)' seems a legit instruction. Indeed,
> if I remove this part, it creates the table.
>
> But this error is found in both the authlib 1.96 that comes with
> iOutliner and the original file on Sourceforge:
>
> http://sourceforge.net/project/showfiles.php?group_id=20743
>
> Could it be that it's a legal bit when MySQL is compiled in a
> particular way?
>
> Thank you.


DEFAULT and auto_increment on the same column? Why, why, oh my dear God
why? :)

[Back to original message]