Hello There, Guest! › Register

MySubscriptions 2.2 released.
Looking for a custom plugin for your site? Ask here for a quote.

Shop Plugin Didn't Work
#1

I activate the shop plugin then I click Shop from the newpoints menu bar but the shop plugin didn't work it shows below message - - - -

Quote:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'podi_13521582_12381.mybb_newpoints_shop_categories' doesn't exist
Query:
SELECT * FROM mybb_newpoints_shop_categories ORDER BY disporder ASC

Please contact the MyBB Group for support.

Forum URL : http://forumforu.uni.me
[Image: 468x60_animated_1.gif]
Reply
#2

Please re-install the Shop plugin
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
Reply
#3

When I click Install and Active it shows below message . . .
Quote: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 support.
[Image: 468x60_animated_1.gif]
Reply
#4

Are you using MySQL?
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
Reply
#5

Yes. But why ?
[Image: 468x60_animated_1.gif]
Reply
#6

Because I can't seem to find anyone which such a problem.

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

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

Not sure if it will work...
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
Reply
#7

(10-03-2013, 07:12 PM)Pirata Nervo Wrote: Because I can't seem to find anyone which such a problem.

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

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

Not sure if it will work...
Look I didn't know more about this coding. Can you tell me where I would find and replace that ?Huh
[Image: 468x60_animated_1.gif]
Reply
#8

In inc/plugins/newpoints/newpoints_shop.php
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
Reply
#9

(10-04-2013, 04:46 AM)Pirata Nervo Wrote: In inc/plugins/newpoints/newpoints_shop.php
It's didn't work.

It shows ;
Quote:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'podi_13521582_12381.mybb_newpoints_shop_categories' doesn't exist
Query:
SELECT * FROM mybb_newpoints_shop_categories ORDER BY disporder ASC

Please contact the MyBB Group for support.
[Image: 468x60_animated_1.gif]
Reply
#10

Yes, you have to re-install...
To download our paid plugins and receive support you must be a paid subscriber. Click here for more information.
Reply




Users browsing this thread: 1 Guest(s)