MyDonations 1.4.2 released .
[Solved] Shop 1.8 issue

I got New Points installed and working great. I wanted to install the shop plugin. This is the sql error I get when trying to install/activate:

SQL Error:
   1067 - Invalid default value for 'items_rate'
   ALTER TABLE `mybb_newpoints_grouprules` ADD `items_rate` DECIMAL(3,3) NOT NULL default '1';


So I chanted the mysql query to this
$db->write_query("ALTER TABLE `".TABLE_PREFIX."newpoints_grouprules` ADD `items_rate` DECIMAL(3,3) NOT NULL default '1,0';");
It installed, but now I don't see the "Shop" tag in the New Point admin to add the categories.

So, it wasn't working because I wasn't logged into my "Super Admin" account. Once I logged into that account, the shop worked fine.
[Image: fbesig.png]

Unfortunately you do not have sufficient rights to view replies in this thread. For full access, consider upgrading .

Users browsing this thread: 1 Guest(s)

About MyBB-Plugins

Plug Yourself into the best MyBB AddOn.

Copyright © 2009-2021 MyBB-Plugins Forums.


  • 51,000+ Posts
  • 19,000+ Members
  • 3,600+ Threads

Impressed? For sure
Check Full Stats here