-
Incident report
-
Resolution: Won't fix
-
Major
-
1.8.3
-
None
-
Centos 5.5, PHP 5.3.3, Postgres 8.4.4.
After upgrading to version 1.8.3 can not create new groups.
In the browser displays the following error:
- include(schema.inc.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory[/etc/zabbix/db.inc.php:944]
- include() [<a href='function.include'>function.include</a>]: Failed opening 'schema.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')[/etc/zabbix/db.inc.php:944]
- pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: function max() does not exist at character 8 HINT: No function matches the given name and argument types. You might need to add explicit type casts.[/etc/zabbix/db.inc.php:408]
- Error in query [SELECT max() AS id FROM groups WHERE >=0 AND <=99999999999] [ERROR: function max() does not exist at character 8 HINT: No function matches the given name and argument types. You might need to add explicit type casts.]
- pg_fetch_assoc() expects parameter 1 to be resource, boolean given[/etc/zabbix/db.inc.php:550]
- pg_free_result() expects parameter 1 to be resource, boolean given[/etc/zabbix/db.inc.php:552]
- pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/etc/zabbix/db.inc.php:491]
- Error in query [INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES (0,'groups','',1)] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
- DBEXECUTE_ERROR
And in the log database:
ERROR: function max() does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT max() AS id FROM groups WHERE >=0 AND <=99999999999
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: INSERT INTO ids (nodeid,table_name,field_name,nextid) VALUES (0,'groups','',1)
In version 1.8.2 it works fine.