Support » Plugin: Captcha » Database Errors Upon Saving Settings

  • Resolved jjbte

    (@jjbte)


    I have updated a couple of sites to the latest version (4.2.3) and both are exhibiting database errors whenever Captcha settings are saved:

    WordPress database error Unknown column 'wp_cptch_packages.settings' in 'field list' for query SELECT
    		<code>wp_cptch_packages</code>.<code>id</code>,
    		<code>wp_cptch_packages</code>.<code>name</code>,
    		<code>wp_cptch_packages</code>.<code>folder</code>,
    		<code>wp_cptch_packages</code>.<code>settings</code>,
    		<code>wp_cptch_images</code>.<code>name</code> AS <code>image</code>
    	FROM
    		<code>wp_cptch_packages</code>
    	LEFT JOIN
    		<code>wp_cptch_images</code>
    	ON
    		<code>wp_cptch_images</code>.<code>package_id</code>=<code>wp_cptch_packages</code>.<code>id</code>
    	GROUP BY <code>wp_cptch_packages</code>.<code>id</code>
    	ORDER BY <code>name</code> ASC; made by do_action('bws-panel_page_captcha'), call_user_func_array, cptch_settings_page, Cptch_Basic_Settings->display_content, Cptch_Basic_Settings->display_tabs, Cptch_Basic_Settings->display_general_options, Cptch_Basic_Settings->add_pack_list_input

    Indeed, my cptch_packages tables do not have a settings column. Should they have this column, or is this possibly a Free vs. Pro issue? I am using the free version.

    On a side note, please don’t set the plugin to change my settings upon update. On certain sites, I am using Captcha only on one or two forms (e.g., WordPress Login form, WordPress Registration form). Sometimes when I update the plugin, it automatically checks all forms.

    https://wordpress.org/plugins/captcha/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi,

    Please try to deactivate and activate the plugin.

    If there are no results, please complete the following steps:

    1) Using FTP, go to {your_site_home_folder}/wp-content/plugins/captcha;
    2) Open “captcha.php” file in the edit mode;
    3) Find the line $cptch_db_version = ‘1.2’; and repalce it with $cptch_db_version = ‘1.3’;;
    4) Save changes;
    5) Go to the plugin settings page (or reload it);
    6) Click “Save changes”.

    Check results.

    Sincerely,
    BestWebSoft Support Team

    Updating to 4.2.4 seems to have resolved this issue. Also, sites that went from 4.2.2 to 4.2.4 (with no update to 4.2.3 in the interim) did not have this issue.

    However, as noted in this thread, 4.2.4 introduced a new, more serious problem on sites that have WooCommerce installed.

    Hi,

    At the moment, the current version is 4.2.4. Please update the plugin and check results.

    Sincerely,
    BestWebSoft Support Team

    I have updated to 4.2.4. That’s what caused the new problem with WooCommerce sites, as discussed in this other thread.

    Updating to 4.2.4 resolved the database error issue (introduced in 4.2.3) discussed here.

    Hi,

    We analyzed our plugin and found out that the problem occurs because of TFA plugin. For plugin optimization, we’ve added the check for clicking “Log In” button which has name="wp-submit" attribute (in v. 4.2.4). If TFA is activated, when clicking “Log In” button, all elements of the form are hidden, and field “One Time Password” occurs with own “Log In” button which has no “name” attribute. That is why captcha is not checked.

    Sincerely,
    BestWebSoft Support Team

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database Errors Upon Saving Settings’ is closed to new replies.