Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

[-]
Tags
problem mybb here other i gat and pedro pls

Pls Pedro And Other I Gat A Problem Here On Mybb
#1
I want to install newpoints shop
plugin but I could not do so. Because when I was
trying to activate the plugin, I just got below
message.......


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 `***_newpoints_grouprules` ADD
`items_rate` DECIMAL(3,3) NOT NULL default '1';


Pls help me out newpoint shop
Ban reason: Banned for gross spamming and promoting shady business. (1y, 7m, 3w, 4d, 1h, 5m remaining)
#2
just change this

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

to this
Code:
$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
#3
(08-03-2017 08:57 PM)patrick Wrote: just change this

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

to this
Code:
$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

@patrick
Pls gimme ur facebook username
Ban reason: Banned for gross spamming and promoting shady business. (1y, 7m, 3w, 4d, 1h, 5m remaining)
#4
Ozi Patrick
  


Possibly Related Threads...
ThreadAuthor Replies Views Last Post
  HELP: Help Me Install Mybb On My Hosting I Will Pay Jadonking042 2 91 12-09-2017, 08:31 PM
Last Post: Badooskid
  HELP: I Need Mybb Help prince 2 62 11-07-2017, 07:33 PM
Last Post: prince
  I Need The Premium Version Of Mybb Plugin For Moving Threads To Front Page Otahumele 0 46 11-02-2017, 06:32 PM
Last Post: Otahumele
  HELP: Please Pedro Come In Dhron 7 71 11-01-2017, 12:00 PM
Last Post: Dhron
  How To Add A Beautiful Pagination On Mybb Pedro 1 190 10-31-2017, 05:16 PM
Last Post: Dhron
  How Can I Unforce Mybb Theme on Users donblade 0 63 10-20-2017, 02:56 PM
Last Post: donblade
  HELP: How To Edit Mybb Template prince 15 195 10-18-2017, 12:15 AM
Last Post: prince
  How To Code A Simple Jquery Drop Down Login Form For Mybb James 3 162 10-16-2017, 10:44 AM
Last Post: kharlm



Users browsing this thread:
1 Guest(s)

List of Users who browsed this thread: 9Jahype, ayodelesegun, Bigga, cbanklee, Cybersky, daweb, Dhron, donblade, eminithunderlee, Gift, patrick, Pedro, Plus, Spidey, tyroklone, ugwuanyiKevin
Pls Pedro And Other I Gat A Problem Here On Mybb00