database error! What to do?

[christmas]

I have just upgraded to the latest version of vbulletin. Everything seems to run, but I keep getting this error in the admin panel:

Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Friday, August 22nd 2008 @ 05:14:18 AM
Error Date : Friday, August 22nd 2008 @ 05:14:18 AM
Script : http://www.example.com/forum/admin1c...ex.php?do=home
Referrer : http://www.example.com/forum/admin1cpc/index.php
IP Address : 130.xxx.xxx.xxx
Username : example
Classname : vB_Database
MySQL Version : 5.0.27


I also keep getting admin-emails whit the same error!

Please help!

Thanks!

[Steve Machol]

There is no 'postid' field in the 3.7.2 moderation table. That error is from an old file or an add-on.

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);

[Bkaradza]

I have same problem. My webprovider transfer forum from window to linux server and I got error in administration. I have problems with MGC chat but I delete it and now it's ok..
I only have 1 addon and that's: Prevent bumping old Threads but I disable it and still got same error.

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vb3_moderation AS moderation
INNER JOIN vb3_post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Date : Friday, August 22nd 2008 @ 09:43:20 PM
Script : http://www.hnkhajduk.com/forum/admin...ex.php?do=home
Referrer : http://www.hnkhajduk.com/forum/admincp/index.php?do=nav
IP Address :
Username : XXXX
Classname : vB_Database

I got 1 more strange thing. In admin pannel I see this notice on top and I upload files from 3.7.2. patch level 2 instalation...

Admin Control Panel (vBulletin 3.6.7 PL1) Latest version available: 3.7.2 Patch Level 2

[Steve Machol]

Post #2 answered this.

[Bkaradza]

Post #2 answered this.

Yea you was right I upload files to window server and not on linux and provider transfer some very old data. After 10 uploads I figure something is wrong I delete upgrade files and manage to start it then I call provider and he give me new username and pass for linux server

[christmas]

Thanks, when running Suspect File Versions I get this list:

So what to do next? It seems like a heavy problem?

./lastposts3.phpFile not recognized as part of vBulletinScanned 53 files
./admin1cpcaccessmask.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1admincalendar.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1admininfraction.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1adminlog.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1adminpermissions.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1adminreputation.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1album.phpFile not foundannouncement.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1attachment.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1attachmentpermission.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1avatar.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1backup.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1bbcode.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1bookmarksite.phpFile not foundcalendarpermission.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1cronadmin.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1cronlog.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1css.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1diagnostic.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1email.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1faq.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1forum.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1forumpermission.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1global.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1help.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1image.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1index.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1language.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1misc.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1moderator.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1modlog.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1newsproxy.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1notice.phpFile not foundoptions.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1phrase.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1plugin.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1prefix.phpFile not foundprofilefield.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1queries.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1ranks.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1repair.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1replacement.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1resources.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1rssposter.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1socialgroups.phpFile not foundstats.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1subscriptionpermission.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1subscriptions.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1template.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1textarea.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1thread.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1user.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1usergroup.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1usertitle.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1usertools.phpFile version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1verify.phpFile not foundScanned 4 files
./archiveScanned 51 files
./clientscriptScanned 4 files
./clientscript/yuiScanned 2 files
./clientscript/yui/connectionScanned 2 files
./clientscript/yui/yahoo-dom-eventScanned 2 files
./images/regimage/fontsScanned 152 files
./includesfunctions_regimage.phpFile not recognized as part of vBulletinScanned 21 files
./includes/cronScanned 8 files
./includes/paymentapiScanned 11 files
./includes/xmlScanned 82 files
./installScanned 10 files
./modcp

[Steve Machol]

Here's the problem:

File version mismatch: found 3.6.8, expected 3.7.2 Patch Level 1

You need to upload the 3.7.2 files and replace thw 3.6.8 ones.

[peterska2]

You have a renamed AdminCP directory and have not uploaded the new admincp files to your renamed directory.