Albums System Alterations (Step 8 of 12) database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Adom7
    Member
    • May 2007
    • 88
    • 4.2.X

    [Suite] Albums System Alterations (Step 8 of 12) database error

    while I was upgrading my site to vb4 on live site, I got the following error,
    Half of the album pictures was moved, then database error occured. So I passed that step to complete upgrading, rest of the steps went very well.
    Now, my live site runs on vb4 about one day, but neither I can access albums pics nor upload a new pic.

    What Should I do?
    Delete all album pics on file store, or what?
    Thanks

    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
    Need more help!

    The City of Antalya / Turkiye

  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24373
    • 5.7.X

    #2
    What was the original database error or is this it?
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • Adom7
      Member
      • May 2007
      • 88
      • 4.2.X

      #3
      Hi, Trevor

      Before upgrading, I put all files and backup files on desktop, it was so crowded therefore I accidentally delete the txt file which I saved the error code
      But the process like that;
      Step 7 to 8 in that, album pictures were moved to attachment system 10 to 10 when 1355 id picture caused the database error, so I went past the seventh step typing 8 on the browser and completed upgrading process.
      Now forum is good there is no error but the album.
      Here is the site http://www.iolpmezunu.com/forum/

      All albums are messed up, and no display on the page.
      Need more help!

      The City of Antalya / Turkiye

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24373
        • 5.7.X

        #4
        If you've skipped past a step then the chances are you're going to introduce problems.

        Can you setup a test forum with the backup you had of your forum then upgrade that and post the error here - that will let us try and fix this for you. Make sure that you restore to a new empty database and change the config.php file to point to that one.
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        Related Topics

        Collapse

        Working...