MyBB-Plugins Forums
[Solved] Shop 1.8 issue - Printable Version

+- MyBB-Plugins Forums (http://forums.mybb-plugins.com)
+-- Forum: MyBB 1.8.x (http://forums.mybb-plugins.com/Forum-MyBB-1-8-x)
+--- Forum: Support (http://forums.mybb-plugins.com/Forum-Support--44)
+--- Thread: [Solved] Shop 1.8 issue (/Thread-Solved-Shop-1-8-issue)



Shop 1.8 issue - erich199 - 12-15-2014

Hi,

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:

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

Update

So I chanted the mysql query to this
Code:
$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.


No Permission

Unfortunately you do not have sufficient rights to view replies in this thread.