missed default user 'guest'
Hello,
I just installed version 1.3beta onto 1.1.4.
The initial setup is ok but then I get "missed default user 'guest'".
I checked the tables with phpmyadmin and the user exists.
This is the errors I see on the screens:
Error in query [select u.* from users u where u.alias='guest' and (u.userid div 100000000000000)=0] [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 'div 100000000000000)=0' at line 1]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Do you see any incongruence?
Thanks!!
I just installed version 1.3beta onto 1.1.4.
The initial setup is ok but then I get "missed default user 'guest'".
I checked the tables with phpmyadmin and the user exists.
This is the errors I see on the screens:
Error in query [select u.* from users u where u.alias='guest' and (u.userid div 100000000000000)=0] [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 'div 100000000000000)=0' at line 1]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Error in query [select n.*,min(r.permission) as permission 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=0 where n.nodeid in (0) group by n.nodeid] [Unknown column 'r.type' in 'on clause']
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/zabbix/include/db.inc.php:368]
Do you see any incongruence?
Thanks!!
Comment