|
|
Posted by Jerry Stuckle on 06/09/07 02:57
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.
You got a perfectly good (and perfectly correct) response from Willem
Bogaerts in comp.database.mysql with in 24 minutes of your original
posting. You even responded to it.
If you didn't like the answer, you should have requested a clarification
instead of taking to to another newsgroup where it's off-topic.
Or, since it's from Sourceforge, you should have asked in the project
support.
This is NOT the place to be asking mysql questions. That's why
comp.databases.mysql was created.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|