MyBB Community Forums

I got these error trying to install the shop

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1067 - Invalid default value for 'items_rate'
Query:
ALTER TABLE mybb_newpoints_grouprules ADD items_rate DECIMAL(3,3) NOT NULL default '1';
Please contact the MyBB Group for technical support.

Any idea?

see replies here

My Newpoints don't have that text line, the most similar it have is this one:

Quote: $db->write_query("ALTER TABLE ".TABLE_PREFIX."newpoints_grouprules ADD items_rate DECIMAL(3,3) NOT NULL default '1';");

Edit: That's exactly the line you should edit, thank you guys.