Announcement

Collapse
No announcement yet.

problem reinstalling

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

  • problem reinstalling

    I am trying to install the newest upgrade. I am getting this error:

    Database error in vBulletin :
    Invalid SQL:
    CREATE TABLE deletionlog (
    primaryid INT UNSIGNED NOT NULL DEFAULT '0',
    type ENUM('post', 'thread') DEFAULT 'post',
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    username VARCHAR(100) NOT NULL DEFAULT '',
    reason VARCHAR(125) NOT NULL DEFAULT '',
    PRIMARY KEY (primaryid, type)
    );
    MySQL Error : All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
    Error Number : 1171
    Date : Wednesday, November 9th 2005 @ 04:04:33 PM
    Script : http://www.doitdigi.com/forum/instal...e&confirm=true
    Referrer : http://www.doitdigi.com/forum/instal...3&emptydb=true
    IP Address : 216.46.146.1
    Username :
    Classname : vb_database


    Can someone decipher this for me and let me know what I need to do.

    thanks

  • #2
    You're running upgrade.php right?

    Comment


    • #3
      No he is installing a fresh database. This error is probably caused because you are running MySQL3. Since vB3.5 it is strongly adviced to use MySQL4.

      If it is not possible to upgrade your MySQL version, you can find a workaround in the following thread: http://www.vbulletin.com/forum/showt...LE+deletionlog
      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

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X