Database error 1064 on Step 3 install

[pyramidcam]

Anyone out there have an idea what's going on here and how we can fix this?

Very much appreciate your help if you do.

Many thanks,

Jim


We're running

MySQL 4.1.21
PHP Version 4.4.4

At step three of the installation this is what appeared:

========================================================================================== =

Step 3) Creating Tables

Creating pyramidcam_com_-_access table Database error
The database has encountered a problem.

--------------------------------------------------------------------------------


Database error in vBulletin :

Invalid SQL:

CREATE TABLE pyramidcam_com_-_access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, 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 '-_access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED' at line 1
Error Number : 1064
Date : Friday, October 6th 2006 @ 03:16:40 PM
Script : http://www.pyramidcam.com/forums/ins...all.php?step=3
Referrer : http://www.pyramidcam.com/forums/ins...all.php?step=2
IP Address : 62.139.173.152
Username :
Classname : vb_database

========================================================================================== =====

[Colin F]

I assume you're trying to install vBulletin 3.6.2?
Try using a shorter table prefix, without a dash (-).