Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
database broken after recent update
#1
Hi All, I'm in a pickle now after the recent update. I get this error:

SQL error: Table 'pandora.tagent_secondary_group' doesn't exist ('SELECT DISTINCT count(DISTINCT id_agente) as total_agents FROM tagente LEFT JOIN tagent_secondary_group ON tagent_secondary_group.id_agent=tagente.id_agente WHERE tagent_secondary_group.id_group IN ("12", "8", "4", "9", "2", "10", "13", "11") OR `id_grupo` IN ("12", "8", "4", "9", "2", "10", "13", "11") AND 1 = 1 AND ( 1 = 1) AND disabled = 0 ') in /var/www/html/pandora_console/include/db/mysql.php on line 93.
The latest version of package installed is:

180430


If you can help I'd be very thankful!
 Reply
#2
I have the same issue. What Minor Release are you on? Mine is on MR 2. I have tried manually applying the updates and the file just have errors.
 Reply
#3
Found that the 14.sql file is the one that creates the tagent_secondary_group table. Even though the files have errors when I apply them I did them all anyways and now my console works properly.
 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