-
Incident report
-
Resolution: Fixed
-
Blocker
-
1.9.9 (beta)
-
v1.9.9 (rev #24084)
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.