Title: Database Errors Upon Saving Settings
Last modified: September 1, 2016

---

# Database Errors Upon Saving Settings

 *  Resolved [jjbte](https://wordpress.org/support/users/jjbte/)
 * (@jjbte)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/)
 * 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/](https://wordpress.org/plugins/captcha/)

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

 *  [bestwebsoft](https://wordpress.org/support/users/bestwebsoft/)
 * (@bestwebsoft)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/#post-7671208)
 * 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
 *  Thread Starter [jjbte](https://wordpress.org/support/users/jjbte/)
 * (@jjbte)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/#post-7671221)
 * 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](https://wordpress.org/support/topic/login-allowed-even-when-captcha-answer-is-incorrect?replies=1),
   4.2.4 introduced a new, more serious problem on sites that have WooCommerce installed.
 *  [bestwebsoft](https://wordpress.org/support/users/bestwebsoft/)
 * (@bestwebsoft)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/#post-7671256)
 * Hi,
 * At the moment, the current version is 4.2.4. Please update the plugin and check
   results.
 * Sincerely,
    BestWebSoft Support Team
 *  Thread Starter [jjbte](https://wordpress.org/support/users/jjbte/)
 * (@jjbte)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/#post-7671258)
 * I have updated to 4.2.4. That’s what caused the new problem with WooCommerce 
   sites, as discussed in [this other thread](https://wordpress.org/support/topic/login-allowed-even-when-captcha-answer-is-incorrect?replies=1).
 * Updating to 4.2.4 resolved the database error issue (introduced in 4.2.3) discussed
   here.
 *  [bestwebsoft](https://wordpress.org/support/users/bestwebsoft/)
 * (@bestwebsoft)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/#post-8210910)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/captcha_92b6c9.svg)
 * [Captcha](https://wordpress.org/plugins/captcha/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/captcha/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/captcha/)
 * [Active Topics](https://wordpress.org/support/plugin/captcha/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/captcha/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/captcha/reviews/)

## Tags

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

 * 5 replies
 * 2 participants
 * Last reply from: [bestwebsoft](https://wordpress.org/support/users/bestwebsoft/)
 * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/database-errors-upon-saving-settings/#post-8210910)
 * Status: resolved