Announcement

Collapse
No announcement yet.

Database error 1064 on Step 3 install

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

  • Database error 1064 on Step 3 install

    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


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

  • #2
    I assume you're trying to install vBulletin 3.6.2?
    Try using a shorter table prefix, without a dash (-).
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

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