SQL ERROR

[Reece^B]

See Attached:

Database error in vBulletin 4.2.1:

Invalid SQL:
UPDATE userfield SET
field2 = '',
field3 = '',
field4 = '',
field7 = '',
field6 = 'top'
WHERE userid = 2;

MySQL Error : Unknown column 'field6' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 10th 2013 @ 09:23:05 PM
Error Date : Tuesday, September 10th 2013 @ 09:23:05 PM
Script : http://www.stangforums.co.uk/admincp/user.php?do=update
Referrer : http://www.stangforums.co.uk/admincp/user.php?do=edit&u=2
IP Address : 82.12.186.83
Username : Bruce
Classname : vB_Database
MySQL Version : 5.0.95-log

Field 6?! This is causing me grief when I edit users in the AdminCP.

[ForceHSS]

It means that it is missing. Just add it again and all will be ok

[Reece^B]

Manually a table? Or through Admincp?

[ForceHSS]

do you only have 5 profile fields now if you do then do this

Run this first if error still showing then add missing field6 again from admincp
ALTER TABLE `profilefield`
AUTO_INCREMENT=6;