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.
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.