SQL Error trying to install New Points Shop 1.7

by AndresXZ09 - 02-02-2015, 11:28 PM
Closed Account
Posts:
1,383
Joined:
Jan 2015
Likes:
124
Credits:
1,332
Reputation:
30
2 Years of Service
#1
OP
Posted: 02-02-2015, 11:28 PM
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 défaut 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.
A bit cunty with a dash of fuck you.
Posts:
1,115
Joined:
Jan 2015
Likes:
70
Credits:
1,449
Reputation:
31
2 Years of Service
#2
Posted: 02-02-2015, 11:30 PM
(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 défaut 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
Closed Account
Posts:
1,383
Joined:
Jan 2015
Likes:
124
Credits:
1,332
Reputation:
30
2 Years of Service
#3
OP
Posted: 02-02-2015, 11:33 PM
(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 défaut 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'. Vérifiez s'il existe
Query:
ALTER TABLE `alko930926_users` DROP `newpoints_items`;
Please contact the MyBB Group for support.
A bit cunty with a dash of fuck you.
Posts:
1,115
Joined:
Jan 2015
Likes:
70
Credits:
1,449
Reputation:
31
2 Years of Service
#4
Posted: 02-02-2015, 11:35 PM
(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 défaut 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'. Vérifiez 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
Closed Account
Posts:
2,770
Joined:
Jan 2015
Likes:
141
Credits:
1,674
Reputation:
26
2 Years of Service
#5
Posted: 03-02-2015, 04:26 AM
(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 défaut 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'. Vérifiez 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
The last reply on this thread is older than a month. Please do not unnecessarily bump it.
Register an account or login to reply
Create an account
Create a free account today and start posting right away. It only takes a few seconds.
Login
Log into an existing account.
1 Guest(s)