Error with wp_sam_places
-
Hello All,
I am using WordPress 3.7.1 and I am receiving the following error:
Type:
Output ErrorError 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?
- The topic ‘Error with wp_sam_places’ is closed to new replies.