- OpenX Community Forums
![]() ![]() |
Apr 7 2012, 08:22 AM
Post
#1
|
|
|
Beginner ![]() Group: Members Posts: 1 Joined: 7-April 12 Member No.: 172,076 |
Hi:
I have upgraded by Openx today to 2.8.8. Everything is working fine expect OpenX Market Plugin. When i am click on statics it is showing this error PEAR Error MDB2 Error: no such table _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT m.clientid AS advertiser_id,d.campaignid AS placement_id,s.ad_id AS ad_id,SUM(s.impressions) AS sum_views,SUM(s.clicks) AS sum_clicks,SUM(s.revenue) AS sum_revenue,CONCAT(m.campaignid, IF( LENGTH(market_advertiser_id) > 0, CONCAT('_', market_advertiser_id, '_'), '_'), ad_width, ' x ',ad_height) AS ad_id,(CONCAT(m.campaignid, IF( LENGTH(market_advertiser_id) > 0, CONCAT('_', market_advertiser_id, '_'), '_'), ad_width, ' x ',ad_height)) AS pkey FROM ox_ext_market_stats AS s INNER JOIN ox_banners AS d ON (d.bannerid=s.ad_id) INNER JOIN ox_campaigns AS m ON (m.campaignid=d.campaignid) INNER JOIN ox_clients AS a ON (a.clientid=m.clientid) WHERE a.type = 1 AND s.zone_id <> 0 AND s.date_time>='2012-03-26 04:00:00' AND s.date_time<='2012-04-02 03:59:59' GROUP BY advertiser_id,placement_id,pkey] [Native code: 1146] [Native message: Table 'mar1207808595437.ox_ext_market_stats' doesn't exist] PEAR Error MDB2 Error: no such table _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT m.clientid AS advertiser_id,d.campaignid AS placement_id,s.ad_id AS ad_id,SUM(s.impressions) AS sum_views,SUM(s.clicks) AS sum_clicks,SUM(s.revenue) AS sum_revenue,CONCAT(m.campaignid, IF( LENGTH(market_advertiser_id) > 0, CONCAT('_', market_advertiser_id, '_'), '_'), ad_width, ' x ',ad_height) AS ad_id,(CONCAT(m.campaignid, IF( LENGTH(market_advertiser_id) > 0, CONCAT('_', market_advertiser_id, '_'), '_'), ad_width, ' x ',ad_height)) AS pkey FROM ox_ext_market_stats AS s INNER JOIN ox_banners AS d ON (d.bannerid=s.ad_id) INNER JOIN ox_campaigns AS m ON (m.campaignid=d.campaignid) INNER JOIN ox_clients AS a ON (a.clientid=m.clientid) WHERE s.zone_id = 0 AND a.type = 1 AND s.date_time>='2012-03-26 04:00:00' AND s.date_time<='2012-04-02 03:59:59' AND s.zone_id = 0 GROUP BY advertiser_id,placement_id,pkey] [Native code: 1146] [Native message: Table 'mar1207808595437.ox_ext_market_stats' doesn't exist] Fatal error: Unsupported operand types in /home/content/34/9087034/html/saanjads123/www/admin/market/stats.php on line 164 also this error that plugin is missing admin/plugins/oxMarket/market-index.php was not found on this server. How i can fix that.. could you please help me |
|
|
|
![]() ![]() |