Database error on forum edit or add

[Cpt. Spaulding]

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE forum SET
	title_clean = 'General Mayhem',
	title = 'General Mayhem',
	description_clean = 'Not for mortal beings...',
	description = 'Not for mortal beings...',
	link = '',
	displayorder = 1,
	parentid = 110,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options - 8192, options),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options - 1024, options),
		options = IF(options & 2048, options - 2048, options),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
	styleid = 0,
	password = '',
	accessf_nb = 0,
	accesst_nb = 0,
	create_nb = 0,
	reply_nb = 0,
	forum_hlfg = '0'
WHERE forumid = 132;

MySQL Error  : Unknown column 'forum_hlfg' in 'field list'
Error Number : 1054
Date         : Monday, February 25th 2008 @ 09:53:38 PM
Script       : xxxxxxxxxxxxxxxxxxxxxxx
Referrer     : xxxxxxxxxxxxxxx
IP Address   :xxxxxxxxxxxxx
Username     : xxxxxxxxxxxxxxxxxx
Classname    : vb_database

[Jake Bunce]

"forum_hlfg" is not a default field in the forum table. That reference must be from custom code. Try disabling your plugins:

Admin CP -> vBulletin Options -> Plugin/Hook System

Also run a file check to look for customized files:

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Cpt. Spaulding]

any idea as to how I would find out witch mod added forum_hlfg

[Jake Bunce]

It's it's from an addon then you can systematically disable your products until you isolate the problem:

Admin CP -> Plugins & Products -> Product Manager -> Disable (in each product menu)

[Cpt. Spaulding]

thank you for your help. time to get to work.