pg_query(): Query failed: ERROR: function count(integer, integer) does not exist LINE 1: SELECT 'page views' as value, COUNT(DISTINCT access_sec, acc... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. in /var/www/includes/database.pgsql.inc on line 139.

I could be mistaken though.

Comments

threading_signals’s picture

threading_signals commented

I think it was because perhaps yui compressor wasn't setup properly. I'm trying the jsmin option to see if there are any further messages.

davidwhthomas’s picture

davidwhthomas commented

Same problem here, looks like a problem in the way count() is used

warning: pg_query() [function.pg-query]: Query failed: ERROR: function count(integer, integer) does not exist LINE 1: SELECT 'page views' as value, COUNT(DISTINCT access_sec, acc... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. in /.../includes/database.pgsql.inc on line 140.
user warning: query: SELECT 'page views' as value, COUNT(DISTINCT access_sec, access_msec) AS amount FROM bundlecache_file_statistics UNION SELECT 'hits', COUNT(*) FROM bundlecache_file_statistics UNION SELECT 'kind', COUNT(*) FROM (SELECT f.kind FROM bundlecache_file_statistics s JOIN bundlecache_file f ON s.fid = f.fid GROUP BY s.fid, f.kind) AS a GROUP BY kind UNION SELECT 'earliest', MIN(access_sec) FROM bundlecache_file_statistics; in /.../sites/all/modules/contrib/bundlecache/ui/bundlecache_ui.overview.inc on line 120.

particularly

COUNT(DISTINCT access_sec, access_msec)

DT