Install upgrade fails at step 11

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Spikeman
    New Member
    • Aug 2006
    • 21
    • 3.6.x

    [Suite] Install upgrade fails at step 11

    I get this sql error at step 11

    Invalid SQL:

    SELECT atype.extension, atype.thumbnail, atype.newwindow, aperm.usergroupid,
    atype.height AS default_height, atype.width AS default_width, atype.size AS default_size,
    aperm.height AS custom_height, aperm.width AS custom_width, aperm.size AS custom_size,
    aperm.attachmentpermissions AS custom_permissions
    FROM vbattachmenttype AS atype
    LEFT JOIN vbattachmentpermission AS aperm USING (extension)
    WHERE enabled = 1
    ORDER BY extension;

    MySQL Error : Unknown column 'atype.thumbnail' in 'field list'
    Error Number : 1054
    Request Date : Monday, February 8th 2010 @ 07:25:41 PM
    Error Date : Monday, February 8th 2010 @ 07:25:41 PM
    Script : http://www.*********/install/upgrade_400a1.php?step=11
    Referrer : http://www.*********/install/upgrade_400a1.php?step=10
    IP Address :
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version : 5.0.68-percona-3-log


    Any ideas would be appreaciated

    All plugins were disabled in acp and config.php
    iPhone Beta Tester
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24326
    • 5.7.X

    #2
    What are you upgrading to and from? I don't see that missing column either in the code or in my own 4.0.1 database...
    Vote for:

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

    Comment

    • Spikeman
      New Member
      • Aug 2006
      • 21
      • 3.6.x

      #3
      I am upgrading from 3.8.2 to 4.0.1
      iPhone Beta Tester

      Comment

      • Spikeman
        New Member
        • Aug 2006
        • 21
        • 3.6.x

        #4
        All sorted now, I dropped all the attachment files from the db then imported manually and re run the upgrade and all went smooth, I think the additions were from a hack that altered the tables in 3.8
        iPhone Beta Tester

        Comment

        Related Topics

        Collapse

        Working...