Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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 :
    Last edited by Adom7; Tue 22nd Dec '09, 1:23pm.
    Need more help!

    The City of Antalya / Turkiye


  • #2
    you may want to open a support ticket for this.
    Plan, Do, Check, Act!

    Comment


    • #3
      Originally posted by Reeve of Shinra View Post
      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
      Need more help!

      The City of Antalya / Turkiye

      Comment


      • #4
        +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.

        Comment


        • #5
          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.

          Comment


          • #6
            Originally posted by Zachery View Post
            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!
            Last edited by Chips; Tue 22nd Dec '09, 9:05pm. Reason: too tored to spell correctly

            Comment


            • #7
              Glad to hear you got upgraded

              Comment


              • #8
                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.

                Comment

                Related Topics

                Collapse

                Working...
                X