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;