Title: Database errors
Last modified: August 18, 2016

---

# Database errors

 *  [rosweed](https://wordpress.org/support/users/rosweed/)
 * (@rosweed)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/database-errors-3/)
 * When I tried to update my profile (to uncheck rich option)I got this error.
 * WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
   
   UPDATE wp_users SET user_pass=’2d4dae627fa978e2564e6000000000′, user_email=’rosweed@rosweed.
   com’, user_url=’[http://www.rosweed.com&#8217](http://www.rosweed.com&#8217);,
   user_nicename = ‘rosweed’, display_name = ‘rosweed’ WHERE ID = ‘1’
 * When I tried to post, I got this error.
 * WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
   
   INSERT IGNORE INTO wp_posts (post_author, post_date, post_date_gmt, post_content,
   post_content_filtered, post_title, post_excerpt, post_status, comment_status,
   ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt,
   post_parent, menu_order, post_mime_type) VALUES (‘1’, ‘2006-04-07 08:21:21’, ‘
   2006-04-07 12:21:21’, ‘test’, ”, ‘test’, ”, ‘publish’, ‘open’, ‘open’, ”, ‘test’,”,”,‘
   2006-04-07 08:21:21’, ‘2006-04-07 12:21:21’, ‘0’, ‘0’, ”)
 * 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”
   at line 3]
    SELECT category_id FROM wp_post2cat WHERE post_id =
 * 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‘
   2)’ at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 2)
 * WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
   
   INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (”,’_pingme’,’1′)
 * WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
   
   INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (”,’_encloseme’,’
   1′)
 * WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
   
   UPDATE wp_posts SET post_parent = 0 WHERE post_parent = -1144412454

Viewing 1 replies (of 1 total)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/database-errors-3/#post-370226)
 * If you try again after 10 minutes, what happens?
    (It’s a hosting error, not 
   yours)

Viewing 1 replies (of 1 total)

The topic ‘Database errors’ is closed to new replies.

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Mark (podz)](https://wordpress.org/support/users/podz/)
 * Last activity: [20 years, 1 month ago](https://wordpress.org/support/topic/database-errors-3/#post-370226)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics