Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Jun 2008, 16:58
Pistils Pistils is offline
 
Join Date: Oct 2005
vbulletin upgrade error from 3.7b5 to b6

Hi guys, I've done this upgrade before, and I don't know what has changed. I've hit a stumbling block whilst trying to upgrade from 3.6. The majority of the upgrade goes smoothly with no errors, as it has done before. Unfortunately, I am stuck on this bit, although it may relate to a previous error. The problem is with the new album table. First off, the issue seemed to be that the 'public' column was missing when it was trying to change that table in a previous script. I created that column... Now I have this on the following page:

http://test.domain.tld/forums/instal...0b6.php?step=1



Step 1) Misc Table Alterations

* Updating bb_user table
* Updating bb_setting table
* Altering socialgroup Table (1 of 1)
* Updating bb_socialgroup table
* Altering picture Table (1 of 1)
* Altering album Table (1 of 2)
* Altering album Table (2 of 2)

Database Error Database error
The BreedBay database has encountered a problem.



Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
ALTER TABLE bb_album CHANGE picturecount visible INT UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'visible'
Error Number : 1060
Request Date : Tuesday, June 3rd 2008 @ 04:30:38 PM
Error Date : Tuesday, June 3rd 2008 @ 04:30:38 PM
Script : http://test.domain.tld/forums/instal...0b6.php?step=1
Referrer : http://test.domain.tld//forums/insta...rade_370b6.php
IP Address : 77.68.5.71
Username :
Classname : vB_Database
MySQL Version : 5.0.22


Any ideas on what is wrong? The upgrade went smoothly about two weeks ago on another test version of the same site?

Thanks for your help in advance.

Last edited by Pistils; 03 Jun 2008 at 17:24. Reason: table should be column
Reply With Quote
  #2  
Old 04 Jun 2008, 09:12
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
I guess you are using the same database for your test and now your real upgrade? Probably restored a backup after the first test and tried to run the upgrade again?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 04 Jun 2008, 09:17
Playa82 Playa82 is offline
 
Join Date: Mar 2006
we already got 3.7.1 gold...
Reply With Quote
  #4  
Old 04 Jun 2008, 12:03
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Originally Posted by Playa82 View Post
we already got 3.7.1 gold...
Congratulations to you.

And how is this response related to the questions asked?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #5  
Old 04 Jun 2008, 12:42
Playa82 Playa82 is offline
 
Join Date: Mar 2006
^^^^ sorry, i just said. maybe he should do a new install without overwriting or deleting his mysql database.
Reply With Quote
Reply



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

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 15:07.

Layout Options | Width: Wide Color: