[fly]

EEK!

I recently upgraded to 3.8 and simply overwrote this hack with the 3.6 version. Now I have thread descriptions duplicated. What have I done?

edit: Fixed that. I just had to remove my TMS template edits from the 3.6 version. However, I now have this error when trying to enable thread descriptions for a forum.

Invalid SQL:
UPDATE forum SET
	title_clean = 'Useless Chatter',
	title = 'Useless Chatter',
	description_clean = 'the intarweb den of sin',
	description = 'the intarweb den of sin',
	link = '',
	displayorder = 1,
	parentid = 3,
	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, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
		options = IF(options & 131072, options - 131072, options),
	styleid = 0,
	imageprefix = '',
	password = '',
	requireicon = 1,
	accessf_nb = 0,
	accesst_nb = 0,
	create_nb = 0,
	reply_nb = 0,
	attach_nb = 0,
	linkview_nb = 0,
	linkpost_nb = 5,
	vbbux_perview = 1,
	vbbux_perthread = 1,
	vbbux_perpost = 1,
	### Bitfield: forum.vbplaza_forum_options ###
		vbplaza_forum_options = IF(vbplaza_forum_options & 16, vbplaza_forum_options - 16, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 32, vbplaza_forum_options - 32, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 64, vbplaza_forum_options - 64, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 128, vbplaza_forum_options - 128, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 256, vbplaza_forum_options - 256, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 512, vbplaza_forum_options - 512, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 1024, vbplaza_forum_options, vbplaza_forum_options + 1024),
		vbplaza_forum_options = IF(vbplaza_forum_options & 2048, vbplaza_forum_options, vbplaza_forum_options + 2048),
		vbplaza_forum_options = IF(vbplaza_forum_options & 4096, vbplaza_forum_options, vbplaza_forum_options + 4096),
		vbplaza_forum_options = IF(vbplaza_forum_options & 8192, vbplaza_forum_options, vbplaza_forum_options + 8192),
		vbplaza_forum_options = IF(vbplaza_forum_options & 16384, vbplaza_forum_options, vbplaza_forum_options + 16384),
		vbplaza_forum_options = IF(vbplaza_forum_options & 32768, vbplaza_forum_options, vbplaza_forum_options + 32768),
		vbplaza_forum_options = IF(vbplaza_forum_options & 65536, vbplaza_forum_options, vbplaza_forum_options + 65536),
		vbplaza_forum_options = IF(vbplaza_forum_options & 131072, vbplaza_forum_options, vbplaza_forum_options + 131072),
		vbplaza_forum_options = IF(vbplaza_forum_options & 262144, vbplaza_forum_options, vbplaza_forum_options + 262144),
		vbplaza_forum_options = IF(vbplaza_forum_options & 524288, vbplaza_forum_options, vbplaza_forum_options + 524288),
		vbplaza_forum_options = IF(vbplaza_forum_options & 1048576, vbplaza_forum_options - 1048576, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 2097152, vbplaza_forum_options - 2097152, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 4194304, vbplaza_forum_options - 4194304, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 8388608, vbplaza_forum_options - 8388608, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 16777216, vbplaza_forum_options - 16777216, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 1, vbplaza_forum_options - 1, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 2, vbplaza_forum_options - 2, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 4, vbplaza_forum_options - 4, vbplaza_forum_options),
		vbplaza_forum_options = IF(vbplaza_forum_options & 8, vbplaza_forum_options - 8, vbplaza_forum_options),
	vbplaza_cangetaccesscost = 0,
	vbplaza_cangiveaccesscost = 0,
	vbplaza_candenyaccesscost = 0,
	vbplaza_cangetpasswordcost = 0,
	descriptiondefault = '1'
WHERE forumid = 4;

MySQL Error   : Unknown column 'descriptiondefault' in 'field list'