• 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?

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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?

    Thread Starter larzi

    (@larzi)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Installation – DB Syntax error – Missing tablenames’ is closed to new replies.