Title: SQL errors on install. Is this normal?
Last modified: December 25, 2016

---

# SQL errors on install. Is this normal?

 *  [cell](https://wordpress.org/support/users/cell/)
 * (@cell)
 * [22 years, 2 months ago](https://wordpress.org/support/topic/sql-errors-on-install-is-this-normal/)
 * I am installing WP 1.01 on a commercial hosting running mysql.
    These errors 
   shows up, but the installation seems to works out and i get my login password
   and can login normally. I wonder if this is common, and if its safe to use the
   WP installation? The errors are as the following: ===========================
   =============== SQL/DB Error: [You have an error in your SQL syntax 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 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
   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
   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 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 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) ==
   =========================================== is this normal? how is it for the
   long run?

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

 *  [Hella](https://wordpress.org/support/users/hella/)
 * (@hella)
 * [22 years, 2 months ago](https://wordpress.org/support/topic/sql-errors-on-install-is-this-normal/#post-42917)
 * Yes, this happens in 1.01. It’s fixed in the newer versions (1.2 >)
 *  [jitpal](https://wordpress.org/support/users/jitpal/)
 * (@jitpal)
 * [22 years, 2 months ago](https://wordpress.org/support/topic/sql-errors-on-install-is-this-normal/#post-43068)
 * Hello. Yeah, I am gettin the same problem using version 1.0.2. I thought I would
   try one of the nightly builds but those don’t extract from their archives correctly.
   I have no idea what I am doing wrong. The Install goes perfectly. I have deleted
   my MySQL database and the Install files multiple times and re-installed, re-setup.
   Still the same error. I am really anxious to use WordPress but I do not know 
   how to if it does not work. Thanks -Jitpal
 *  [jitpal](https://wordpress.org/support/users/jitpal/)
 * (@jitpal)
 * [22 years, 2 months ago](https://wordpress.org/support/topic/sql-errors-on-install-is-this-normal/#post-43148)
 * Hello. I guess the problem was cosmetic. The thing is, in IE it doesn’t work 
   but in Firefox it is working. I checked if my IE was showing a cached version
   but it was not. This is bizarre. Thanks -Jitpal
 *  [Sushubh](https://wordpress.org/support/users/sushubh/)
 * (@sushubh)
 * [22 years, 2 months ago](https://wordpress.org/support/topic/sql-errors-on-install-is-this-normal/#post-43152)
 * its called [SushubhEffect](http://wiki.wordpress.org/index.php/SushubhEffect)
   or so I have been told.
    if the blog’s running fine, there is nothing to be afraid
   off. 🙂

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

The topic ‘SQL errors on install. Is this normal?’ is closed to new replies.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 4 replies
 * 4 participants
 * Last reply from: [Sushubh](https://wordpress.org/support/users/sushubh/)
 * Last activity: [22 years, 2 months ago](https://wordpress.org/support/topic/sql-errors-on-install-is-this-normal/#post-43152)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics