No announcement yet.

Can't create new forum

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Can't create new forum

    When i try and create a new forum i get a database error, I can do it on my test site fine, but on my live site it gives me this database error:

        Invalid SQL:
      INSERT INTO forum
            (title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, imageprefix, password, accessf_nb, accesst_nb, create_nb, reply_nb, linkview_nb, linkpost_nb) VALUES
            ('Regional Meets and Events', 'Regional Meets and Events', '', '', '', 2, -1, -1, 'lastpost', 'desc', 0, '', '', 89794, 0, '', '', 0, 0, 0, 0, 0, 0);
      MySQL Error   : Unknown column 'accessf_nb' in 'field list'
      Error Number  : 1054
      Request Date  : Monday, April 19th 2010 @ 11:39:12 AM
      Error Date    : Monday, April 19th 2010 @ 11:39:12 AM
      Script        : [URL=""]http://www.******/forum/admincp/forum.php?do=update[/URL]
      Referrer      : [URL=""]http://www.******/forum/admincp/forum.php?do=add[/URL]
      IP Address    : **.***.***.***
      Username      : ****
      Classname     : vB_Database
      MySQL Version : 5.0.45
    What is causing this?

  • #2
    I have done some investigating and it appears my live forum is missing some database field in the forum table compared to the database for my test forum, what would cause this and how can I resolve it?


    • #3
      That's a field from an Add-on and no standardfield from vB.

      Just check from where it comes and deactivate the plugin/addon


      • #4
        Thanks for the info, that narrows it down a bit. I don't suppose you'd know how I can check what mod might be looking for that field?


        • #5
          You could try and search for accessf_nb


          • #6
            Found it, it was the Advanced permissions based on post count mod. Thanks for your help


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