Bug Database error in vBulletin 4.2.0

[Nirjonadda]

Hello
Database error in vBulletin 4.2.0,How to fix on this issue?

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE vbdbtech_vbactivity_points
SET registration = registration + 25
WHERE userid = '34254';

MySQL Error : Unknown column 'registration' in 'field list'
Error Number : 1054
Request Date : Saturday, March 16th 2013 @ 10:24:09 PM
Error Date : Saturday, March 16th 2013 @ 10:24:10 PM
Script : http://www.mysite.com/register.php?do=addmember
Referrer : http://www.mysite.com/register.php?do=addmember
IP Address : 110.227.205.136
Username : abartumi
Classname : vB_Database
MySQL Version :

 

[Fillip H.]

Run

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

and it should be fixed for you.

 

[Nirjonadda]

How to Run ? I don't understand about Database Query,Please can you hotfix on this issue? Why does not Auto added database table on while installing.

 

[Fillip H.]

How to Run ? I don't understand about Database Query

Use "Execute SQL Queries" in the AdminCP.

Please can you hotfix on this issue?

I have, but the issue was with the installer file and you have already ran that by upgrading to v3.0.3

Why does not Auto added database table on while installing.

Because I missed adding it to the installer code when creating the update, and testing did not reveal this because I had manually added it to the database for development.

 

[Nirjonadda]

Query
ALTER TABLE vbdbtech_vbactivity_points ADD registration DOUBLE NOT NULL DEFAULT '0'


vBulletin Message
Affected Rows: 28,839 (0.2741s)

Does fixed?

 

[Fillip H.]

Yes, that fixed it

 

[djFarsang]

I do following this process but there are shown:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'baanfars_ang.vbdbtech_vbactivity_points' doesn't exist

My issue:

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 : Sunday, March 17th 2013 @ 12:54:44 AM
Error Date : Sunday, March 17th 2013 @ 12:54:47 AM
Script : http://www.baanfarsang.com/admincp/vbactivity.php?do=maintenance
Referrer : http://www.baanfarsang.com/admincp/vbactivity.php?do=maintenance

 

[Fillip H.]

Run

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

and it should be fixed for you.


To avoid further confusion, I'll close this thread so that anyone else affected by this issue can create their own thread and be given customised help specific to their forum