Announcement

Collapse
No announcement yet.

Error Number : 1054 - Unknown column 'apiclientid' in 'field list'

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Error Number : 1054 - Unknown column 'apiclientid' in 'field list'

    Hi I'm getting the following on all pages, any advice on how to fix in SQL? I've googled this for over an hour with no good answers.

    Database error in vBulletin 4.0.8:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
    VALUES
    ('9f74c86cec11542042744a9645be5b4f', 233, '184.59.182.178', '35459f9ca8ab936768a50842a3b6c986', 1291425390, '/forum/login.php?do=login&do=login', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12', 1, 0, 0, '');

    MySQL Error : Unknown column 'apiclientid' in 'field list'
    Error Number : 1054
    Request Date : Friday, December 3rd 2010 @ 07:16:30 PM
    Error Date : Friday, December 3rd 2010 @ 07:16:31 PM
    Script : http://www.soullessknights.org/forum/login.php?do=login
    Referrer : http://www.soullessknights.org/forum/admincp/
    IP Address : xxx
    Username : xxx
    Classname : vB_Database
    MySQL Version : 5.0.91-community

  • #2
    Did you try to upgrade to a newer version or something?
    anders | vbulletin team | check out the new vbulletin facebook app
    Proudly vBulletin'ing since 2001
    Please be my friend!
    http://www.twitter.com/inetskunkworks
    vBulletin Performance Articles:
    Click here to read

    Comment


    • #3
      I got one or two of these as well, but they may have happened during the upgrade. YES, I did close the board before doing it.

      Database error in vBulletin 4.0.8:

      Invalid SQL:

      INSERT IGNORE INTO session
      (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
      VALUES
      ('276e465dbae4938786255eb3ad7177ee', 0, '24.148.45.121', '71f34caebce4eeed358eb6bb210c3b6c', 1291500181, '/forums/showthread.php?11916-QRX-9001-Rebuild', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12', 0, 0, 0, '');

      MySQL Error : Unknown column 'apiclientid' in 'field list'
      Error Number : 1054
      Request Date : Saturday, December 4th 2010 @ 04:03:01 PM
      Error Date : Saturday, December 4th 2010 @ 04:03:01 PM

      Comment


      • #4
        That error means that you have uploaded the 4.1.0 files but either you did not upload ALL the files or you did not run upgrade.php.
        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


        • #5
          Originally posted by Steve Machol View Post
          That error means that you have uploaded the 4.1.0 files but either you did not upload ALL the files or you did not run upgrade.php.
          Thanks for the FAST response, Steve.

          I uploaded the files, then ran the upgrade. I did close the forum before I uploaded the files. Maybe someone was in a thread at the time of the file transfer?

          At any rate, I ran the upgrade with no issues, and the time on that error and version number is still 4.0.8, so I think I'm OK.

          Fingers crossed!

          Comment


          • #6
            How did you solve this?
            I uploaded all the files, then ran the upgrade and I got this error. So I reuploaded the older files that I replaced before.
            The forum is running ok now, but how do i do the upgrade?

            Comment


            • #7
              Did you upload the full package or just the Patch files?
              Vote for:

              - *Admin Settable Paid Subscription Reminder Timeframe*
              -
              *PM - Add ability to reply to originator only*
              - Add Admin ability to auto-subscribe users to specific channel(s)
              - "Quick Route" Interface...

              Comment


              • #8
                I'm getting this to. I uploaded the full package except from the image folders. I also closed my board and ran the upgrade.php from my SSH client

                Comment

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