• Hi, I am getting errors in the logs that say “output error” from the wp_sam_places table.

    the error is this:
    SELECT
    sp.id,
    sp.name,
    sp.description,
    sp.code_before,
    sp.code_after,
    sp.place_size,
    sp.place_custom_width,
    sp.place_custom_height,
    sp.patch_img,
    sp.patch_link,
    sp.patch_code,
    sp.patch_adserver,
    sp.patch_dfp,
    sp.patch_source,
    sp.trash,
    (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE) AS ad_count,
    (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(176419, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET(“alaska”, sa.view_cats) OR FIND_IN_SET(“announcement”, sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET(“steventfink”, sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET(“alaska”, sa.view_custom_tax_terms) OR FIND_IN_SET(“announcement”, sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(176419, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET(“alaska”, sa.x_view_cats)) AND (NOT FIND_IN_SET(“announcement”, sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET(“steventfink”, sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET(“alaska”, sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET(“announcement”, sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND (sa.ad_weight > 0)) AS ad_logic_count,
    (SELECT COUNT(*) FROM wp_sam_ads sa WHERE sa.pid = sp.id AND sa.trash IS FALSE AND (IF(sa.ad_users = 0, TRUE, (sa.ad_users_unreg = 1))) AND ((sa.view_type = 1) OR (sa.view_type = 0 AND (sa.view_pages+0 & 6)) OR (sa.view_type = 2 AND FIND_IN_SET(176419, sa.view_id))) AND IF(sa.view_type < 2 AND sa.ad_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET(“alaska”, sa.view_cats) OR FIND_IN_SET(“announcement”, sa.view_cats), TRUE) AND IF(sa.view_type < 2 AND sa.ad_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET(“steventfink”, sa.view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), FIND_IN_SET(“alaska”, sa.view_custom_tax_terms) OR FIND_IN_SET(“announcement”, sa.view_custom_tax_terms), TRUE) AND IF(sa.x_id, NOT FIND_IN_SET(176419, sa.x_view_id), TRUE) AND IF(sa.view_type < 2 AND sa.x_cats AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET(“alaska”, sa.x_view_cats)) AND (NOT FIND_IN_SET(“announcement”, sa.x_view_cats)), TRUE) AND IF(sa.view_type < 2 AND sa.x_authors AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), NOT FIND_IN_SET(“steventfink”, sa.x_view_authors), TRUE) AND IF(sa.view_type < 2 AND sa.x_ad_custom_tax_terms AND IF(sa.view_type = 0, sa.view_pages+0 & 6, TRUE), (NOT FIND_IN_SET(“alaska”, sa.x_view_custom_tax_terms)) AND (NOT FIND_IN_SET(“announcement”, sa.x_view_custom_tax_terms)), TRUE) AND IF(sa.ad_schedule, CURDATE() BETWEEN sa.ad_start_date AND sa.ad_end_date, TRUE) AND IF(sa.limit_hits, sa.hits_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 0), TRUE) AND IF(sa.limit_clicks, sa.clicks_limit > (SELECT IFNULL(COUNT(*), 0) FROM wp_sam_stats ss WHERE ss.id = sa.id AND ss.event_type = 1), TRUE) AND IF(sa.ad_weight > 0, (sa.ad_weight_hits*10/(sa.ad_weight*1)) < 1, FALSE)) AS ad_full_count
    FROM wp_sam_places sp
    WHERE sp.id = 10 AND sp.trash IS FALSE;

    I get about 100 errors a minute and getting faster.

    Thanks.

    https://ww.wp.xz.cn/plugins/simple-ads-manager/

Viewing 1 replies (of 1 total)
  • Thread Starter sewardcitynews

    (@sewardcitynews)

    By the way, I am trying to donate to you on this software. However I am getting “Private loads are not supported for this card” in the Amount to Load section.

    Also, I was able to turn off the error logs so my DB doesnt fill up any more, thanks for that option.

    My only concern is that the error above is is becoming more frequent, but otherwise the plugin seems to work just fine.

    -Steve

Viewing 1 replies (of 1 total)

The topic ‘Errors filling up my database FAST’ is closed to new replies.