PDA

View Full Version : Error message


ksm451
16-06-2005, 18:55
Error in query [select u.userid,u.alias,u.name,u.surname,u.url from users u where u.alias='admin' and u.passwd='d41d8cd98f00b204e9800998ecf8427e'] [Table 'zabbix.users' doesn't exist]
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/html/include/db.inc.php on line 144
Error in query [select u.userid,u.alias,u.name,u.surname from users u where u.alias='guest'] [Table 'zabbix.users' doesn't exist]
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/zabbix/html/include/db.inc.php on line 144

HOW DO I FIXED THIS ERROR

welshpjw
16-06-2005, 20:14
Did you upgrade from a previous version of the Zabbix server?

welshpjw
16-06-2005, 20:28
Sorry, should have also said that if this is an upgrade, then you would need to look into the "upgrades/dbpatches/" dir to "upgrade" the database schema.

ksm451
17-06-2005, 08:57
this is an initial install in which the database was created with connection to mysql using root and a password to create the zabbix database per instaructions in the manual.Its not an upgrade from a previous installation.
thanks

ksm451

ksm451
17-06-2005, 09:05
Which patch do I use as there are so many directories in the upgrade.Am using zabbix-1.1alpha.10,and what are the commands for executing the patch.pls

ksm451