Results 1 to 2 of 2

Thread: Error_Log filling up with one particular SQL error

  1. #1
    Thread Starter
    Member frostiecuk's Avatar
    Join Date
    Nov 2011
    Location
    United Kingdom
    Posts
    84
    Thanks
    11
    Thanked 3 Times in 3 Posts

    Question 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!

  2. #2
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    35,416
    Thanks
    158
    Thanked 2,830 Times in 2,708 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: December 22nd, 2013, 06:07 AM
  2. Replies: 2
    Last Post: January 15th, 2012, 12:39 PM
  3. [SOLVED] Error, Error, Error, MemberShip Pack Doesn't Work
    By hazara in forum Report ClassiPress Bugs
    Replies: 7
    Last Post: December 11th, 2011, 06:48 AM
  4. Filling in fields section..changing fields
    By jshgroup in forum Help Using ClassiPress
    Replies: 4
    Last Post: January 27th, 2011, 08:06 AM