SQL Error trying to install New Points Shop 1.7

Hello

I'm trying to install the Shop 1.7 on New Points 1.9.8 but I got this error:


I'm using the last version of MyBB 1.6.

Hope you can help me.

02-02-2015, 11:28 PM

AndresXZ09 Wrote: Hello

I'm trying to install the Shop 1.7 on New Points 1.9.8 but I got this error:

Code:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1067 - Valeur par dfaut invalide pour '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.

I'm using the last version of MyBB 1.6.

Hope you can help me.

Upgrade to new points 1.9.9 http://forums.mybb-plugins.com/Thread-NewPoints-1-9-9

02-02-2015, 11:30 PM

Inferno Wrote:

02-02-2015, 11:28 PM

AndresXZ09 Wrote: Hello

I'm trying to install the Shop 1.7 on New Points 1.9.8 but I got this error:

Code:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1067 - Valeur par dfaut invalide pour '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.

I'm using the last version of MyBB 1.6.

Hope you can help me.

Upgrade to new points 1.9.9 http://forums.mybb-plugins.com/Thread-NewPoints-1-9-9

I cann't uninstall 1.9.8 it says:

02-02-2015, 11:33 PM

AndresXZ09 Wrote:

02-02-2015, 11:30 PM

Inferno Wrote:

02-02-2015, 11:28 PM

AndresXZ09 Wrote: Hello

I'm trying to install the Shop 1.7 on New Points 1.9.8 but I got this error:

Code:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1067 - Valeur par dfaut invalide pour '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.

I'm using the last version of MyBB 1.6.

Hope you can help me.

Upgrade to new points 1.9.9 http://forums.mybb-plugins.com/Thread-NewPoints-1-9-9

I cann't uninstall 1.9.8 it says:

Code:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Ne peut effacer (DROP) 'newpoints_items'. Vrifiez s'il existe
Query:
ALTER TABLE `alko930926_users` DROP `newpoints_items`;
Please contact the MyBB Group for support.

If your forum isnt warez please post a thread here

02-02-2015, 11:35 PM

Inferno Wrote:

02-02-2015, 11:33 PM

AndresXZ09 Wrote:

02-02-2015, 11:30 PM

Inferno Wrote:

02-02-2015, 11:28 PM

AndresXZ09 Wrote: Hello

I'm trying to install the Shop 1.7 on New Points 1.9.8 but I got this error:

Code:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1067 - Valeur par dfaut invalide pour '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.

I'm using the last version of MyBB 1.6.

Hope you can help me.

Upgrade to new points 1.9.9 http://forums.mybb-plugins.com/Thread-NewPoints-1-9-9

I cann't uninstall 1.9.8 it says:

Code:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Ne peut effacer (DROP) 'newpoints_items'. Vrifiez s'il existe
Query:
ALTER TABLE `alko930926_users` DROP `newpoints_items`;
Please contact the MyBB Group for support.

If your forum isnt warez please post a thread here

Its not warez. Its a bug, I remember I had to fix this on someones forum before, don't remember whos I think it was AlphaBoards but anyways, PM me