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:21Buenos 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 74Muchas gracias.
Saludos
emilio replied 9 years, 4 months ago 4 Members · 10 Replies -
10 Replies
-
-
-
-
::
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. -
::
Hola Emilio,
aquí tienes lo que me has pedido.
Muchas gracias.
Saludos
-
::
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. -
::
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 !
-
-
::
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! -
::
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.