WordPress.org

Forums

Edit Any Table
[resolved] Contact Form 7 DB Plugin: WordPress database error (6 posts)

  1. TYViral
    Member
    Posted 1 year ago #

    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/

  2. redeyedmonster
    Member
    Plugin Author

    Posted 1 year ago #

    Can you tell me the name of the table you are trying to access please.

  3. TYViral
    Member
    Posted 1 year ago #

    wp_cf7dbplugin_submits

    It's the only table of CF7DB plugins has

  4. redeyedmonster
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  5. TYViral
    Member
    Posted 1 year ago #

    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!

  6. redeyedmonster
    Member
    Plugin Author

    Posted 1 year ago #

    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 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

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Edit Any Table
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic