- 
    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.
