Bug Database error in vBulletin 4.2.2

[Nirjonadda]

I have Database error , please check and give me fix update.

Database error in vBulletin 4.2.2:

Invalid SQL:

UPDATE vbusertextfield
SET
rank = '<img src="images/ranks/contributor.png" alt="" border="" />'
WHERE usertextfield.userid = '23896';

MySQL Error : Unknown column 'usertextfield.userid' in 'where clause'
Error Number : 1054
Request Date : Friday, December 27th 2013 @ 09:10:30 AM
Error Date : Friday, December 27th 2013 @ 09:10:31 AM
Script : /vbdonate_gateway.php
Referrer :
IP Address : 173.0.81.1
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

 

[Ozzy47]

Can you verify that the column, usertextfield does exist in the DB?

For Matt's sanity, this is in the file, vbdonate_gateway.php file, which Fillip mostly wrote.

 

[Nirjonadda]

I have no that column, usertextfield, but have this column, vbusertextfield

 

[Ozzy47]

Yeah that's fine, vb is your table prefix, and it is supposed to add that in the mod, UPDATE " . TABLE_PREFIX . "usertextfield, so not sure what is going on.

 

[Nirjonadda]

So How to get fixed on this issue ?

 

[Ozzy47]

Mokonzi will get to you as soon as he can.

 

[Mokonzi]

Just letting you know that I'll be taking a look at this shortly.

 

[Mokonzi]

I've isolated this issue and fixed it. It will be included in the next patch.

 

[Nirjonadda]

What files need to upload for fixing this issue? Also can you give me code for update Execute SQL Query ? Where user does not get user rank.

 

[Mokonzi]

I'll PM you the fixed details.