[ZBX-4470] Can not open trunk frontend after converting trunk Mysql Zabbix DB to the DM setup Created: 2011 Dec 20  Updated: 2017 May 30  Resolved: 2011 Dec 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dm
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

v1.9.9 (rev #24084)

Attachments: PNG File trunk_nodes_error.png    

 Description   

After converting trunk Mysql (v1.9.9, rev #24084) Zabbix DB to the DM setup (with "./zabbix_server -n 1" command) can not open frontend anymore, after opening index.php on the screen appears the following error:

Undefined index: type [include/nodes.inc.php:59]
Undefined index: userid [include/nodes.inc.php:67]
Error in query [SELECT DISTINCT n.nodeid,n.name,n.masterid FROM nodes n,groups hg,rights r,users_groups g WHERE r.id=hg.groupid AND r.groupid=g.usrgrpid AND g.userid= AND n.nodeid=(hg.groupid div 100000000000000)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND n.nodeid=(hg.groupid div 100000000000000)' at line 1]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Error in query [SELECT DISTINCT n.nodeid,n.name,n.masterid FROM nodes n,groups hg,rights r,users_groups g WHERE r.id=hg.groupid AND r.groupid=g.usrgrpid AND g.userid= AND n.nodeid=(hg.groupid div 100000000000000)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND n.nodeid=(hg.groupid div 100000000000000)' at line 1]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Undefined index: file [include/page_footer.php:42]
Undefined index: file [include/page_footer.php:43]
Error in query [SELECT * FROM profiles WHERE userid= AND profileid BETWEEN 100000000000000 AND 199999999999999 ORDER BY userid ASC, profileid ASC] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND profileid BETWEEN 100000000000000 AND 199999999999999 ORDER BY userid ASC, p' at line 1]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]

Screenshot is also in the Attachment.

Before converting DB to DM setup Zabbix frontend was working fine with this DB.

 Comments   
Comment by Alexander Vladishev [ 2011 Dec 20 ]

Confirmed with PostgreSQL r24096.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 22 ]

Broken by ZBX-3104 r23677.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

RESOLVED.

Comment by Alexander Vladishev [ 2011 Dec 23 ]

Successfully tested! Please review my changes in r24224.

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

Merged to trunk r24231.

CLOSED.

Generated at Wed Jul 16 11:00:48 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.