I've found an issue located on counter.module line 174:
INSERT IGNORE is not permitted in postgresql.

You can see here how to fix this bug:
http://robbat2.livejournal.com/214267.html

Provisionally on my code I've added the pqsql case but I expect that this is not the correct way to fix it:
case 'pgsql':
$sql = " INSERT INTO {counter} (counter_ip,counter_date,counter_page) ".
" VALUES ('%s','%s','%s') ";
break;

Hope you can fix it soon.

Comments

drupalnesia’s picture

Status: Active » Closed (fixed)

I will re-check if PostgreSQL doesn't support IGNORE clause, thanks.

drupalnesia’s picture

Status: Closed (fixed) » Needs work
drupalnesia’s picture

Status: Needs work » Fixed

6.x-2.8:
Bug fix: PostgreSQL: emulate INSERT IGNORE
Bug fix: Skip Admin now working

Please help to test because I have no PostgreSQL yet.

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL

Automatically closed -- issue fixed for 2 weeks with no activity.