Errors filling up my database FAST
-
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.
The topic ‘Errors filling up my database FAST’ is closed to new replies.