Mysql Error

[orgasmicsweets]

I have tried activating the shop plugin howevbernit keeps shooting this error

Code:

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(6,3) NOT NULL default '1,000';

I have read the topic whhere i have to chagee something however when I do I keep getting the same error, im not great with code so what file should i edit and what line 

Thanks in advance