Error in AdminCP

[Steve Machol]

The field 'mimicbotrop' is not in the default vB forum table. Best I can tell this is from a hack you've installed.

[dpakman91]

ok, does this have to do with the same thing? i just tried changing the name of one of the subforums and it gave me this:

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Entertainment',
description = '',
link = '',
displayorder = '2',
daysprune = '30',
parentid = '1',
mimicbotrop = '',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
options = '97857',
parentlist = '5,1,-1'
WHERE forumid=5
mysql error: Unknown column 'mimicbotrop' in 'field list'

mysql error number: 1054

Date: Saturday 31st of January 2004 06:18:53 PM
Script: http://www.thevividedge.com/forum/admincp/forum.php
Referer: http://www.thevividedge.com/forum/ad...t&forumid=5&s=
Username: David
IP Address: 24.62.125.5

[dpakman91]

alright, if it comes up during my upgrade i will make sure to post. before i go through with it, is there anything i should do (other than backing up) to try to avoid problems during the upgrade? anything as far as my admincp, hacks, or anything else.

[Floris]

I would need to see the full error.

[dpakman91]

Upload the files from rc3 and run upgrade.php?
If you upload the unmoddified files from rc2, you have to re-apply the hacks anyway.
You mentioned you stopped upgrading because you didnt'want to re-apply them.

Run upgrade.php .. and re-apply them if you still want that. At least your site works again. And you can better re-apply them to rc3 and then rc2.

At least, that is what I would do.

i suppose that is my best option. as a side not, i was getting SQL errors on step 4 of the upgrade to RC3...error 1034 in fact...is there anything i can do to try to prevent this from happening?

[Floris]

Upload the files from rc3 and run upgrade.php?
If you upload the unmoddified files from rc2, you have to re-apply the hacks anyway.
You mentioned you stopped upgrading because you didnt'want to re-apply them.

Run upgrade.php .. and re-apply them if you still want that. At least your site works again. And you can better re-apply them to rc3 and then rc2.

At least, that is what I would do.

[dpakman91]

so what is my best bet for solving this problem?

[Zachery]

No, no one from vBulletin.com can give you their copy of RC2.

You can only legally download the latest build of vBulletin 3

Same thing applys for the vBulletin 2 serries

[dpakman91]

alright...is there any way you or anyone else could send me RC2 unmodified, just the way it would come from vb.com? i only have the files for RC3 on my computer.

or at least indicate where i could still get RC2?

[Floris]

Hi again,

Make sure the files you upload have the rc2 version in their filename, maybe your backup was overwritten with the rc3 files when unpacking or whatever.

When you are sure they are rc2 files and you need to upload them but you end up with rc3 files, then make sure your ftp program does not RESUME or SKIP the files. In best: Remove the rc3 files from the server, and upload the rc2 files.

[dpakman91]

that's the thing. i did upload the backup i made just before upgrading to RC3, and although i am back to running RC2, and it's running fine (except, of course, for this admincp error), but the RC3 files are still there, as we've determined.

[Floris]

Well, for each upgrade or test run, you of course make a backup of the currently working installation. So just upload the files from that backup, which are version 3, RC2 - and you should be done.

[dpakman91]

yeah they do say RC3...so what can i do to correct this?

[Floris]

Each file has a header and footer. They contain some information. Open the file in an editor and see which version is tagged for it.


/*======================================================================*\
|| #################################################################### ||
|| # vBulletin 3.0.0 Release Candidate 3 - Licence Number <Goes Here>
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ©2000-2004 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| #################################################################### ||
\*======================================================================*/

[dpakman91]

Maybe you try to use vb3 rc3 files with the vb3 rc2 database?

ooh, if that is the case, it sounds like a huge ordeal to correct it...how would i be able to:

find out if that is the case?

if it is, fix it?