The website is for sale. Check here for more information.
This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.
[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