database error.

[DanTHEGREAT]

On my forum, I get a database error of this:

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:
SELECT field0 FROM VFKK_userfield WHERE userid='101';;

MySQL Error : Unknown column 'field0' in 'field list'
Error Number : 1054
Request Date : Sunday, December 21st 2008 @ 08:27:52 PM
Error Date : Sunday, December 21st 2008 @ 08:27:52 PM
Script : http://freerealmsforums.com/private.php?do=showpm&pmid=5983
Referrer : http://freerealmsforums.com/private.php
IP Address : ###.88.239.151
Username : #####
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

anyone know the problem

NOTE: Happens on every function on the forums.

[ExTincTi0N]

Where are you getting this database error? when you try to send a pm?

[Medtech]

sounds like an issue with a profile field. anyone been doing any editing?

[DanTHEGREAT]

Actually, It happens to every forum I try to click, most functions on the forum..@_@

[ExTincTi0N]

Do you have any modifications on your site that are enabled?

[Medtech]

also did you remove any mods? sometimes a file may be left behind. go to admincp/ maintinance/ diagnostics/ suspect file versions. look for any files belonging to any modifications you may have removed and delete them. i had a similar issue a few hrs ago.

[DanTHEGREAT]

Yes I have over 10...@_@

[ExTincTi0N]

Try disabling all of your mods to see if that is the problem.

[DanTHEGREAT]

Well in the DB, under fieldlist is there a "field" or "field0" or both in the database because I see a column called field but no user accounts have anything filled inside of it, I am thinking that it got renamed in the structure.

[Lynne]

In the userfield table, there are field columns starting with field1, field2, etc up to however many User Profile Fields you have. vB comes with field1, field2, field3, and field4 already, so when you add a Profile Field, the next one is field5, then field6, etc. The only way there can be a field0 is if someone did something in the database. The field names are all listed in the User Profile Field Manager.

[DanTHEGREAT]

Never mind got it fixed in the mysql database.

thanks.