Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 06 May 2005, 21:24
freebase69's Avatar
freebase69 freebase69 is offline
 
Join Date: May 2005
SQL Error While Upgrading

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

Last edited by freebase69; 06 May 2005 at 21:35.
Reply With Quote
Comments
  #2  
Old 07 May 2005, 00:44
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Real name: Fillip
http://www.vbulletin.org/forum/showthread.php?t=78632
Reply With Quote
  #3  
Old 07 May 2005, 05:26
freebase69's Avatar
freebase69 freebase69 is offline
 
Join Date: May 2005
I removed the DROP and editing from the code and it went past that part but now I get this error:

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


I dont quite understand what that guy did in the other post but I tried to follow along as best as I could. Any other advice would be greatly appreciated.
Reply With Quote
  #4  
Old 07 May 2005, 05:32
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Do you have a link????
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #5  
Old 07 May 2005, 06:26
freebase69's Avatar
freebase69 freebase69 is offline
 
Join Date: May 2005
Link to what? My site? Currently it's turned off because these errors are causing errors with the entire site.
Reply With Quote
  #6  
Old 07 May 2005, 12:05
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Real name: Fillip
Okay heres what to do:
* Remove the DROP from the upgrade file
* At the top of the file, before the first if(), place
$DB_site->reporterror = 0;
* At the bottom of the file, after the last if(), place
$DB_site->reporterror = 1;
* Open vB Options, and save them.
* Run the upgrade again.
Reply With Quote
  #7  
Old 07 May 2005, 23:15
freebase69's Avatar
freebase69 freebase69 is offline
 
Join Date: May 2005
Im still not having any luck. This is what I did:

// ######################### START MAIN SCRIPT ############################
// ########################################################################
$DB_site->reporterror = 0;
if ($current_version < $script_version)
{


$DB_site->query("ALTER TABLE `" . TABLE_PREFIX . "rpg_lottery`");




if ($RPG_UPGRADE_DONE === true)
{
$DB_site->query("
UPDATE `" . TABLE_PREFIX . "setting` SET
value = '" . intval($script_version) . "',
defaultvalue = '" . intval($script_version) . "'
WHERE varname = '" . addslashes('rpg_versionnumber') . "'
");
print_description_row('Updated Setting: <b><i>Version Number</i></b>');
}
}
$DB_site->reporterror = 1;

/*======================================================================*\

When I run it like this I get this error:
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
Reply With Quote
  #8  
Old 09 May 2005, 23:30
freebase69's Avatar
freebase69 freebase69 is offline
 
Join Date: May 2005
I've removed my vBulletin and all the previously installed hacks. I am going to do a fresh install and try this again without importing threads/users/etc/etc.

Maybe something got messed up in that process because I'm out of ideas. I should have it back up sometime tonight and hopefully it will work.

Last edited by freebase69; 09 May 2005 at 23:32.
Reply With Quote
  #9  
Old 06 Jun 2005, 00:02
congpine congpine is offline
 
Join Date: Jun 2005
hey guys .. i got the same problems as you did ...T_T .

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


anyone help ? i do a fresh install so i think you will meet that problem again , so DON'T REMOVE YOUR BOARD
Reply With Quote
  #10  
Old 06 Jun 2005, 01:53
Durtay Durtay is offline
 
Join Date: Feb 2004
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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

theres the sql coding to do that without phpmyadmin

Last edited by Durtay; 06 Jun 2005 at 01:57. Reason: Automerged Doublepost
Reply With Quote
  #11  
Old 06 Jun 2005, 07:54
congpine congpine is offline
 
Join Date: Jun 2005
oh it is cool , man ! thank you so much , i will try it now.......

YEAH ! thank you ! I 've done it ! it's cool ! thank you so much !

Last edited by congpine; 06 Jun 2005 at 08:09. Reason: Automerged Doublepost
Reply With Quote
  #12  
Old 11 Jun 2005, 20:04
pmay68's Avatar
pmay68 pmay68 is offline
 
Join Date: Sep 2002
Thanks alot for this...
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:59.

Layout Options | Width: Wide Color: