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

[Whitesky]

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

[IBxAnders]

Did you try to upgrade to a newer version or something?

[JonUrban]

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

[Steve Machol]

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.

[JonUrban]

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!

[Doro]

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?

[Trevor Hannant]

Did you upload the full package or just the Patch files?

[ampersand]

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