Forums

Installation - DB Syntax error - Missing tablenames (3 posts)

  1. larzi
    Member
    Posted 3 years ago #

    Hi,

    I am trying to get my first WordPress installation up and running, but its proving to be way more frustrating that I had hoped.

    I have created a DB, created a DB user and granted the user all access to the database.

    When I try to run the install.php, it goes through the first step, but at the second step, I get a lot of DB syntax errors, like 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 '( umeta_id bigint(20) NOT NULL auto_increment, user_id big]
    CREATE TABLE ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) )
    "

    Its clear that the SQL statements are missing the tablename. If I run the SQL statements manually and add a table name, the syntax is fine.

    The table names seems to be set in wp-settings.php - but why arent they loaded?

  2. podz
    Support Maven
    Posted 3 years ago #

    That's strange... where did you get the file, and how are you getting it to the website?
    Does a new download from here cause the same thing?

  3. larzi
    Member
    Posted 3 years ago #

    Hi,

    I had downloaded the 2.03 version from this site.

    However, I tried to re-download the file, and ran the installation once more, and now it works.

    Strange, but thanks for the suggestion.

Topic Closed

This topic has been closed to new replies.

About this Topic