Announcement

Collapse
No announcement yet.

databse error - 3.5.1 to 3.5.3

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

  • 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

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


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

      Paul

      Comment


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

        Comment


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


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