-
SQL Errors
Brand new install of pandora. Have a few remote agents out there reporting from pandora version 4.x. But basically a fresh install. Seem like most pages I get some form of SQL error or another. He is the output from brand new agent deployed on my computers and looking at the gui at
http://192.168.170.16/pandora_console/index.php?sec=estado&sec2=operation/agentes/ver_agente&id_agente=16Error:
SQL error: Table ‘pandora.tmodule_relationship’ doesn’t exist (‘SELECT id FROM tmodule_relationship WHERE module_a = 134 OR module_b = 134 LIMIT 1’) in /var/www/html/pandora_console/include/db/mysql.php on line 74
SQL error: Table ‘pandora.tmodule_relationship’ doesn’t exist (‘SELECT id FROM tmodule_relationship WHERE module_a = 130 OR module_b = 130 LIMIT 1’) in /var/www/html/pandora_console/include/db/mysql.php on line 74
SQL error: Table ‘pandora.tmodule_relationship’ doesn’t exist (‘SELECT id FROM tmodule_relationship WHERE module_a = 133 OR module_b = 133 LIMIT 1’) in /var/www/html/pandora_console/include/db/mysql.php on line 74
SQL error: Table ‘pandora.tmodule_relationship’ doesn’t exist (‘SELECT id FROM tmodule_relationship WHERE module_a = 132 OR module_b = 132 LIMIT 1’) in /var/www/html/pandora_console/include/db/mysql.php on line 74
SQL error: Table ‘pandora.tmodule_relationship’ doesn’t exist (‘SELECT id FROM tmodule_relationship WHERE module_a = 131 OR module_b = 131 LIMIT 1’) in /var/www/html/pandora_console/include/db/mysql.php on line 74I have done 2 fresh installs of pandorafms today with the same results. Any help would be great.
PS this is the Appliance CD based on CentOS 6.4
-
3 Replies
-
-
Hello
This problem is generated because the pandora_console has been update with sourcecode parts from the version 5.1 of pandora and the problem of the database occurs, to solve this problem you must execute the migration script (migrate.sql) for more information on how to do it visit the following webpage: http://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Anexo_Upgrade#Migrating_to_another_system
Regards
Ivo -
