Community support

Error applying MR 59.sql

Posted by JonRussell on December 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
December 7, 2022 at 09:47

1542 Karma points

Community awards: Bright ideas

Community rank: 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
  December 7, 2022 at 14:33
  
  273 Karma points
  
  Community rank: Tentacle noob
  
  Like it
  Up
  0
  Down
  Drop it
  ::
  Perfect. That fixed it. Thanks.
  
  I dont know why #46 was missing.
  
  Jon.

Welcome to Pandora FMS Community!

Error applying MR 59.sql

vic

JonRussell