Title: Error in SQL Syntax
Last modified: August 20, 2016

---

# Error in SQL Syntax

 *  Resolved [Rycher](https://wordpress.org/support/users/rycher/)
 * (@rycher)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-3/)
 * Hi Guys;
    I seem to have encountered an error I am unsure of how to resolve. 
   I was restoring a database from another plugin and was immediately given the 
   following error:
 *     ```
       1064 - 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 ''O:8:\"stdClass\":18:{s:4:\"name\";s:20:\"BulletProof Security\";s:4:\"slug\";s:' at line 1
   
       insert into wp_options (option_id, option_name, option_value, autoload) values ('16475', '_transient_bulletproof-security_info', 'O:8:\"stdClass\":18:{s:4:\"name\";s:20:\"BulletProof Security\";s:4:\"slug\";s:20:\"bulletproof-security\";s:7:\"version\";s:5:\".47.5\";s:6:\"author\";s:54:\"Edward Alexander\";s:14:\"author_profile\";s:36:\"http://profiles.wordpress.org/aitpro\";s:12:\"contributors\";a:1:{s:6:\"AITpro\";s:36:\"http://profiles.wordpress.org/aitpro\";}s:8:\"requires\";s:3:\"3.0\";s:6:\"tested\";s:3:\"3.5\";s:13:\"compatibility\";a:1:{s:5:\"3.4.2\";a:3:{s:5:\".47.3\";a:3:{i:0;i:100;i:1;i:3;i:2;i:3;}s:5:\".47.4\";a:3:{i:0;i:93;i:1;i:15;i:2;i:14;}s:5:\".47.5\";a:3:{i:0;i:71;i:1;i:7;i:2;i:5;}}}s:6:\"rating\";d:95;s:11:\"num_ratings\";i:440;s:10:\"downloaded\";i:384330;s:12:\"last_updated\";s:10:\"2012-10-22\";s:5:\"added\";s:10:\"2010-04-29\";s:8:\"homepage\";s:121:\"http://www.ait-pro.com/aitpro-blog/297/bulletproof-security-plugin-support/bulletproof-security-wordpress-plugin-support/\";s:8:\"sections\";a:6:{s:11:\"description\";s:7036:\"
       ```
   
 * And now the entire site is essentially gone, only the theme remains, no nav and
   everything 404’s can’t log in, the site no longer accceptsmy user name and password.
   
   Any advice, what am I missing? Thanks in advance.
 * [http://wordpress.org/extend/plugins/bulletproof-security/](http://wordpress.org/extend/plugins/bulletproof-security/)

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

 *  Plugin Author [AITpro](https://wordpress.org/support/users/aitpro/)
 * (@aitpro)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-3/#post-3201329)
 * I don’t think that this issue/problem is directly related to BPS even though 
   the MySQL error is showing wp_options DB info for BPS.
 * I think what you need to do at this point is use phpMyAdmin and get back into
   your site using these WP Codex guides below and also check your wp-config.php
   file – if the DB restore you did contained old DB connection info then you will
   need to add the correct DB connection info to your wp-config.php file:
 * How to deactivate all plugins when not able to access the administrative menus:
   [http://codex.wordpress.org/FAQ_Troubleshooting#How_to_deactivate_all_plugins_when_not_able_to_access_the_administrative_menus.3F](http://codex.wordpress.org/FAQ_Troubleshooting#How_to_deactivate_all_plugins_when_not_able_to_access_the_administrative_menus.3F)
 * Resetting your WordPress Password with phpMyAdmin
    [http://codex.wordpress.org/Resetting_Your_Password#Through_phpMyAdmin](http://codex.wordpress.org/Resetting_Your_Password#Through_phpMyAdmin)
 * And just for additional / extra reference:
    Moving WordPress [http://codex.wordpress.org/Moving_WordPress](http://codex.wordpress.org/Moving_WordPress)
 * Also you should delete your root .htaccess file as well until you get the Database
   problem figured out.
 *  Thread Starter [Rycher](https://wordpress.org/support/users/rycher/)
 * (@rycher)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-3/#post-3201350)
 * Thank you! It turns out the issue was not at all with BPS, as you pointed out.
   Sorry for the false alarm, I just assumed this would be a good place to start
   troubleshooting, since the wp_options DB info I was receiving had the BPS info
   all over it.
    Great plug-in keep up the great work!

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

The topic ‘Error in SQL Syntax’ is closed to new replies.

 * ![](https://ps.w.org/bulletproof-security/assets/icon-128x128.png?rev=1731938)
 * [BulletProof Security](https://wordpress.org/plugins/bulletproof-security/)
 * [Support Threads](https://wordpress.org/support/plugin/bulletproof-security/)
 * [Active Topics](https://wordpress.org/support/plugin/bulletproof-security/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/bulletproof-security/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/bulletproof-security/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Rycher](https://wordpress.org/support/users/rycher/)
 * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/error-in-sql-syntax-3/#post-3201350)
 * Status: resolved