MyBB-Plugins Forums

Full Version: Shop Plugin Didn't Work
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
Please re-install the Shop plugin
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.
Are you using MySQL?
Yes. But why ?
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...
(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
In inc/plugins/newpoints/newpoints_shop.php
(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.
Yes, you have to re-install...