Title: Contact Form 7 DB Plugin: WordPress database error
Last modified: August 21, 2016

---

# Contact Form 7 DB Plugin: WordPress database error

 *  Resolved [TYViral](https://wordpress.org/support/users/tyviral/)
 * (@tyviral)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/)
 * Plugin works perfectly on editing any tables unless table from CF7DB Plugin. 
   It says,
 * `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]`
 * when I tried to click on save button. Any helps?
 * [http://wordpress.org/plugins/edit-any-table/](http://wordpress.org/plugins/edit-any-table/)

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

 *  Plugin Author [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * (@redeyedmonster)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/#post-4388241)
 * Can you tell me the name of the table you are trying to access please.
 *  Thread Starter [TYViral](https://wordpress.org/support/users/tyviral/)
 * (@tyviral)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/#post-4388253)
 * wp_cf7dbplugin_submits
 * It’s the only table of CF7DB plugins has
 *  Plugin Author [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * (@redeyedmonster)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/#post-4388267)
 * OK – I installed the plugin but it doesn’t immediately create the table. I’ll
   set up a test page and do some tests. Thanks for your patience.
 *  Thread Starter [TYViral](https://wordpress.org/support/users/tyviral/)
 * (@tyviral)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/#post-4388272)
 * You need to create form by Contact Form 7 (else plugin like FSCF, Jetpack Contact
   Form also could call the table but I’m using CF7 instead) to table to be made
   instead of just installing CFDB plugin.
 * Nice support!
 *  Plugin Author [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * (@redeyedmonster)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/#post-4388292)
 * OK – sorry for the delay, Christmas and all that.
 * The reason you are getting this error is because the table you are trying to 
   edit has **no primary key**. Edit Any table uses the primary key to identify 
   which record it is going to update, this is the only way it can uniquely identify
   the record. If you have access to something like PhpMyAdmin you can [add an auto incrementing primary key](http://trebleclick.blogspot.co.uk/2009/01/mysql-set-auto-increment-in-phpmyadmin.html)
   to the table. I have tested this and the Contact Form 7 DB plugin still works
   fine and Edit Any Table is then able to do it’s stuff. HTH

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

The topic ‘Contact Form 7 DB Plugin: WordPress database error’ is closed to new 
replies.

 * ![](https://s.w.org/plugins/geopattern-icon/edit-any-table.svg)
 * [Edit Any Table](https://wordpress.org/plugins/edit-any-table/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/edit-any-table/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/edit-any-table/)
 * [Active Topics](https://wordpress.org/support/plugin/edit-any-table/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/edit-any-table/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/edit-any-table/reviews/)

## Tags

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

 * 5 replies
 * 2 participants
 * Last reply from: [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/contact-form-7-db-plugin-wordpress-database-error/#post-4388292)
 * Status: resolved