Title: WordPress database error – error in SQL syntax;
Last modified: August 20, 2016

---

# WordPress database error – error in SQL syntax;

 *  [jasniya](https://wordpress.org/support/users/jasniya/)
 * (@jasniya)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-error-in-sql-syntax-2/)
 * I am using the geoplaces theme by templatic. I am not able to add items to the
   mega menu. Error log shows :
    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 1 for query SELECT * FROM wp_posts WHERE
   id = made by do_action_ref_array, call_user_func_array, check_and_publish_future_post,
   wp_publish_post, wp_transition_post_status, do_action, call_user_func_array, 
   apt_check_required_transition, apt_publish_post

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

 *  Thread Starter [jasniya](https://wordpress.org/support/users/jasniya/)
 * (@jasniya)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-error-in-sql-syntax-2/#post-2866951)
 * 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 1 for query SELECT * FROM wp_posts WHERE id = made by **wp_update_nav_menu_item**,
   wp_update_post, wp_insert_post, wp_transition_post_status, do_action(‘transition_post_status’),
   call_user_func_array, apt_check_required_transition, apt_publish_post
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-error-in-sql-syntax-2/#post-2866963)
 * Have you tried:
 * – deactivating **all** plugins to see if this resolves the problem. If this works,
   re-activate the plugins one by one until you find the problematic plugin(s).
 * – switching to the Twenty Eleven theme to rule out any theme-specific problems.
 * – [resetting the plugins folder](http://codex.wordpress.org/FAQ_Troubleshooting#How_to_deactivate_all_plugins_when_not_able_to_access_the_administrative_menus.3F)
   by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause
   problems.
 *  Thread Starter [jasniya](https://wordpress.org/support/users/jasniya/)
 * (@jasniya)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-error-in-sql-syntax-2/#post-2867008)
 * I deactivated the plugins , now Im getting a new error: [03-Jul-2012 12:41:57
   UTC] PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit
   change max_input_vars in php.ini. in Unknown on line 0
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-error-in-sql-syntax-2/#post-2867091)
 * Try asking your hosts for assistance with this.

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

The topic ‘WordPress database error – error in SQL syntax;’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [esmi](https://wordpress.org/support/users/esmi/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-error-in-sql-syntax-2/#post-2867091)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics