Error messages

  • Hello, it seems every thing is working fine. All banner appears at the right place. I’m using only Ad Places. But there are are lot off error messages like this:

    Error Date: 18. August 2014 09:46
    Table: wp_sam_places
    Type:
    Output Error

    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 & 1152))) AND (sa.ad_cats = 0) AND (sa.ad_authors = 0) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 1152, TRUE), FIND_IN_SET(‘klaus-hoffmann’, sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 1152, TRUE), NOT FIND_IN_SET(‘klaus-hoffmann’, sa.x_view_tags), 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 & 1152))) AND (sa.ad_cats = 0) AND (sa.ad_authors = 0) AND IF(sa.view_type < 2 AND sa.ad_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 1152, TRUE), FIND_IN_SET(‘klaus-hoffmann’, sa.view_tags), TRUE) AND IF(sa.view_type < 2 AND sa.x_tags AND IF(sa.view_type = 0, sa.view_pages+0 & 1152, TRUE), NOT FIND_IN_SET(‘klaus-hoffmann’, sa.x_view_tags), 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*1000)) < 1, FALSE)) AS ad_full_count
    FROM wp_sam_places sp
    WHERE sp.id = 4 AND sp.trash IS FALSE;

    https://www.ads-software.com/plugins/simple-ads-manager/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter klartext-ne

    (@klartext-ne)

    Next error: while saving

    Returned data is not in valid JSON format.

    Thread Starter klartext-ne

    (@klartext-ne)

    Next problem: I can’t turn off the error log

    Almost same error here.

    [17-Feb-2015 18:54:11] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY ad_cycle
    LIMIT 1′ at line 52 for query
    SELECT
    @pid := sp.id AS pid,
    0 AS aid,
    sp.name,
    sp.patch_source AS code_mode,
    @code_before := sp.code_before AS code_before,
    @code_after := sp.code_after AS code_after,
    @ad_size := IF(sp.place_size = “custom”, CONCAT(CAST(sp.place_custom_width AS CHAR), “x”, CAST(sp.place_custom_height AS CHAR)), sp.place_size) AS ad_size,
    sp.patch_code AS ad_code,
    sp.patch_img AS ad_img,
    “” AS ad_alt,
    0 AS ad_no,
    sp.patch_link AS ad_target,
    0 AS ad_swf,
    “” AS ad_swf_flashvars,
    “” AS ad_swf_params,
    “” AS ad_swf_attributes,
    sp.patch_adserver AS ad_adserver,
    sp.patch_dfp AS ad_dfp,
    0 AS count_clicks,
    0 AS code_type,
    IF((sp.patch_source = 1 AND sp.patch_adserver) OR sp.patch_source = 2, -1, 1) AS ad_cycle,
    @aca := IFNULL((SELECT AVG(wsa.ad_weight_hits*10/(wsa.ad_weight*2147483647)) FROM wp_sam_ads wsa WHERE wsa.pid = @pid AND wsa.trash IS NOT TRUE), 0) AS aca
    FROM wp_sam_places sp
    WHERE sp.id = 2 AND sp.trash IS FALSE
    UNION
    SELECT
    sa.pid,
    sa.id AS aid,
    sa.name,
    sa.code_mode,
    @code_before AS code_before,
    @code_after AS code_after,
    @ad_size AS ad_size,
    sa.ad_code,
    sa.ad_img,
    sa.ad_alt,
    sa.ad_no,
    sa.ad_target,
    sa.ad_swf,
    sa.ad_swf_flashvars,
    sa.ad_swf_params,
    sa.ad_swf_attributes,
    0 AS ad_adserver,
    0 AS ad_dfp,
    sa.count_clicks,
    sa.code_type,
    IF(sa.ad_weight, (sa.ad_weight_hits*10/(sa.ad_weight*2147483647)), 0) AS ad_cycle,
    @aca AS aca
    FROM wp_sam_ads sa
    WHERE sa.pid = @pid AND sa.trash IS FALSE AND
    ORDER BY ad_cycle
    LIMIT 1; made by SamAdPlace->__construct, SamAdPlace->buildAd, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    This is critical bug, please fast FIX

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error messages’ is closed to new replies.