Title: Problems with the Database
Last modified: August 18, 2016

---

# Problems with the Database

 *  [ohad](https://wordpress.org/support/users/ohad/)
 * (@ohad)
 * [22 years, 4 months ago](https://wordpress.org/support/topic/problems-with-the-database/)
 * Hi, I’m installing wordpress for the first time. I got the database running and
   set a user for it, the config file worked but then at the install.php I got these
   messages at step 3:
    ` SQL/DB 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 '' at line 1] SELECT * FROM wp_options WHERE option_id = SQL/DB Error:[
   Duplicate entry '55-0-default_post_status' for key 1] INSERT INTO wp_options (
   option_id, option_name, option_type, option_value, option_description, option_admin_level,
   option_width) VALUES(55,'default_post_status', 5, 'publish', 'The default state
   of each new post', 8, 20) SQL/DB 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 '' at line 1] SELECT * FROM wp_options WHERE option_id = SQL/
   DB Error: [Duplicate entry '56-0-default_comment_status' for key 1] INSERT INTO
   wp_options (option_id, option_name, option_type, option_value, option_description,
   option_admin_level, option_width) VALUES(56,'default_comment_status', 5, 'open','
   The default state of comments for each new post', 8, 20) SQL/DB 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 '' at line 1] SELECT * FROM wp_options
   WHERE option_id = SQL/DB Error: [Duplicate entry '57-0-default_ping_status' for
   key 1] INSERT INTO wp_options (option_id, option_name, option_type, option_value,
   option_description, option_admin_level, option_width) VALUES(57,'default_ping_status',
   5, 'open', 'The default ping state for each new post', 8, 20) SQL/DB 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 '' at line 1] SELECT * 
   FROM wp_options WHERE option_id = SQL/DB Error: [Duplicate entry '58-0-default_pingback_flag'
   for key 1] INSERT INTO wp_options (option_id, option_name, option_type, option_value,
   option_description, option_admin_level, option_width) VALUES(58,'default_pingback_flag',
   5, '1', 'Whether the \'PingBack the URLs in this post\' checkbox should be checked
   by default', 8, 20) SQL/DB 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 '' at line 1] SELECT * FROM wp_options WHERE option_id = SQL/DB Error:[
   Duplicate entry '59-0-default_post_category' for key 1] INSERT INTO wp_options(
   option_id, option_name, option_type, option_value, option_description, option_admin_level,
   option_width) VALUES(59,'default_post_category', 7, '1', 'The default category
   for each new post', 8, 20) SQL/DB 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 '' at line 1] SELECT * FROM wp_options WHERE option_id = SQL/
   DB Error: [Duplicate entry '83-0-default_post_edit_rows' for key 1] INSERT INTO
   wp_options (option_id, option_name, option_type, option_value, option_description,
   option_admin_level, option_width) VALUES(83,'default_post_edit_rows', 1, '9','
   The number of rows in the edit post form (min 3, max 100)', 8, 5)  What have 
   I done wrong? what do I need to do? Please help!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Anonymous
 * [22 years, 3 months ago](https://wordpress.org/support/topic/problems-with-the-database/#post-35033)
 * I get this same error, dropped all of the tables from the DB and started fresh
   and got the same errors again
 *  Anonymous
 * [22 years, 3 months ago](https://wordpress.org/support/topic/problems-with-the-database/#post-35035)
 * Sometimes you get all those *errors* but if you ignore them it installs just 
   fine. Welcome to WordPress. 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problems with the Database’ is closed to new replies.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 2 participants
 * Last reply from: Anonymous
 * Last activity: [22 years, 3 months ago](https://wordpress.org/support/topic/problems-with-the-database/#post-35035)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics