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

Problems with zabbix-2.0.8+PHP-5.5.0+mysql-5.6.13 - mysqli problems in db.inc.php

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Blocker Blocker
    • None
    • 2.0.8
    • Installation (I)
    • None
    • FreeBSD 9.1-RELEASE

      I have a Zabbix Server v1.8.5 server running very well in a FreeBSD 8.1-RELEASE with PHP 5.3.2 and mysql-server-5.1.48. Now I am trying to install a new server in parallel to migrate for the new release of the Zabbix, but I am having problems with the discontinuation of the mysql function to the new mysqli.
      I did the patch indicated in this link :https://support.zabbix.com/browse/ZBX-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel; but after that I had the following problems:

      • Error in query [SELECT DISTINCT t.triggerid,t.priority,h.name AS hostname,h.host,h.hostid FROM triggers t,functions f,items i,hosts h WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND h.hostid=i.hostid AND t.triggerid BETWEEN 000000000000000 AND 099999999999999] [Unknown column 'h.name' in 'field list']
      • mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given [include/db.inc.php:567]
      • mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given [include/db.inc.php:568]

      Someone could help me?

            Unassigned Unassigned
            huri.filho Huri de Sousa Barbosa Filho
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: