When I click on the link for "AdSense Clicks" "By Day"

I get the red db error

* warning: pg_query() [function.pg-query]: Query failed: ERROR: multiple decimal points in /u1/www/www.mysite.com/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT COUNT(DISTINCT(TO_CHAR(timestamp, 'YYYY-MM-DD'))) FROM adsense_clicks in /u1/www/www.mysite.com/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: multiple decimal points in /u1/www/www.mysite.com/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT TO_CHAR(timestamp, 'YYYY-MM-DD') AS day, COUNT(*) AS count FROM adsense_clicks GROUP BY day ORDER BY day DESC LIMIT 50 OFFSET 0 in /u1/www/www.mysite.com/includes/database.pgsql.inc on line 144.

Any thoughts?

Comments

kbahey’s picture

kbahey commented
Status: Active » Needs work

You are using PostgreSQL, and some queries in the module are MySQL specific.

Since I don't use PostgreSQL myself, the situation will remain as is until someone who uses PostgreSQL and is willing to step in and contribute a patch.

jcnventura’s picture

jcnventura
Primary language English
commented
Status: Needs work » Closed (fixed)

AdSense click tracking no longer works.

This is obsolete.