MySQL Error 1054 : Unknown column 'forumid' in 'field list'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Whitesky
    New Member
    • Dec 2007
    • 16
    • 3.8.x

    [CMS] MySQL Error 1054 : Unknown column 'forumid' in 'field list'

    I keep getting the following when trying to update settings for a 3rd-party addon in ACP:

    HTML Code:
    Database error in vBulletin 4.1.3:
    
    Invalid SQL:
    update clan_wars_config set rowsperpage='30', dateformat='dd/mm/yyyy', formatlist='j M Y', formatdetails='j M Y H:i', formatblock='j/m', enablecomments='0', screenmaxsize='0', resizescreens='0', createthumbs='0', resizedwidth='1024', thumbwidth='165', enablelineup='0', detailswidth='350', colorbox='0', usesubs='0', enablemail='0', allowsubscr='1', emailact='1', sendmail='0', seperate='0', showip='0', stateserver='1', statereport='1', statemaps='1', statelineup='1', statescreens='1', statecomments='0', showteamflag='0', warssummary='0', arrowcolor='Black', screensperrow='2', gamesmemberswars='1', teamsmemberswars='1', scorepermap='0', autocalcscore='0', forumid='-1', postwhen='0', poster='', topictitle='', pagetext='', timedifference='0';
    
    MySQL Error   : Unknown column 'forumid' in 'field list'
    Error Number  : 1054
    Request Date  : Saturday, April 30th 2011 @ 08:57:29 PM
    Error Date    : Saturday, April 30th 2011 @ 08:57:29 PM
    Script        : http://**removed**/admincp/clanwars.php?do=SaveConfig
    Referrer      : **removed**
    IP Address    : **removed**
    Username      : MysticDigital
    Classname     : vB_Database
    MySQL Version : 5.0.91-community
    Yes, I know this is a mod and not default vB. However I've seen this testing and working fine on other forums, so it's not the mod itself, but possibly some confliction or SQL error.

    I've tried disable_hooks=true statement in the config and still occurs.

    I've disabled half the mods I have, before disabling hooks. Do I still need to now disable the rest even without hooks?

    Any other solution?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    There is no clan_wars_config table in vB, as you probably know, nor is there a clanwars.php file. In short, this is not even a vB error. You really need to contact the author of that add-on for help.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...