Pgsql problem

[PChott]

I get this error:

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at end of input at character 38 in /usr/share/zabbix/include/db.inc.php on line 67

Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /usr/share/zabbix/include/db.inc.php on line 127
Error getting row

And i Have problem to determinate what is the problem

[Alexei]

Version of ZABBIX? Where and when did you see this error? What screen?

[PChott]

Sorry my mistake, i forget this information.

Zabbix 1.1.4 install from debian unstable
Postgresql 8.1.5

I get this errot when i wand to add new host

Need any other information?

[PChott]

Still no idea

In version:
zabbix-server-pgsql 1.1.4-2

Almost same:
Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at end of input at character 44 in /usr/share/zabbix/include/db.inc.php on line 67

Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /usr/share/zabbix/include/db.inc.php on line 127
Error getting row

Sill no idea?

[GateKeeper]

Seems very similar to the issue discussed here: http://www.zabbix.com/forum/showthread.php?t=3993

Try to modify your DB-schema to assign OIDs to objects in it.