Welcome to Pandora FMS Community!

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

Welcome to Pandora FMS Community Forums Soporte de la comunidad Errores después de actualizar la consola

  • Errores después de actualizar la consola

    Posted by Félix Pablo on September 23, 2015 at 15:21

    Buenos días,

    hoy estoy de suerte. Al ir a crear un módulo wmi, tengo los siguiente errores:

    SQL error: Unknown column ‘b.id_policy_module’ in ‘where clause’ (‘SELECT a.id_tag, name FROM ttag a, ttag_module b WHERE a.id_tag = b.id_tag AND b.id_agente_modulo = 0 AND b.id_policy_module = 0 ORDER BY name’) in /var/www/html/pandora_console/include/db/mysql.php on line 74
    SQL error: Unknown column ‘b.id_policy_module’ in ‘where clause’ (‘SELECT a.id_tag, name FROM ttag a, ttag_module b WHERE a.id_tag = b.id_tag AND b.id_agente_modulo = 0 AND b.id_policy_module != 0 ORDER BY name’) in /var/www/html/pandora_console/include/db/mysql.php on line 74

    Muchas gracias.

    Saludos

    emilio replied 9 years, 4 months ago 4 Members · 10 Replies
  • 10 Replies
  • ana

    Member
    September 28, 2015 at 11:24
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Buenos días baxajaun,

    Para solucionar este problema tienes que añadir a mano esta query en la base de datos de pandora:

    ALTER TABLE `tagente_estado` ADD COLUMN `last_error` tinyint(4) NOT NULL DEFAULT 0;

    Un saludo,

    Ana

  • Félix Pablo

    Member
    September 28, 2015 at 12:03
    53 Karma points
    Community awards: bulb Bright ideas
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Buenos día Ana,

    este es el resultado:

    An error has occured when querying the database.
    Duplicate column name ‘last_error’

    Vamos que ya existe.

    Saludos

  • RoBo

    Member
    October 5, 2015 at 00:22
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Sorry for not being able to answer in Spanish; I have exactly the same error showing on the screen when I browse the ‘configurar_agente’ page. Also the column seem to exist. I hope somebody can provide a way forward?

  • emilio

    Member
    October 5, 2015 at 11:40
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hola baxajaun,

    ¿Podrías adjuntar en el siguiente post el contenido de tu fichero “/var/www/html/pandora_console/include/db/mysql.php”? ¿Así como el log del servidor y su fichero de configuración?

    RoBo, I’m asking baxajaun to attach his server.conf, server.log and mysql.php files so I can take a closer look to the problem, you can send yours too, maybe the three of us can figure something out 😉

    Saludos,
    Emilio.

  • Félix Pablo

    Member
    October 5, 2015 at 12:53
    53 Karma points
    Community awards: bulb Bright ideas
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hola Emilio,

    aquí tienes lo que me has pedido.

    Muchas gracias.

    Saludos

  • emilio

    Member
    October 5, 2015 at 14:00
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hello RoBo,

    At the other post “SQL error: Table ‘pandora.tuser_double_auth’ doesn’t exist” in which baxajaun was asking about something like this, we managed to solve the problem by uninstalling the console and installing it again, because there was a bug with the update through Manage Update… I’m assuming that you are into this problem because of the bug of updating to version 6.0, if you are having this problem without the update bug, let me know 😉

    Regards,
    Emilio.

  • RoBo

    Member
    October 8, 2015 at 01:27
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hello Emilio,

    Although you have stated that I should let hear from me if I still have problems, I just wanted to let everybody know that indeed I had “Pandora FMS v6.0dev – Build PC151231” and after “yum reinstall pandorafms_console” having back “Pandora FMS v5.1SP3 – Build PC150624” the troubles were solved.. few…

    Thanks 4 support !

  • emilio

    Member
    October 8, 2015 at 18:53
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hello RoBo,

    I’m glad that you solved your problem!
    But I just told you at my previous post that you had to uninstall the Pandora Console.

    Regards,
    Emilio.

  • RoBo

    Member
    October 9, 2015 at 00:01
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    My apologies Emilio, I was trying to be a little bit funny, which seem to be clouding the things I wanted to express. Thanks to your post I was able to solve my problem, so you hit the nail on it’s head. For that my utmost gratitude! Because I was doing some wrong things while solving it, I wanted to provide a little bit of extra information in case someone else would run into this issue.
    So I solved it, based on your information. Probably had to struggle quite some extra time without this ==> Thanks!

  • emilio

    Member
    October 9, 2015 at 12:11
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hi RoBo,

    Sorry for the misunderstanding, but English is not my mother tongue (as you can see by my writing skills LOL).
    I’m glad that you solved your problem based on my information, let’s hope we can work something out at the other topic, with the Visual Console 🙂

    Regards,
    Emilio.