- OpenX Community Forums

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Problem With Openx 2.8.8, error during upgrade
saanjnet
post 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
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

 

Locations of visitors to this page