[Durtay]

Originally Posted by freebase69

I updated all the files, uploaded all the ones that need to go, ran the installer and it went great, then it ran to upgrade to a new version automatically like 4 times. All worked but the last one going from V3Beta to V3 Final. This is the error I am getting and I can't get past it:

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

Any ideas?

Thanks

I came across these problems also... this is how you get around them. If you have phpmyadmin access...

First go into the 'rpg_lottery' table and add an empty column titled "editing", just set all stats to 0.

Once thats created go into the 'user' table and remove the column titled "inmonsterbattle"...

re-do the upgrade install, it will finish correctly.

ALTER TABLE `rpg_lottery` ADD `editing` VARCHAR( 00 ) NOT NULL ;

ALTER TABLE `user` DROP `inmonsterbattle`

theres the sql coding to do that without phpmyadmin