DB function failed with error number 1030
Got error 28 from storage engine SQL=SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) as rw FROM jos_ad_agency_campaign_banner LEFT OUTER JOIN jos_ad_agency_banners as b ON b.id=banner_id LEFT JOIN jos_ad_agency_campaign as t0 ON campaign_id=t0.id WHERE b.zone=101 AND b.approved='Y' AND ((t0.default='Y') OR (t0.approved='Y' AND ('2012-01-28 04:53:27' > t0.start_date) AND ((t0.type IN ('cpm','pc') AND t0.quantity>0) OR (t0.type='fr' AND NOW() < t0.validity)))) AND t0.status='1' AND banner_id NOT IN (0) ORDER BY rw DESC LIMIT 1
Got error 28 from storage engine SQL=SELECT t0.*, b.zone, b.approved, campaign_id, banner_id, FLOOR(RAND() * relative_weighting) as rw FROM jos_ad_agency_campaign_banner LEFT OUTER JOIN jos_ad_agency_banners as b ON b.id=banner_id LEFT JOIN jos_ad_agency_campaign as t0 ON campaign_id=t0.id WHERE b.zone=101 AND b.approved='Y' AND ((t0.default='Y') OR (t0.approved='Y' AND ('2012-01-28 04:53:27' > t0.start_date) AND ((t0.type IN ('cpm','pc') AND t0.quantity>0) OR (t0.type='fr' AND NOW() < t0.validity)))) AND t0.status='1' AND banner_id NOT IN (0) ORDER BY rw DESC LIMIT 1














