WordPress.org

Forums

[resolved] WordPress database error: (3 posts)

  1. RogerUsh
    Member
    Posted 8 years ago #

    I'm getting this:

    WordPress database 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 '02-v4_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varch' at line 1]
    CREATE TABLE 02-v4_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default '', category_nicename varchar(200) NOT NULL default '', category_description longtext NOT NULL, category_parent bigint(20) NOT NULL default '0', category_count bigint(20) NOT NULL default '0', PRIMARY KEY (cat_ID), KEY category_nicename (category_nicename) )

    Just doing a clean install of the newest WordPress. I'm pretty sure my host is running the required version of MySQL and PHP. I'm using Dreamhost.

    I've recently been messing with the SQL tables though, so I don't know if it has something to do with that. I am using an pre-existing database, but I changed the prefix in the config.php file for the new install.

    Any help?

    -Rog

  2. moshu
    Member
    Posted 8 years ago #

    Try NOT to have dashes in the prefix and report back if it works.

  3. RogerUsh
    Member
    Posted 8 years ago #

    Yup, that was it. It was the lone dash that was cramping my style... yup.

    Thanks man!

Topic Closed

This topic has been closed to new replies.

About this Topic