Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

  • Error applying MR 59.sql

    Posted by JonRussell on diciembre 6, 2022 at 13:07

    Hi. I upgraded to 767 today. When I try and apply the MR I get an error:

    [root@pandora mr]# cat /var/www/html/pandora_console/extras/mr/59.sql | mysql -vvv -u pandora pandora
    --------------
    START TRANSACTION
    --------------
    Query OK, 0 rows affected (0.00 sec)
    --------------
    ALTER TABLE tevent_filter MODIFY COLUMN server_id TEXT
    --------------
    ERROR 1054 (42S22) at line 3: Unknown column 'server_id' in 'tevent_filter'
    Bye

    Any ideas?

    Thanks.

    Jon.

    JonRussell replied 2 years ago 2 Members · 2 Replies
  • 2 Replies
  • vic

    Administrator
    diciembre 7, 2022 at 09:47
    1542 Karma points
    Community awards: bulb Bright ideas
    Community rank: tentacle_master_icon Tentacle Master
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hi JonRussell,

    You seem to be missing MR 46.sql.

    Check that you have correctly updated all the RM in the environment.

    Best regards,

    Víctor.

    • JonRussell

      Member
      diciembre 7, 2022 at 14:33
      273 Karma points
      Community rank: tentacle-noob-1 Tentacle noob
      Like it
      Up
      0
      Down
      Drop it
      ::

      Perfect. That fixed it. Thanks.

      I dont know why #46 was missing.

      Jon.