SQL Error trying to install New Points Shop 1.7

by AndresXZ09 - 02-02-2015, 10:28 PM
Closed Account
Posts:
1,383
Joined:
Jan 2015
Likes:
123
Credits:
1,196
Reputation:
30
1 Year of Service
#1
OP
Posted: 02-02-2015, 10: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,117
Joined:
Jan 2015
Likes:
70
Credits:
1,265
Reputation:
31
2 Years of Service
#2
Posted: 02-02-2015, 10:30 PM
(02-02-2015, 10: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:
123
Credits:
1,196
Reputation:
30
1 Year of Service
#3
OP
Posted: 02-02-2015, 10:33 PM
(02-02-2015, 10:30 PM)Inferno Wrote:
(02-02-2015, 10: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,117
Joined:
Jan 2015
Likes:
70
Credits:
1,265
Reputation:
31
2 Years of Service
#4
Posted: 02-02-2015, 10:35 PM
(02-02-2015, 10:33 PM)AndresXZ09 Wrote:
(02-02-2015, 10:30 PM)Inferno Wrote:
(02-02-2015, 10: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,775
Joined:
Jan 2015
Likes:
134
Credits:
986
Reputation:
32
2 Years of Service
#5
Posted: 03-02-2015, 03:26 AM
(02-02-2015, 10:35 PM)Inferno Wrote:
(02-02-2015, 10:33 PM)AndresXZ09 Wrote:
(02-02-2015, 10:30 PM)Inferno Wrote:
(02-02-2015, 10: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)