Details
-
Problem report
-
Status: Closed
-
Blocker
-
Resolution: Cannot Reproduce
-
None
-
None
-
None
-
Reproduced in Zabbix 5.0 and PostgreSQL 13
-
Sprint 94 (Nov 2022), Sprint 95 (Dec 2022), Sprint 96 (Jan 2023), Sprint 97 (Feb 2023), Sprint 98 (Mar 2023)
Description
Hi Team,
After changing the DB from 3 node to single node, we are not able to load the GUI in the MORO environment. Its throwing the Database error. Kindly please jump into the call and help us to resolve the critical issue.
Error:-
bigint error when starting gui
zabbix=# SELECT DISTINCT u.userid,u.alias FROM users u,users_groups ug WHERE ug.usrgrpid='' AND u.userid=ug.userid;
ERROR: invalid input syntax for type bigint: ""
LINE 1: ...as FROM users u,users_groups ug WHERE ug.usrgrpid='' AND u.u...