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.
Code:
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'
|