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
#4
I also get this error and it's messing with the console display. I upgraded the 7.0NG Windows version from 719 to 724 using the update option in the installer. The upgrade went through without errors but when viewing the console, the database error message precedes most of the screen graphics.

I don't have access to any separate install files. Any fix?
 Reply
#5
Hi all,

You need to insert the MRs from the folder /var/www/html/pandora_console/extras/mr/X.sql (Insert it in order).

cat X.sql | mysql -u root -p <pandora_db_name>

Then move these files (X.sql) to the folder /var/www/html/pandora_console/extras/mr/updated

Lastly ejecute this command to modify the footer of the console.

update tconfig set value=17 where token='MR';

Best regards,
vic.
 Reply
#6
Is there an equivalent set of commands for Windows setup?

thx Don
 Reply
#7
Tried this,
still 'all systems down'

Thx Bart
 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