Ad Widget

Collapse

Sql errors with Zabbix 1.1 beta1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ruckus37
    Member
    • Oct 2004
    • 57

    #1

    Sql errors with Zabbix 1.1 beta1

    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
    Last edited by ruckus37; 25-09-2005, 21:30.
  • James Wells
    Senior Member
    • Jun 2005
    • 664

    #2
    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.
    Unofficial Zabbix Developer

    Comment

    • ruckus37
      Member
      • Oct 2004
      • 57

      #3
      Thanks working now, just not the image upload.

      Thanks for your help.

      Comment

      Working...