Home ›
auto_increment columns cannot have a default valueauto_increment columns cannot have a default value
Submitted by Benjamin Melançon on August 19, 2007 - 11:27am
Makes sense I guess...
So this is good:
tid int(10) unsigned NOT NULL auto_increment,
Just make sure you don't have "default '0'" anywhere in there.
You don't want to see this on your site:
user warning: Invalid default value for 'tid' query: cmt_install CREATE TABLE joe_cmt_term_data ( tid int(10) unsigned NOT NULL DEFAULT '0' auto_increment, name varchar(255) NOT NULL DEFAULT '', weight tinyint NOT NULL DEFAULT '0' ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /Applications/MAMP/htdocs/joeaustin/includes/database.mysql.inc on line 172.
Makes sense I guess...
So this is good:
tid int(10) unsigned NOT NULL auto_increment,
Just make sure you don't have "default '0'" anywhere in there.
You don't want to see this on your site:
user warning: Invalid default value for 'tid' query: cmt_install CREATE TABLE joe_cmt_term_data ( tid int(10) unsigned NOT NULL DEFAULT '0' auto_increment, name varchar(255) NOT NULL DEFAULT '', weight tinyint NOT NULL DEFAULT '0' ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /Applications/MAMP/htdocs/joeaustin/includes/database.mysql.inc on line 172.
Comments
Post new comment