{"id":10350289,"date":"2018-06-01T15:11:50","date_gmt":"2018-06-01T15:11:50","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/unknown-column-ip-in-field-list\/"},"modified":"2018-06-01T15:11:50","modified_gmt":"2018-06-01T15:11:50","slug":"unknown-column-ip-in-field-list","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/unknown-column-ip-in-field-list\/","title":{"rendered":"Unknown column &#8216;ip&#8217; in &#8216;field list&#8217;"},"content":{"rendered":"<p>Hi there, <\/p>\n<p>We are getting repeated errors showing up in our php error log like this: <\/p>\n<p>[30-May-2018 22:04:15 UTC] WordPress database error Unknown column &#8216;ip&#8217; in &#8216;field list&#8217; for query INSERT INTO <code>wp_redirection_404<\/code> (<code>url<\/code>, <code>created<\/code>, <code>ip<\/code>, <code>agent<\/code>) VALUES (&#8216;\/events\/sociable-cider-werks-dinner-at-nightingale\/&#8217;, &#8216;2018-05-30 17:04:15&#8217;, &#8216;157.55.39.221&#8217;, &#8216;Mozilla\/5.0 (compatible; bingbot\/2.0; +http:\/\/www.bing.com\/bingbot.htm)&#8217;) made by require(&#8216;wp-blog-header.php&#8217;), wp, WP-&gt;main, WP-&gt;handle_404, status_header, apply_filters(&#8216;status_header&#8217;), WP_Hook-&gt;apply_filters, call_user_func_array, WordPress_Module-&gt;status_header_404, RE_404::create<\/p>\n<p>I saw another resolved thread (https:\/\/wordpress.org\/support\/topic\/unknown-column-ip-in-field-list-for-query\/) saying that it&#8217;s possible our wp_redirection_404 table is missing a column, but I&#8217;m not an experienced coder and I&#8217;m not sure if I&#8217;m experiencing the same problem as that person. If so, I don&#8217;t understand how to implement the fixes proposed in that thread. Can you help? <\/p>\n","protected":false},"template":"","class_list":["post-10350289","topic","type-topic","status-publish","hentry","topic-tag-query","topic-tag-unknown-column"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/10350289","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\/10350289\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=10350289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}