Announcement

Collapse
No announcement yet.

Database Import/vB Upgrade Error

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

  • Database Import/vB Upgrade Error

    I have a strange error with my new hoster.
    I installed vB 2 on my new account and tried to import my vB2 Database Dump with Telnet.
    I got the following error :
    ______________________________________
    ERROR 1121 at line 988: Column 'userid' is used with UNIQUE or INDEX but is not defined as NOT NULL
    ______________________________________

    I thougt "No Problem" and installed my old vB 1.1.6 and imported my old 1.1.6 Dump via Telnet. Everything worked fine. But when I try to upgrade to vB 2.0 RC1, I got the following error :

    ______________________________________

    Database error in vBulletin Upgrade: Invalid SQL: CREATE TABLE pollvote (
    pollvoteid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    pollid INT UNSIGNED,
    userid INT UNSIGNED,
    votedate INT UNSIGNED,
    voteoption INT UNSIGNED NOT NULL,
    PRIMARY KEY (pollvoteid),
    KEY userid (userid, pollid)
    )
    mysql error: Column 'userid' is used with UNIQUE or INDEX but is not defined as NOT NULL
    mysql error number: 1121
    Date: Sunday 22nd of April 2001 09:33:10 PM
    Script: /board/admin/upgrade1.php?step=2
    Referer: http://www.mydomain.de/board/admin/upgrade1.php
    _______________________________________

    Then I downloaded the vB2 Dump from my FTP and imported it on my local PC, and everything worked fine.
    Is this a problem of my hoster ?

  • #2
    http://www.vbulletin.com/forum/showt...4313#post94313

    Comment


    • #3
      Thank you tubedogg, but I found it for myself
      I my case it was in the upgrade1.php and I changed

      pollid INT UNSIGNED,
      userid INT UNSIGNED,

      to

      pollid INT UNSIGNED NOT NULL,
      userid INT UNSIGNED NOT NULL,

      on line 651 and 652.

      Comment

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