postgres db 版本 9.x 出现 openx adserver 统计选项卡错误

Question

我安装了最新的 openX 广告服务器（发布服务器）和 postgres 9.x 版本。

成功安装和配置后，我登录并单击“统计”选项卡，我看到以下错误。

当我使用 mysql 安装 openX 服务器时没有看到此错误，有任何快速修复吗？

PEAR 错误

MDB2 错误：未知错误 _doQuery：[错误消息：无法执行语句] [上次执行的查询：SELECT m.clientid AS adverter_id,d.campaignid ASplacement_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 , m.campaignid || IF( LENGTH(market_advertiser_id) > 0, ('_' || market_advertiser_id || ''), '') ||广告宽度 || 'x' || ad_height AS ad_id,( m.campaignid || IF( LENGTH(market_advertiser_id) > 0, ('_' || 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) 内连接 "ox_affiliates" AS p ON (p.affiliateid=z.affiliateid) 内连接 "ox_clients" AS a ON (a.clientid=m.clientid) WHERE s .ad_id IN (1,2) AND a.type = 1 AND s.zone_id <> 0 AND s.date_time>='2011-02-22 00:00:00' AND s.date_time<='2011-02-22 23:59:59' GROUP BYadvertiser_id,placement_id,pkey]

[原生消息：错误：列“s.ad_id”必须出现在 GROUP BY 子句中或在字符 65 处的聚合函数中使用]

PEAR 错误

MDB2 错误：未知错误 _doQuery：[错误消息：无法执行语句] [上次执行的查询：SELECT m.clientid AS adverter_id,d.campaignid ASplacement_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 , m.campaignid || IF( LENGTH(market_advertiser_id) > 0, ('_' || market_advertiser_id || ''), '') ||广告宽度 || 'x' || ad_height AS ad_id,( m.campaignid || IF( LENGTH(market_advertiser_id) > 0, ('_' || 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) 其中 s.ad_id IN (1,2) AND s.zone_id = 0 AND a.type = 1 AND s.date_time>='2011-02-22 00： 00:00' AND s.date_time<='2011-02-22 23:59:59' AND s.zone_id = 0 GROUP BYadvertiser_id,placement_id,pkey]

[原生消息：错误：必须出现“s.ad_id”列在 GROUP BY 子句中或在字符 65 处的聚合函数中使用]

Answer 1

好的，我找到了解决方案。要解决此问题，必须在 lib/max/SqlBuilder.php 中的第 1031 行之后添加此代码。

$aGroupColumns[] = "s.ad_id";