PDA

View Full Version : Sql errors with Zabbix 1.1 beta1


ruckus37
25-09-2005, 21:28
Just having a field day with Zabbix 1.1 beta1, anything I try to do is giving me a sql error, example:

Changing an item:

First line:
Error in query [select i.description, i.key_, h.host, h.port, i.delay, i.history, i.status, i.type,

4th line:
Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /var/www/html/zabbix/include/db.inc.php on line 123

All current items are receiving data and working fine, just when I try to add something new or change anything, I upgraded to beta1 from alpha12 but did not do anything with the database, should I have, I have a lot of hosts set up so did not want to flush the database first. I have not tried going back to the previous version as I do not have access to the server for a week; could this be a bug or just something to do with the database?

Anyway thanks for the superb monitoring tool can’t wait for beta2.

Btw: Does anyone know when we will be able to upload images through the GUI?

Ruckus37

James Wells
26-09-2005, 00:59
Greetings,

Yes there were database changes in 1.1beta1. You don't need to flush the DB to do the upgrade, but you do need to load the DB modifications, which are in zabbix/updates/dbupdates/1.1alpha12_to_1.1beta1/<DB Type>/patch.sq. Without loading these changes, you can expect quite a few DB errors.

ruckus37
26-09-2005, 16:48
Thanks working now, just not the image upload.

Thanks for your help.