{"id":7670808,"date":"2016-08-16T16:31:35","date_gmt":"2016-08-16T16:31:35","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-errors-upon-saving-settings\/"},"modified":"2016-09-01T17:55:47","modified_gmt":"2016-09-01T17:55:47","slug":"database-errors-upon-saving-settings","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-errors-upon-saving-settings\/","title":{"rendered":"Database Errors Upon Saving Settings"},"content":{"rendered":"<p>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:<\/p>\n<pre><code>WordPress database error Unknown column &#039;wp_cptch_packages.settings&#039; in &#039;field list&#039; for query SELECT\n\t\t&lt;code&gt;wp_cptch_packages&lt;\/code&gt;.&lt;code&gt;id&lt;\/code&gt;,\n\t\t&lt;code&gt;wp_cptch_packages&lt;\/code&gt;.&lt;code&gt;name&lt;\/code&gt;,\n\t\t&lt;code&gt;wp_cptch_packages&lt;\/code&gt;.&lt;code&gt;folder&lt;\/code&gt;,\n\t\t&lt;code&gt;wp_cptch_packages&lt;\/code&gt;.&lt;code&gt;settings&lt;\/code&gt;,\n\t\t&lt;code&gt;wp_cptch_images&lt;\/code&gt;.&lt;code&gt;name&lt;\/code&gt; AS &lt;code&gt;image&lt;\/code&gt;\n\tFROM\n\t\t&lt;code&gt;wp_cptch_packages&lt;\/code&gt;\n\tLEFT JOIN\n\t\t&lt;code&gt;wp_cptch_images&lt;\/code&gt;\n\tON\n\t\t&lt;code&gt;wp_cptch_images&lt;\/code&gt;.&lt;code&gt;package_id&lt;\/code&gt;=&lt;code&gt;wp_cptch_packages&lt;\/code&gt;.&lt;code&gt;id&lt;\/code&gt;\n\tGROUP BY &lt;code&gt;wp_cptch_packages&lt;\/code&gt;.&lt;code&gt;id&lt;\/code&gt;\n\tORDER BY &lt;code&gt;name&lt;\/code&gt; ASC; made by do_action(&#039;bws-panel_page_captcha&#039;), call_user_func_array, cptch_settings_page, Cptch_Basic_Settings-&gt;display_content, Cptch_Basic_Settings-&gt;display_tabs, Cptch_Basic_Settings-&gt;display_general_options, Cptch_Basic_Settings-&gt;add_pack_list_input<\/code><\/pre>\n<p>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.<\/p>\n<p>On a side note, please don&#8217;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.<\/p>\n<p>https:\/\/wordpress.org\/plugins\/captcha\/<\/p>\n","protected":false},"template":"","class_list":["post-7670808","topic","type-topic","status-publish","hentry","topic-tag-database-errors","topic-tag-settings"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7670808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7670808\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=7670808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}