Problem Upgrading to beta 5

I cannot upgrade to beta 5... I get to a screen that says the following:

RPG Integration Hack Upgrade Results
Running queries......
Updating tables.....
Skipped Table: rpg_ibot_templates
Skipped Table: rpg_ibots
Populated Table: rpg_ibots
Skipped Table: rpg_monster_battle_posts
Skipped Table: rpg_monster_battles

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE `rpg_lottery` DROP `editing`
mysql error: Can't DROP 'editing'. Check that column/key exists

mysql error number: 1091

Date: Saturday 26th of March 2005 08:43:01 PM
Script: <exact link removed>/rpg_install.php?step=upgrade&part=queries&all=yes

[Revan]

shoulda dloaded the newest files then, because I added a conditional around that line just about the time the last person reported this.
So basically the file now checks whether or not the editing field exists.

https://vborg.vbsupport.ru/showthread.php?t=78632
Theres the thread, knock yerself out

[aligold]

Thing is I literally downloaded the upgrade minutes before attempting to run the upgrade... I'll try again, but I'm pretty sure that unless you uploaded it in the last 15 minutes its not gonna be working.

EDIT: Just tried downloading through mozilla(used IE on last download) and reuploaded all of the files, to no effect.

[Revan]

This is the weirdest thing...
Taken straight from the source of the file:

PHP Code:

        if (verify_field_exists('editing', 'rpg_lottery'))
        {
            $DB_site->query("ALTER TABLE `" . TABLE_PREFIX . "rpg_lottery` DROP `editing` ");
        } 


Which reads that if the field "editing" exists, drop it.
Tell you what: Remove the entire section I just posted from the file /install/upgrade4.php, then run /admincp/rpg_install.php?step=upgrade&part=queries&all=yes to skip right past any other errors and resume the upgrade. I believe running it from there should work fine

[aligold]

Well that worked partially....

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE `user` ADD `inmonsterbattle` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'inmonsterbattle'

mysql error number: 1060

guess I need to go through a few times commenting out any issues I encounter until it works.

[Revan]

Yes, that would be the preferred way of doing it.
I dont think there's any more removing or adding than those two though, so hopefully we have seen the end of this now

[aligold]

Well it appears to be working now. It is strange that it did this I'm not certain why it even happened.

[torahtrance]

I had the EXACT SAME PROBLEM. I did the EXACT same thing according to your instructions, and it worked =D !! CHEERS!

v3.07 vbulletin.
i got a problem where it says in the instructions
edit template 'postbit_legacy'

it than says:
###########
find
##########

PHP Code:

<div class="info">$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon]</div>
</div> 


however I cannot find that in the postbit_legacy

another question is how can i add it to all the styles? We plan on having several styles and adding more in the future is there a way to have them all together added at the same time?

Thanks,

s.e.

[Revan]

The postbit_legacy template instructions may be outdated, but since it hasn't changed much since the vB version this hack originally was written for, I didn't think it was important.
As for your question, the RPG templates are automatically added to all styles, as they are inserted in the Master Style

[torahtrance]

does this mean that its already installed and configured properly?
I don't need to do any more backend stuff?

about the master style.. how do I edit that ?