PDA

View Full Version : Step 4 problem HELP

botcw
Wed 28th Feb '01, 3:18pm
I get to step 4 and it gives this error. I am running mySQL 3.22 and PHP3


<body><p>Setting up tables...</p>
<!-- Database error in vBulletin Installer: Invalid SQL: CREATE TABLE session (
sessionid MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL,
userid SMALLINT UNSIGNED NOT NULL,
ipaddress CHAR(20) NOT NULL,
lastactivity INT UNSIGNED NOT NULL,
location CHAR(250) NOT NULL,
PRIMARY KEY(sessionid)
)
mysql error: parse error near 'NOT NULL,
userid SMALLINT UNSIGNED NOT NULL,
ipaddress CHAR(20) NOT NULL,
' at line 2
mysql error number: 1064
Date: Wednesday 28th of February 2001 01:49:10 PM
Script: /talk/admin/install.php3?step=4
Referer: http://www.botcw.com/talk/admin/install.php3?step=3
Martin
Wed 28th Feb '01, 3:45pm
which version of php 3 are you using? and which version of vB are you trying to install?

if it's your own server, I would strongly recommend upgrading to the latest PHP and mySQL
botcw
Wed 28th Feb '01, 4:11pm
I am using PHP 3.0.11, mySQL 3.22 and trying to install vBulletin 1.1.5

vBulletin requirements say PHP 3.0.9 and mySQL 3.22
So I should be ok on the versions I'm using.

Jeff
Mike Sullivan
Wed 28th Feb '01, 5:43pm
Are you absolutely 100% sure you have 3.22? If you type in "mysql -uuser -ppassword" in telnet, what's the server version returned?

Even so, both your PHP and MySQL are quite old -- it is definately recommended that you upgrade.