databse error - 3.5.1 to 3.5.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • grimlock
    Member
    • Nov 2005
    • 49

    databse error - 3.5.1 to 3.5.3

    here is the error I receive while trying to upgrade freom 3.5.1 to 3.5.3

    Database error in vBulletin 3.5.1:

    Invalid SQL:
    ALTER TABLE regimage ADD viewed SMALLINT UNSIGNED NOT NULL DEFAULT 0;

    MySQL Error : Duplicate column name 'viewed'
    Error Number : 1060
    Date : Sunday, February 19th 2006 @ 08:00:00 AM
    Script : http://www.krawlerz.com/forums/insta...352.php?step=1
    Referrer : http://www.krawlerz.com/forums/insta...2.php?rand=359
    IP Address : 70.29.252.162
    Username :
    Classname : vb_database
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #2
    Hello,

    This means the script has already run that query, or you have a hack installed that added that column.

    Uninstall the hack and try again, or skip this particular query from the upgrade script.

    Comment

    • grimlock
      Member
      • Nov 2005
      • 49

      #3
      Thanks Floris...I just went into the db and deleted the duplicate table...looks okay now..thank you for the reply

      Paul

      Comment

      • Floris
        Senior Member
        • Dec 2001
        • 37767

        #4
        Good luck with the upgrade, and you're welcome.

        Comment

        • Marco van Herwaarden
          Senior Member
          • Nov 2004
          • 6999
          • 3.8.x

          #5
          I hope you deleted the duplicate column and not table.
          Want to take your board beyond the standard vBulletin features?
          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

          Comment

          • grimlock
            Member
            • Nov 2005
            • 49

            #6
            Who knows what the heck I did...seems to be working though...
            Check her out!

            WWW.KRAWLERZ.COM

            Paul!

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            😀
            😂
            🥰
            😘
            🤢
            😎
            😞
            😡
            👍
            👎