Error_Log filling up with one particular SQL error
Does anyone else see in their error_log (a file contained in the root directory) the following error;
WordPress database error Unknown column 'exp2.meta_key' in 'where clause' for query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'coupon' AND (wp_posts.post_status = 'publish')
AND ( ( ( ( exp2.meta_key = 'clpr_votes_percent' AND CAST( exp2.meta_value AS SIGNED ) BETWEEN '0' AND '50' ) AND ( exp1.meta_key = 'clpr_votes_down' AND CAST( exp1.meta_value AS SIGNED) NOT BETWEEN '0' AND '0' ) ) OR ( ( exp3.meta_key = 'clpr_expire_date' AND STR_TO_DATE( exp3.meta_value, '%c-%d-%Y') < CURRENT_DATE() ) AND ( exp3.meta_key = 'clpr_expire_date' AND exp3.meta_value != '' ) ) ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.comment_count DESC LIMIT 0, 10 made by require, require_once, include, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, Widget_Popular_Coupons->widget, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
Every day I am having to delete this log file as it's growing to over 10Mb in size. Any ideas on what the problem is or how to fix it? The voting doesn't work, so it's somehow related to this theme...
Maybe someone can take a look their database and let me know what the settings are for the field "exp2.meta_key"... that would be a massive help!
Reply With Quote
You must be an AppThemes customer and logged in to view this response.