Results 1 to 4 of 4

Thread: Database error

  1. #1
    Thread Starter
    sprexx's Avatar
    Join Date
    Oct 2013
    Location
    Germany
    Posts
    78
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Database error

    Hi, I get some problems with my db and the cron job.
    Any idea how to fix or manage?
    Maybe there are too many users or ads?


    Load..
    WordPress-Datenbank-Fehler The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay für Abfrage
    SELECT
    p.ID,
    p.post_author,
    p.post_title,
    p.post_date,
    pm.meta_value AS expire_date,
    u.user_email,
    COALESCE(t.postcount, 0) AS total_views,
    COALESCE(SUM(d.postcount), 0) AS week_views
    FROM
    wp_posts as p
    INNER JOIN wp_postmeta AS pm ON p.ID = pm.post_id AND pm.meta_key = 'cp_sys_expire_date'
    INNER JOIN wp_users AS u ON u.ID = p.post_author
    LEFT JOIN wp_cp_ad_pop_total AS t ON t.postnum = p.ID
    LEFT JOIN wp_cp_ad_pop_daily AS d ON d.postnum = p.ID AND d.time >= DATE_SUB(NOW(), INTERVAL 1 WEEK)
    WHERE
    p.post_type = 'ad_listing' AND p.post_status = 'publish'
    GROUP BY p.ID
    ORDER BY u.ID von CP_Ads_Stats->send_stats_emails, CP_Ads_Stats->get_ads
    Query db..
    Empty query

  2. #2
    Marketplace Seller roidayan's Avatar
    Join Date
    Apr 2014
    Location
    Israel
    Posts
    1,196
    Thanks
    34
    Thanked 157 Times in 144 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    Thread Starter
    sprexx's Avatar
    Join Date
    Oct 2013
    Location
    Germany
    Posts
    78
    Thanks
    5
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    Marketplace Seller roidayan's Avatar
    Join Date
    Apr 2014
    Location
    Israel
    Posts
    1,196
    Thanks
    34
    Thanked 157 Times in 144 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error after change database
    By ilcorriere in forum Report ClassiPress Bugs
    Replies: 6
    Last Post: February 23rd, 2016, 08:28 AM
  2. Database error after update to 3.2.1
    By ran55 in forum Report ClassiPress Bugs
    Replies: 8
    Last Post: March 10th, 2013, 07:18 AM
  3. Database error after update to 3.2.1
    By ran55 in forum ClassiPress General Discussion
    Replies: 1
    Last Post: March 9th, 2013, 11:42 AM
  4. MySQL Database error
    By silverfox in forum Report Clipper Bugs
    Replies: 1
    Last Post: September 17th, 2012, 07:58 PM
  5. Links and database error
    By bonzaicom in forum Report ClassiPress Bugs
    Replies: 2
    Last Post: July 8th, 2011, 04:48 AM