MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Can't DROP 'newpoints_items'; check that column/key exists
Query:
ALTER TABLE `mybb_users` DROP `newpoints_items`;
Please contact the MyBB Group for technical support.

and when i try to create a group in mybb shop i got an error to

MyBB SQL Error
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.

D: what can i do :c

Great support is offered at the developer's website http://forums.mybb-plugins.com/Forum-NewPoints

SOLVED
just change this

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

to this

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

in the file \Shop 1.8\Upload\inc\plugins\newpoints\newpoints_shop.php

and its done :3 deactivate and active it again in the newpoints plugins


thanks to erich199

Yes, I discovered this yesterday on my own board. Glad my post was able to help!

(2014-12-15, 11:41 PM)acidrain Wrote: [ -> ]SOLVED
just change this

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

to this

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

in the file \Shop 1.8\Upload\inc\plugins\newpoints\newpoints_shop.php

and its done :3 deactivate and active it again in the newpoints plugins


thanks to erich199

This did the job. Thanks man.