Announcement

Collapse
No announcement yet.

We have some Big DB Problems

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

  • We have some Big DB Problems

    We have serious problems with Database .. Please Help.

    One of them ; I was trying to upgrade forum version 3.5.1 to 3.5.2 .... Stopped on second step then this error appeared ;

    Code:
     
    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
    ........................
    ........................

    2. Problem

    While opening a new forum from the admincp , an error appearins such this

    Code:
    Database error in vBulletin 3.5.1:
    Invalid SQL:
    INSERT INTO forum
     (title_clean, title, description_clean, description, link, displayorder, daysprune, parentid, newpostemail, newthreademail, options, styleid, password, minuserage, forumhomeicon, recycle, forumid)
    VALUES
     ('deneme', 'deneme', '', '', '', 1, -1, -1, '', '', 97991, 0, '', 0, '', 0, 322);
    MySQL Error  : Duplicate entry '322' for key 1
    Error Number : 1062
    .................
    ...........................
    ..............................
    This error appears but Forum is opening... There is not any problem to opening forums.


    3. Problem

    When a user clicked to the Mark Forums Read an error appearing too ;


    Code:
     
    Invalid SQL:
    SELECT * FROM forum WHERE forumid =;
    MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
    Error Number : 1064
    Date         : Monday, December 26th 2005 @ 12:40:14 PM
    ... .... ....
    We are waiting your urgent helps. .

  • #2
    1. You have either restarted the upgrade process, ran it twice or you had a hack installed that already added this column to the database. If it was a hack, uninstall it before upgrading.

    If an upgrade is not finished successfull, you should not try to use your board until it is solved.

    2. See #1, and also it seems you have 1 or more corrupt tables. Try running Repair tables a few times.

    3. This might be caused by an installed hack or is a result from one of the above.

    I would suggest that you wait for a Jelsoft support member to post a solution, or open a support ticket (if you don't have hacks installed).
    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

    Loading...
    Working...
    X