Pandora FMS Community

Upgrade from 707 to 7.0NG.711 Build 170817 - SQL error: Table pandora.tpolicy_group

LogarithmX · 20 ago 2017, 7:16 · 4 mensajes · 45 visitas

  1. Inicio del debate

    Hi,  1. Did a Manual Tool Database cleanup: /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf 2.  Stopped services in order and upgraded from 707 to 711 via RPM -U as suggested in:     https://wiki.pandorafms.com/index.php?title=Pandora:Documentation\_en:Anexo\_Upgrade 3. Everything works well, however whenever I try to update / create an agent I get this error: SQL error: Table 'pandora.tpolicy_groups' doesn't exist ('SELECT id_policy FROM tpolicy_groups WHERE id_group = 9') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Table 'pandora.tpolicy_groups' doesn't exist ('SELECT id_policy FROM tpolicy_groups WHERE id_group = 9') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SUCCESS Successfully updated Any suggestions are Welcome! Thanks guys.

  2. Not sure why but this is not visible on the main page. Not sure if someone can see it. Please reply if you can see this post. Thanks!

  3. Hi LogarithmX, For some reason you do not have the "tpolicy_groups" table in the database. Connect to the Database and insert this file:

    source /var/www/html/pandora_console/pandoradb.sql
    

    This script should create the missing table. Best regards, vic.

  4. Ok. Thank you sir. Will backup the database tomorrow and will attempt to recreate the missing database. I hope my current database won't get erased in the process, not too familiar with databases hehe. Thanks.

Entra en tu cuenta para publicar.