WP error when saving settings

  • Resolved John

    (@dsl225)


    8 years, 10 months ago

    Hello,

    I’m getting this error since version 4 when saving settings.
    Everything seems to work fine though:

    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 'SHOW_TABLES' at line 1 for query SHOW_TABLES made by do_action('toplevel_page_itsec'), call_user_func_array, ITSEC_Admin_Page_Loader->show_page, do_action('itsec-page-show'), call_user_func_array, ITSEC_Settings_Page->handle_page_load, ITSEC_Settings_Page->show_settings_page, ITSEC_Settings_Page->get_module_settings, ITSEC_Module_Settings_Page->render, ITSEC_Backup_Settings_Page->render_settings, ITSEC_Backup_Settings_Page->get_excludable_tables

    https://www.ads-software.com/plugins/better-wp-security/

Viewing 5 replies - 16 through 20 (of 20 total)

  • @zcambler – I can assure you that we did a lot of testing on this release before ever pushing it out. That’s not to say that there aren’t any issues. We certainly aren’t perfect.

    Having said that, if you aren’t getting the same error as the original poster, please make sure you open a new thread here, as this one will be marked as resolved shortly when that fix gets pushed live.

    This id the error you should see in your logs if you’re having the same problem:
    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 'SHOW_TABLES'

    @aaron D. Campbell
    Any settings in the new version of the plug – not saved. Backup is not working correctly. As you tested the plugin? answer here https://www.ads-software.com/support/topic/the-settings-are-not-saved?replies=1

    Thread Starter John

    (@dsl225)

    @zcambler

    Please just keep your discussion for your own thread.
    Your issue has nothing to do here and you just pollute this thread with unrelated comments.

    @john

    +1 ??

    I noticed Aaron’s message about a bugfix release which will deal with this issue shortly.

    Just wanted to add that the SQL error is not added to the error.log as a result of clicking on any Save Settings button. It’s a Database Backup rendering bug due to a typo …
    Just clicking on the Security (or Settings) menu option for instance will add the SQL error to the error.log. And once on the plugin Settings page, first clicking on the View Logs button and then clicking on the resulting Manage Settings button to return to the Settings page will also generate the SQL error in the error.log.

    Even though you don’t see it, all the html markup for all the Configure Settings popups is already generated when arriving on the Settings page. It is just hidden. Javascript driven, clicking on any feature’s Configure Settings button will unhide the relevant html markup that was already there (but hidden).

    Note the SQL error is not generated when the Database Backup Backup Full Database setting is disabled.

    Time to shut up (me) ??

    dwinden

    Thread Starter John

    (@dsl225)

    Thanks for this, good to know.
    I now updated to the latest version and everything seems to be ok.

Viewing 5 replies - 16 through 20 (of 20 total)
  • The topic ‘WP error when saving settings’ is closed to new replies.