Unknown column 'articleid' in 'field list'

  • by
  • on 01.08.09
  • creampiesca.com
  • edit
  • I have a "news" database that is set to only allow admins to post to (but everyone can reply and read it).

    When I (as an admin) post a message in the forum this is the error I get.


    Database error in vBulletin 2.2.6:

    Invalid SQL: UPDATE thread SET articleid=221957 WHERE threadid=24825
    mysql error: Unknown column 'articleid' in 'field list'

    mysql error number: 1054

    Date: Friday 28th of June 2002 08:47:59 PM
    Script: http://www.sportbikeworld.com/newthread.php
    Referer: http://www.sportbikeworld.com/newthread.php?action=newthread&forumid=52


    The weird thing is if I hit "refresh" after this error the message is posted fine. No problems posting in any of the other forums.

    I just ran repair.php (thanks to eva2000's help) on the database and everything came back fine, but I'm still getting the same error.

    Any ideas?

    Thanks!


  • Originally posted by Sportbikeworld


    I just realized that this is probibly left over from an old hack I no longer use. (A NNTP posting hack).

    So I'm guessing I would be safe in removing this field from the thread table as VB does not need it?

    I guess I'm just confused as to why I only get the error in this one forum.

    Thanks for the update Eva. I'll poke around and see what I can find out. backup forum, then use phpmyadmin and remove the articleid from the thread table properties page


  • Eva,

    Found the offending code in newthread.php and removed it.

    Thanks for your help! :)


  • Originally posted by Sportbikeworld
    Eva,

    Found the offending code in newthread.php and removed it.

    Thanks for your help! :) no probs :)


  • i'm pretty sure vB stock database doesn't have an 'articleid' field in thread table that's why i'm assuming it's a hack


  • I just realized I said I had a news "database". What I ment was I have a news "forum". I have it setup using the forum permissions in the VBulletin CP.

    And the strange thing is it was working fine for 2 years and then just stopped working. I didn't change / update anything.

    That's why I ran the repair.php because I thought one of the tables might be corrupted.


  • that's a hack and unfortunately should be asked over at vBulletin.org

    in order to use and post in certain forums at vBulletin.org you need to

    1. register using the same username and email address you used at vBulletin.com's forums
    2. activate and confirm your registration email
    3. then enter your forum username at http://www.vbulletin.com/members/vbulletin.org.php to show that you're a licensed vB owner







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Unknown column 'articleid' in 'field list' , Please add it free.