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
Errores después de actualizar la consola
Félix Pablo · 23 sept 2015, 15:21 · 11 mensajes · 54 visitas
- Inicio del debate
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
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
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?
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 !
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.
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.
Entra en tu cuenta para publicar.
