I found this error while trying to install vb2 on my web server.
In all MySQL Database Version 4.1.7 and maybe an others CREATE TABLE queries (/admin/install.php?step=4) that have auto_increment and DEFAULT value
such as
the error was
when I delete the DEFAULT '0' it works correctly.
note that you can delete auto_increment field property (to let install works) but any query have this style
INSERT INTO xxx VALUES(NULL,xxx,....,xxx)
doesn't work
So use this code
this type is used in vb3 and that's it.
you must fix it as soon as you can
I'm sure that I say the truth.
Tables that have this error:
and what make me marvelling that this table
useractivation
already fixed.
In all MySQL Database Version 4.1.7 and maybe an others CREATE TABLE queries (/admin/install.php?step=4) that have auto_increment and DEFAULT value
such as
Code:
$query[]="CREATE TABLE word ( wordid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, title char(50) NOT NULL, PRIMARY KEY (wordid) )";
Code:
mysql error: Invalid default value for 'wordid' mysql error number: 1067
note that you can delete auto_increment field property (to let install works) but any query have this style
INSERT INTO xxx VALUES(NULL,xxx,....,xxx)
doesn't work
So use this code
Code:
$query[]="CREATE TABLE word ( wordid int(10) unsigned NOT NULL auto_increment, title char(50) NOT NULL, PRIMARY KEY (wordid) )";
you must fix it as soon as you can
I'm sure that I say the truth.
Tables that have this error:
- adminlog
- announcement
- attachment
- avatar
- bbcode
- calendar_events
- forum
- forumpermission
- icon
- moderator
- poll
- pollvote
- post
- privatemessage
- profilefield
- replacement
- replacementset
- search
- setting
- settinggroup
- smilie
- style
- subscribeforum
- subscribethread
- template
- templateset
- thread
- threadrate
- user
- usergroup
- usertitle
- word
and what make me marvelling that this table
useractivation
already fixed.
Comment