Help: MySQL error after making some changes....

[GTX2]

i don't know what's happening, but after replacing some user profile fields, i start receiving thousands and thousands of vbulletin database errors in my email, with this content:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT user.usergroupid, userfield.field28
FROM vbbuser AS user, vbbuserfield AS userfield
WHERE user.userid = ' 15610 '
AND userfield.userid = ' 15610 ';

MySQL Error : Unknown column 'userfield.field28' in 'field list'
Error Number : 1054
Date : Sunday, April 13th 2008 @ 12:37:39 PM
Script : http://www.myurl.com/showthread.php?t=48012
Referrer :
IP Address : xx.xxx.65.235
Username : Not registered
Classname : vB_Database

Can someone help me out?
Browsing the forums i got no errors, but i receive thousands of this email errors!

thanks

[Opserty]

MySQL Error : Unknown column 'userfield.field28' in 'field list'

What changes did you make exactly? You are probably running Plugins or something that are requesting this field and now that you have changed stuff this field no longer exists. So you may have to edit some PHP or Options accordingly.

Disable your modifications and see if your problem persists.

[GTX2]

how can i create again field28? I think problem will be solved if i create again that field number, but now everytime i create a field it goes up and up field29, field30, field31, field32 and so on...

[Dismounted]

Originally Posted by GTX2

how can i create again field28? I think problem will be solved if i create again that field number, but now everytime i create a field it goes up and up field29, field30, field31, field32 and so on...

You don't. All fields have a unique identifier and it auto increments. You will have to change whatever is trying to access field28 to your new field.

[GTX2]

i've found the problem: was the hack vb ad management, that was requesting the field28 for shared advertisements. just disabled the shared advertisements.

thank you!