[Forum] Misc Table Alterations database errors = Third times upgrading on live site

[Adom7]

Hi,
On my demo site, I have upgraded/tested vb4 so many times up to now, there was no error. But on live site, it makes me crazy.
Please, assist me where I do wrong;

1- Backup all database and files trhough ssh..
2- Disable all plugins via config file or product manager.
3- upload all files to forum root, and rewrite all over
4- change to config file as it must be
5- run the upgrade script

So the errors I ve got;
P.S. I tried to upgrade my live site three times, all with db errors.

vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)

Step 3) Misc Table Alterations (3/3) (Step 3 of 12)

Database error in vBulletin 3.8.4:

Invalid SQL:
INSERT INTO forumtagcontent
(tagid, contenttypeid, contentid, userid, dateline)
SELECT tagid, 2, threadid, userid, dateline
FROM forumtagthread;

MySQL Error : Duplicate entry '1-2-9853' for key 1
Error Number : 1062
Request Date : Tuesday, December 22nd 2009 @ 07:36:36 PM
Error Date : Tuesday, December 22nd 2009 @ 07:36:36 PM
Script : http://wwwxxxxxxxxx/forum/install/up...0a1.php?step=3
Referrer : http://www.xxxxxx/forum/install/upgr...0a1.php?step=2
IP Address : x
Username :
Classname : vB_Database
MySQL Version : 5.0.51a


_________________________________________

vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)

Step 8) Albums System Alterations (Step 8 of 12)

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT filedataid, attachmentid
FROM forumattachment
WHERE
filedataid = 1
AND
posthash = ''
AND
contentid = 0;

MySQL Error : Unknown column 'filedataid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 22nd 2009 @ 07:37:42 PM
Error Date : Tuesday, December 22nd 2009 @ 07:37:42 PM
Script : http://www.xxxxxxcom/forum/install/u...0a1.php?step=8
Referrer : http://www.xxxxxxxxcom/forum/install...0a1.php?step=7
IP Address : x
Username :
Classname : vB_Database
MySQL Version : 5.0.51a

__________________________________________________

vBulletin 4.0 Upgrade System
(Please be patient as some parts may take some time)

Step 1) Misc Table Alterations (Step 1 of 2)

Database error in vBulletin 4.0.0 Alpha 6:

Invalid SQL:
ALTER TABLE forumattachment ADD INDEX contenttypeid (contenttypeid,contentid,attachmentid);

MySQL Error : Key column 'contenttypeid' doesn't exist in table
Error Number : -1
Request Date : Tuesday, December 22nd 2009 @ 07:42:26 PM
Error Date : Tuesday, December 22nd 2009 @ 07:42:26 PM
Script : http://wwwxxxxxxcom/forum/install/up...0b1.php?step=1
Referrer : http://wwwxxxxxxxxxxcom/forum/install/upgrade_400b1.php
IP Address : 88.228.49.199
Username :
Classname : vB_Database
MySQL Version :

[Reeve of Shinra]

you may want to open a support ticket for this.

[Adom7]

you may want to open a support ticket for this.

thanks Reeve,
The fourth one also shows the same database errors, damn it, so I restored the site.
Now, I am on 3.8.4 :S

[Chips]

+1 I have tried most all avenues and still no luck. There was one instance I was able to get the blain thing to work but then all the threads url's changed so when you attempt to enter a forum you get a "nothing in here" kind of an issue. I reverted back to 3.8.4, upgraded with the new patch (2) today and am leaving it alone. Just a piss of cash is all. Maybe I will feel better later.

[Zachery]

Chips, putting in a support ticket, we can directly look at the issue and work though any isues you're expircing with the upgrade script.

[Chips]

Chips, putting in a support ticket, we can directly look at the issue and work though any isues you're expircing with the upgrade script.

Thanks Zachery, I actually finished my beer, took a shower, thought about it, deleted the SQL files (because I had just been importing them, not starting fresh (doh)) and uploaded the original 3.8.4 files from yesterday, then started over.

The upgrade went through perfect, I just finished skinning for the night as my head is banging. One issue I had was not being able to enter any forums, got an error the url was bad, found a thread somewhere here regarding the .htaccess file from vBSEO needs to be gone from forum root.. the moment I deleted that, all was operational. I am now up and running live on 4.0 (P1). Was a very distressing 24 hours but all is well now and I have learned more about mySQL than I ever cared to know.

I admit I am now a happy camper!

[Zachery]

Glad to hear you got upgraded

[Chips]

Yeah it was more my ignorance and overlooking a few minor points that added up to major headaches. All is well again. Maybe when 5.0 hits I will think a bit more and read a touch more before diving into the deep end. I had a test board running and it was all well, just upgrading the forums and not thinking of all the variables made me trip up a touch.

Now for some much needed sleep before I finish skinning the new diggs in the AM.