Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-4470

Can not open trunk frontend after converting trunk Mysql Zabbix DB to the DM setup

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.9 (beta)
    • Fix Version/s: 1.9.9 (beta)
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      v1.9.9 (rev #24084)

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            igor Igor Danoshaites (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: