Hello everybody,
help me plz, I have an error on http://localhost/zabbix , I have those warnings:
* Error in query [SELECT * FROM nodes WHERE nodetype=1 order by nodeid] [Table 'zabbix.nodes' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND (u.userid div 100000000000000) in (0) ] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [UPDATE sessions SET status=1 WHERE sessionid=''] [Table 'zabbix.sessions' doesn't exist]
* Error in query [SELECT count(u.userid) as user_cnt FROM users u] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Use of undefined constant S_INSTALLATION - assumed 'S_INSTALLATION'[/usr/share/zabbix/include/profiles.inc.php:341]
* Unable to select configuration
* Error in query [SELECT * FROM nodes WHERE nodeid=0] [Table 'zabbix.nodes' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Unable to select configuration
Can you tell me plz how to solve this problem,Thanks in advance.
help me plz, I have an error on http://localhost/zabbix , I have those warnings:
* Error in query [SELECT * FROM nodes WHERE nodetype=1 order by nodeid] [Table 'zabbix.nodes' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND (u.userid div 100000000000000) in (0) ] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [UPDATE sessions SET status=1 WHERE sessionid=''] [Table 'zabbix.sessions' doesn't exist]
* Error in query [SELECT count(u.userid) as user_cnt FROM users u] [Table 'zabbix.users' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Use of undefined constant S_INSTALLATION - assumed 'S_INSTALLATION'[/usr/share/zabbix/include/profiles.inc.php:341]
* Unable to select configuration
* Error in query [SELECT * FROM nodes WHERE nodeid=0] [Table 'zabbix.nodes' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=0 LEFT JOIN nodes n ON (h.hostid div 100000000000000)=n.nodeid WHERE (h.hostid div 100000000000000) in (0) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid ] [Table 'zabbix.hosts' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Error in query [SELECT * FROM config WHERE (configid div 100000000000000) in (0) ] [Table 'zabbix.config' doesn't exist]
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:519]
* Unable to select configuration
Can you tell me plz how to solve this problem,Thanks in advance.
Comment