large amount of errors

  • Esquivelia

    (@esquivelia)


    10 years, 1 month ago

    I think this is also related to the inability to count clicks and such, which is another issue.

    here is one of many many errors.. all the same.

    Any help to remedy this would be great! Thanks.

    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 & 64))) AND (sa.ad_cats = 0) AND (sa.ad_authors = 0) 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 & 64))) AND (sa.ad_cats = 0) AND (sa.ad_authors = 0) 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 = 6 AND sp.trash IS FALSE;

    https://wordpress.org/plugins/simple-ads-manager/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author minimus

    (@minimus)

    10 years, 1 month ago

    Check whether there is DB table “wp_sam_stats” in the DB of your blog…

    jeffreyscottfrench

    (@jeffreyscottfrench)

    10 years, 1 month ago

    I actually just dealt with a lot of repeating errors as well. It was because I had hard coded a call to an ad place by calling for its id. However I was not ready to serve ads via that place because none had been sold. So as a temp fix (which was wrong) I put that ad place in the trash, so it wouldn’t serve an empty ad and count towards views on that ad place.

    Doing this created an error since the request found the ad, but it was in the trash, so it threw an error. Commented out the hardcoded request and no more errors.

    Thread Starter Esquivelia

    (@esquivelia)

    10 years, 1 month ago

    I also cannot create anything new. Ads places, etc.

    I do not have access to the database as of yet. Working on that.

    Does this sound like the same issue?

    Thread Starter Esquivelia

    (@esquivelia)

    10 years, 1 month ago

    Minimus.. the DB table “wp_sam_stats” does exist.

    Any other suggestions?

    Thanks! Cory-

    Thread Starter Esquivelia

    (@esquivelia)

    10 years ago

    I’ve tried disabling all other plugins, using the twenty ten theme.

    Still cannot create new ad places and the states are not being recorded.

    anyone? Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘large amount of errors’ is closed to new replies.

Tags