{"id":3465841,"date":"2013-02-13T15:54:42","date_gmt":"2013-02-13T15:54:42","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/log-spam-sql-error-problem\/"},"modified":"2016-08-20T21:35:22","modified_gmt":"2016-08-20T21:35:22","slug":"log-spam-sql-error-problem","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/log-spam-sql-error-problem\/","title":{"rendered":"Log Spam – sql error problem"},"content":{"rendered":"

The sql error still exists. It appears you have hardcoded a wordpress table prefix “wp_” that is causing the problem.<\/p>\n

From the apache2 error log:<\/p>\n

[Wed Feb 13 07:50:03 2013] [error] [client 50.56.68.61] WordPress database error Unknown column 'wp_postmeta.meta_value' in 'where clause' for query SELECT SQL_CALC_FOUND_ROWS  xx_posts.ID, xx_posts.guid, xx_posts.post_title, xx_postmeta.meta_value FROM xx_posts  INNER JOIN xx_postmeta ON (xx_posts.ID = xx_postmeta.post_id) WHERE 1=1  AND (xx_postmeta.meta_key = '_feedwordpress_retire_me_46' AND wp_postmeta.meta_value = '1') AND (xx_posts.post_status <> 'fwpretired') GROUP BY xx_posts.ID ORDER BY xx_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, FeedWordPress->init, FeedWordPress->update_magic_url, FeedWordPress->update, do_action('feedwordpress_update_complete'), call_user_func_array, SyndicatedLink->process_retirements, WP_Query->__construct, WP_Query->query, WP_Query->get_posts<\/code><\/pre>\n
https:\/\/wordpress.org\/extend\/plugins\/feedwordpress\/<\/p>\n","protected":false},"template":"","class_list":["post-3465841","topic","type-topic","status-closed","hentry","topic-tag-hardcoded","topic-tag-sql-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/3465841","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\/3465841\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=3465841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}