[Forum] Database Error Number : 1054 vbulletin 4.1.2

[sdfontanini]

i have been getting these database errors now for months, someone please help

Database error in vBulletin 4.1.2:

Invalid SQL:
UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts);

MySQL Error : Unknown column 'newposts' in 'where clause'
Error Number : 1054
Request Date : Thursday, April 7th 2011 @ 12:16:43 AM
Error Date : Thursday, April 7th 2011 @ 12:16:50 AM
Script : http://www.coloradoevo.com/forums/ne...streply&t=5093
Referrer : http://www.coloradoevo.com/forums/sh...?t=5093&page=2
IP Address : 76.120.124.35
Username : EclipseGS
Classname : vB_Database
MySQL Version :

[Trevor Hannant]

There is no 'newposts' column in the default session table. This either comes from a modification you have installed or have ininstalled but left files on your server from

[sdfontanini]

my server host had a major crash a few months ago and this started as a result.

any solution trevor, i have disabled all plugins

[sdfontanini]

There is no 'newposts' column in the default session table. This either comes from a modification you have installed or have ininstalled but left files on your server from

i had cmps installed but it has been causing me issues as i can't remove it completely from the cp. its been a nightmare.

any help

[Trevor Hannant]

To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Next, disable all plugins.

Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

Do you have the same problem?

[brihan]

Trevor,

I want to give you a special THANK YOU for everything you have posted.

I am upgrading from 3.6.5 to 4.1.3 and first found your article about how to create a test server. In that was how to use a shell account to back up and restore the database.

After following that I was successful and was then able to run the upgrade script. All went flawless except for an issue with thumbnails and images which gave me a Database Error Number : 1054.

I found this thread and here you are again. I took your advice and just uploaded all the files (except images and install.php) and it appears to be working fine now.

Thank you very much!

[Trevor Hannant]

You're welcome!

[Trendri]

I just uninstalled a mod Guest Warn
and am now receiving database error, my site is not working again.

I can't access my admincp and site, am getting database error. MySQL Error : Unknown column 'phrasegroup_global' in 'field list'

I have also uploaded the default Vbulletin files and i have run the upgrade script.

I have added this define('DISABLE_HOOKS', true); line right under <?php .

But my forum is still not working am still getting database error. I can't access the forum and Admincp

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
Error Number : 1054
Request Date : Sunday, August 19th 2012 @ 05:13:10 PM
Error Date : Sunday, August 19th 2012 @ 05:13:10 PM


I believe you might be able to help me resolve the issue, i have contacted VB support but my issue had not be resolve.