-
Incident report
-
Resolution: Won't fix
-
Blocker
-
None
-
2.0.8
-
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?