Counter module problems with PostgreSQL database a.o.
janeks - June 18, 2009 - 12:35
| Project: | Counter |
| Version: | 6.x-1.8 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
I have unable to get to work counter module on server where I have PostgreSQL (I have PostgreSQL 8.2.6 and PHP 5.2.6).
When I am enabling the module than getting error message:
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "IGNORE" LINE 1: INSERT IGNORE INTO counter (counter_ip, counter_date, cou... ^ in /htdocs/includes/database.pgsql.inc on line 139.
user warning: query: INSERT IGNORE INTO counter (counter_ip, counter_date, counter_page) VALUES ('217.199.xxx.xxx', '2009-06-17', 'admin,build,modules') in /htdocs/sites/all/modules/counter/counter.module on line 121. On other system with MySql counter is working o'k - I can get counter block, but report (.../counter/report) gives following error message:
user warning: Unknown table 'n' in where clause query: SELECT COUNT(*) FROM counter WHERE (n.language ='lv' OR n.language ='' OR n.language IS NULL) in /var/www/html/sites/all/modules/counter/counter.report.inc on line 18.What could be done to fix this?
brgds
Janeks
#1
This bug has been fixed on Counter 6.x-1.9