MyBB Community Forums

Hello!

I was able to install this ago, because some people help me out with my thread (here: http://community.mybb.com/thread-164238.html ) but I deleted the shop plugin (the zip)

Now, I want to install it again but I am not able to find

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';

So I can't replace it with

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

This is a pastebin of the file: http://pastebin.com/mNp4tkzF

This is a screenshot of the error:



Hope you can help me

I think you would need the definition of decimal to be at least 4,3 in order to have the default be 1.
Reference