WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. TYViral
    Member
    Posted 4 months 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 4 months ago #

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

  3. TYViral
    Member
    Posted 4 months ago #

    wp_cf7dbplugin_submits

    It's the only table of CF7DB plugins has

  4. redeyedmonster
    Member
    Plugin Author

    Posted 4 months 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 4 months 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 4 months 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

Reply

You must log in to post.

About this Plugin

About this Topic