PDA

View Full Version : Problem in AdminCP after upgrade(3.5.4 - 3.6.8)


TouranMan
Tue 2nd Oct '07, 7:12pm
Upgrade went OK but now I get this error:


SELECT varname, text
FROM clubtour_phrase
WHERE phrasetypeid = PHRASETYPEID_SETTING AND
languageid IN(-1, 0, 1)
ORDER BY languageid ASC;

MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
Error Number : 1054
Date : Tuesday, October 2nd 2007 @ 11:07:47 PM
Script : http://www.clubtouran.net/forum/vbadmincp/options.php?null=0
Referrer : http://www.clubtouran.net/forum/vbadmincp/index.php?do=nav

when I access certain pages in the AdminCP including 'Vbulletin Options' so I can't turn my boards back on!!

Please HELP! :(

Steve Machol
Tue 2nd Oct '07, 7:52pm
This is from an add-on or an old file.

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

TouranMan
Tue 2nd Oct '07, 7:59pm
Thanks Steve. I realised what was wrong after this.

I had renamed my admin and mod CP's to vbadmin and vbmod and of course the upgrade created new folders 'admincp' and 'modcp'. I obviously missed this on the last upgrade I did also as the file versions were 3.5.3!!

Thanks again, much appreciated.