Database Import/vB Upgrade Error

[MaSTaKiLLaH]

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 ?

[tubedogg]

http://www.vbulletin.com/forum/showthread.php?postid=94313#post94313

[MaSTaKiLLaH]

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.