zabbix configuration problem

[mahadjir]

please hemp me , i have a probleme with configuration zabbix , this error message :



* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:412]




thank you

[zabbix_zen]

You should give more data about your current Setup for us to help you.
OS, Zabbix version, etc...

My /include/db.inc.php doesn't have a mysql_fetch_array function.
In fact there's only sqlite3 has a *_fetch_array(), both Mysql, Postgres and Oracle checks use simpler queries.