mySQL Default Value Error


#1

I installed a new phpBB and was using EasyMod but now none of the sql commands go through, giving me the error:

#1067 - Invalid default value for ‘flag_id’, etc.

This is happening when the script assigns a default value to the index/key. I’ve tried to manually set it to any integer, but it never works.

COMMAND:
CREATE TABLE phpbb_flags(
flag_id int( 10 ) NOT NULL DEFAULT ‘0’ AUTO_INCREMENT ,
flag_name varchar( 25 ) NULL DEFAULT ‘’,
flag_image varchar( 25 ) NULL DEFAULT ‘’,
PRIMARY KEY ( flag_id )
)

I know that sql was changed recently.
Everything was working fine last week.


#2

I don’t think it needs a default value becuase it’s auto increment. Remove the default ‘0’ bit.