Bug Recalculate Points Database error

[sven]

Hello,

After upgrading this mod to ver. 3.0.4 i get this database error if i start "Recalculate Points"

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE dbtech_vbactivity_points
SET registration = 0
WHERE userid = 1;

MySQL Error : Unknown column 'registration' in 'field list'
Error Number : 1054
Request Date : Saturday, March 30th 2013 @ 04:39:37 AM
Error Date : Saturday, March 30th 2013 @ 04:39:37 AM
Script : Log in - TGUElite / Gamerz - vBulletin Admin Control Panel
Referrer : Log in - TGUElite / Gamerz - vBulletin Admin Control Panel
IP Address : xxx.xx.xx.130
Username : mystiksven
Classname : vB_Database
MySQL Version : 5.5.30-cll

This user cannot be edited and/or deleted. Can this be the reason of the error ?

Many Thanks and great Easter days!

sven

 

[Fillip H.]

You can run this:

ALTER TABLE dbtech_vbactivity_points ADD registration DOUBLE NOT NULL DEFAULT '0'

to fix it

 

[sven]

Yeah this fixed it

Many Thanks Fillip and have great holidays

 

[sven]

getting this error now

Hello Fillip,

Just notice that i get another database error now after i ran the query. If i reply to a pm i get this

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT * FROM credits_pending WHERE checkstamp <= 1364720231 AND userid = 1 ORDER BY checkstamp ASC LIMIT 1;

MySQL Error : Unknown storage engine 'InnoDB'
Error Number : 1286
Request Date : Sunday, March 31st 2013 @ 01:57:11 AM
Error Date : Sunday, March 31st 2013 @ 01:57:11 AM
Script : TGUElite / Gamerz
Referrer : TGUElite / Gamerz
IP Address : xxx.xx.xx.130
Username : mystiksven
Classname : vB_Database
MySQL Version : 5.5.30-cll

Sending a new one works fine.

Many Thanks!

sven

 

[sven]

If i disable the mod this error is not shown.

 

[Fillip H.]

This is a problem with your MySQL server's configuration. Please re-enable InnoDB (comment out skip-innodb from /etc/my.cnf) or contact your host and have them do it for you if you don't know how to do that or can't find the file

 

[sven]

Many Thanks Fillip !

Before i wanted to do this i re-enabled the mod and checked the "reply pm" again - the issue wasn´t shown anymore :RpS_blink:

Seems we have a self healing mysql :RpS_laugh:

Have a great day