Upgrading 3.0.5 to 3.0.6 - get mysql error number: 1054

[nsxprime]

I just uploaded the 3.0.6 files and now get the following error if I try to go to any forum page (main forums page, admin control panel, install/upgrade.php, etc.) so I am stuck. Everything was working fine prior to uploading the files. I checked my global.php and config.php and everything appears correct. I checked the user table in mysql and it did not report any errors, though I do not see a cancontrolpanel field...?

<!-- Database error in vBulletin Control Panel :

Invalid SQL: SELECT cancontrolpanel FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND user.userid='0'
mysql error: Unknown column 'cancontrolpanel' in 'field list'

mysql error number: 1054

Date: Monday 24th of January 2005 01:25:16 PM
Script: /forums/aprimecp/index.php
Referer: 
 -->

[Steve Machol]

There is no 'cancontrolpanel' field in either the defaul user or usergroup table in vB. This means that you either have installed a hack that uses this field, and/or you have not uploaded the original vB 3.0.6 files.

[nsxprime]

There is no 'cancontrolpanel' field in either the defaul user or usergroup table in vB. This means that you either have installed a hack that uses this field, and/or you have not uploaded the original vB 3.0.6 files.

Huh? OK I am really confused now... This is from the 3.0.6 global.php file I just downloaded from you guys. Since the error is from the index file in ./forums/ or ./forums/aprimecp (my admin control panel dir) doesn't that mean either the index.php or an included file like global.php is calling it? Those files are all freshly updated from the 3.0.6 upgrade ZIP.

// check that board is active - if not admin, then display error
if (!$bbactive) {
  if (!$permissions['cancontrolpanel']) {
    eval("standarderror(\"".str_replace("\'", "'", addslashes($bbclosedreason))."\");");
    exit;
  }
}

[Steve Machol]

That is a permission, not a field. The error you posted indicates this is a field and it does not exist as a field. This is from a hack you've installed.

[nsxprime]

I understand what you are saying, but it doesn't make sense to me.

The only hack I have installed is Trader Ratings. Adding a cancontrolpanel field to the user table was not one of the mods for the hack. Just to be sure, I searched the Trader Ratings code for 'cancontrolpanel' and there is no reference I can find.

Since I couldn't get to vbulletin.com for a while this afternoon and needed to get my site back up, I just replaced the 3.0.6 files with the 3.0.5 release files (unmodified from vBulletin.com) and everythings works fine again. Therefore something that changes from 3.0.5 to 3.0.6 release editions certainly appears to be causing the problem, or is at least causing it to show up. My database has not changed - simply changing the release version of the vB files between 3.0.5 and 3.0.6 causes it to work or not work.

I have updated my functions_bbcodeparse.php file for now to secure the site, but I am at a loss as to how to avoid this problem with any future upgrades. I am hardly a new vB user and have successfully managed many upgrades big and small over the years. I understand you are saying it is not a vBulletin issue, but simply swapping vB versions causes it to come or go, and I cannot figure out how the Trader Ratings hack could have any effect on this problem. In the past with some big vB upgrades Trader Ratings would stop working until I updated some files (mostly styles/templates), but I don't see how it can cause vBulletin to stop working.

Anyway I guess I'm just saying it is no longer an urgent issue, but I don't know where to go from here.

[Steve Machol]

Have you tried reuploading the original files yet?