Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Upgrade from 707 to 7.0NG.711 Build 170817 - SQL error: Table pandora.tpolicy_group
#1
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?ti...xo_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

[Image: suc.png]
SUCCESS
[Image: blade.png]
Successfully updated





Any suggestions are Welcome! Thanks guys.
 Reply
#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!
 Reply
#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:
Code:
source /var/www/html/pandora_console/pandoradb.sql

This script should create the missing table.

Best regards,

vic.
 Reply
#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.
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes