WordPress.org

Forums

Simple Ads Manager
Error with wp_sam_places (1 post)

  1. camrinp
    Member
    Posted 2 years ago #

    Hello All,

    I am using WordPress 3.7.1 and I am receiving the following error:

    Type:
    Output Error

    Error Message:
    Operand should contain 1 column(s)

    SQL:
    SELECT
    wp_sam_places.id,
    wp_sam_places.name,
    wp_sam_places.description,
    wp_sam_places.code_before,
    wp_sam_places.code_after,
    wp_sam_places.place_size,
    wp_sam_places.place_custom_width,
    wp_sam_places.place_custom_height,
    wp_sam_places.patch_img,
    wp_sam_places.patch_link,
    wp_sam_places.patch_code,
    wp_sam_places.patch_adserver,
    wp_sam_places.patch_dfp,
    wp_sam_places.patch_source,
    wp_sam_places.trash,
    (SELECT COUNT(*) FROM wp_sam_ads WHERE wp_sam_ads.pid = wp_sam_places.id AND wp_sam_ads.trash IS FALSE) AS ad_count,
    (SELECT COUNT(*) FROM wp_sam_ads WHERE wp_sam_ads.pid = wp_sam_places.id AND wp_sam_ads.trash IS FALSE AND (IF(wp_sam_ads.ad_users = 0, TRUE, IF(wp_sam_ads.ad_users_reg = 1,
    IF(wp_sam_ads.x_ad_users = 1, NOT FIND_IN_SET("admin", wp_sam_ads.x_view_users), TRUE) AND
    IF(wp_sam_ads.ad_users_adv = 1, (wp_sam_ads.adv_nick <> "admin"), TRUE),
    FALSE))) AND ((wp_sam_ads.view_type = 1) OR (wp_sam_ads.view_type = 0 AND (wp_sam_ads.view_pages+0 & 11)) OR (wp_sam_ads.view_type = 2 AND FIND_IN_SET(14, wp_sam_ads.view_id))) AND (wp_sam_ads.ad_cats = 0) AND (wp_sam_ads.ad_authors = 0) AND IF(wp_sam_ads.x_id, NOT FIND_IN_SET(14, wp_sam_ads.x_view_id), TRUE) AND IF(wp_sam_ads.ad_schedule, CURDATE() BETWEEN wp_sam_ads.ad_start_date AND wp_sam_ads.ad_end_date, TRUE) AND IF(wp_sam_ads.limit_hits, wp_sam_ads.hits_limit > wp_sam_ads.ad_hits, TRUE) AND IF(wp_sam_ads.limit_clicks, wp_sam_ads.clicks_limit > wp_sam_ads.ad_clicks, TRUE) AND (wp_sam_ads.ad_weight > 0)) AS ad_logic_count,
    (SELECT COUNT(*) FROM wp_sam_ads WHERE wp_sam_ads.pid = wp_sam_places.id AND wp_sam_ads.trash IS FALSE AND (IF(wp_sam_ads.ad_users = 0, TRUE, IF(wp_sam_ads.ad_users_reg = 1,
    IF(wp_sam_ads.x_ad_users = 1, NOT FIND_IN_SET("admin", wp_sam_ads.x_view_users), TRUE) AND
    IF(wp_sam_ads.ad_users_adv = 1, (wp_sam_ads.adv_nick <> "admin"), TRUE),
    FALSE))) AND ((wp_sam_ads.view_type = 1) OR (wp_sam_ads.view_type = 0 AND (wp_sam_ads.view_pages+0 & 11)) OR (wp_sam_ads.view_type = 2 AND FIND_IN_SET(14, wp_sam_ads.view_id))) AND (wp_sam_ads.ad_cats = 0) AND (wp_sam_ads.ad_authors = 0) AND IF(wp_sam_ads.x_id, NOT FIND_IN_SET(14, wp_sam_ads.x_view_id), TRUE) AND IF(wp_sam_ads.ad_schedule, CURDATE() BETWEEN wp_sam_ads.ad_start_date AND wp_sam_ads.ad_end_date, TRUE) AND IF(wp_sam_ads.limit_hits, wp_sam_ads.hits_limit > wp_sam_ads.ad_hits, TRUE) AND IF(wp_sam_ads.limit_clicks, wp_sam_ads.clicks_limit > wp_sam_ads.ad_clicks, TRUE) AND IF(wp_sam_ads.ad_weight > 0, (wp_sam_ads.ad_weight_hits*10/(wp_sam_ads.ad_weight*10,000)) < 1, FALSE)) AS ad_full_count
    FROM wp_sam_places
    WHERE wp_sam_places.id = 4 AND wp_sam_places.trash IS FALSE;

    Does anyone know the solution to this problem?

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic