History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: OX-5885
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: matthieu.aubry
Reporter: Joanna Mazgaj
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
OpenX Ad Server

PEAR Error on stats screen for 2.8.4 on psql

Created: 19/Jan/10 11:09 AM   Updated: 26/Jan/10 02:07 PM
Component/s: OXP: User Interface
Affects Version/s: OpenX 2.8.4
Fix Version/s: OpenX 2.8.4
Security Level: Public (All users can see these issues)

Time Tracking:
Not Specified

Environment: 2.8.4 rc16 on psql


 Description  « Hide

PEAR Error

MDB2 Error: unknown error

_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_zones" AS z ON (z.zoneid=s.zone_id) INNER JOIN "ox_campaigns" AS m ON (m.campaignid=d.campaignid) INNER JOIN "ox_affiliates" AS p ON (p.affiliateid=z.affiliateid) INNER JOIN "ox_clients" AS a ON (a.clientid=m.clientid) WHERE s.ad_id IN (1,2,3,4) AND a.type = 1 AND s.zone_id <> 0 AND s.date_time>='2010-01-18 23:00:00' AND s.date_time<='2010-01-19 22:59:59' GROUP BY advertiser_id,placement_id,pkey]
[Native message: ERROR: function concat(unknown, character, unknown) does not exist
LINE 1: ...campaignid, IF( LENGTH(market_advertiser_id) > 0, CONCAT('_'...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.]

PEAR Error

MDB2 Error: unknown error

_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.ad_id IN (1,2,3,4) AND s.zone_id = 0 AND a.type = 1 AND s.date_time>='2010-01-18 23:00:00' AND s.date_time<='2010-01-19 22:59:59' AND s.zone_id = 0 GROUP BY advertiser_id,placement_id,pkey]
[Native message: ERROR: function concat(unknown, character, unknown) does not exist
LINE 1: ...campaignid, IF( LENGTH(market_advertiser_id) > 0, CONCAT('_'...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.]

Fatal error: Unsupported operand types in /openx-2.8.4-rc16/www/admin/market/stats.php on line 156



 All   Comments   Work Log   Change History   FishEye   Crucible   Builds      Sort Order: Ascending order - Click to sort in descending order
Error communicating with FishEye: java.io.IOException: https://developer.openx.org/fisheye/api/rest/query returned 503 Service Temporarily Unavailable