Posted by janeks on June 17, 2009 at 2:26pm
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
Comments
post an issue against the project page
hello.
I won't be surprised if you don't get valid answers here. you would have better luck posting this as an issue against the counter's project.
Mohammed al-shar'
The Explorer
Counter module now supports MySQL, PostgreSQL, MS SQL & Oracle
Above error caused by PostgreSQL, but now Counter module supports databases other than MySQL.
Counter module since 6.x-2.0 version supports: MySQL, PostgreSQL, MS SQL and Oracle.
As mohammed76 said then please try at least 6.x-2.0 version then post any issues to Counter module project's page if you need help.