MyBB-Plugins Forums
Shop Help with sql.. - Printable Version

+- MyBB-Plugins Forums (http://forums.mybb-plugins.com)
+-- Forum: Archived Forums (http://forums.mybb-plugins.com/Forum-Archived-Forums)
+--- Forum: MyBB 1.6.x (http://forums.mybb-plugins.com/Forum-MyBB-1-6-x)
+---- Forum: NewPoints (http://forums.mybb-plugins.com/Forum-NewPoints)
+---- Thread: Shop Help with sql.. (/Thread-Shop-Help-with-sql)



Shop Help with sql.. - swan524 - 04-12-2014

Hello,

I have a problem with sql when i install shop.

http://prntscr.com/399obd
http://prntscr.com/399od8

What are the problem ?

Thanks for your help.

*Sorry for my english, i'm french*


RE: Shop Help with sql.. - Diogo Parrinha - 04-12-2014

The shop is not properly installed, please re-install.


RE: Shop Help with sql.. - swan524 - 04-12-2014

I have this error when i install -> http://prntscr.com/399obd

And, when i check the plugin with the newpoint panel i have this : http://prntscr.com/399od8

It's a problem with dbquery ? My db is on wamp and mybb are connected in mysqli.


RE: Shop Help with sql.. - Diogo Parrinha - 04-13-2014

Your MySQL setup doesn't seem to allow an integer default value for a decimal field. Edit the PHP file and find "decimal(16,2)" and remove the "default '1'" part.


RE: Shop Help with sql.. - swan524 - 04-13-2014

It's good ?

'price' DECIMAL(16,2) NOT NULL default '1',

It's not working :/


RE: Shop Help with sql.. - swan524 - 04-13-2014

Up. It's very important..


RE: Shop Help with sql.. - Diogo Parrinha - 04-13-2014

You have to remove "default '1'"