I just installed Pandora on Centos 6.7 version 6 (latest) of Pandora and ran the suggested update through the console. After updating I am getting the following showing on the top left and top right of the console screen: SQL error: Unknown column 'server_keepalive' in 'where clause' ('SELECT COUNT(id_server) FROM tserver WHERE status = 1 AND keepalive > NOW() - INTERVAL server_keepalive*2 SECOND') in /var/www/html/pandora_console/include/db/mysql.php on line 76 In looking at the error and server logs I am seeing no errors or issues. Anyone else have a similar issue? Any assistance is greatly appreciated. Thank you - Brad
Console SQL Error
bjensen34 · 18 may 2016, 2:44 · 7 mensajes · 59 visitas
- Inicio del debate
Hi Brad, Which method did you use to install Pandora? Is it the prepared ISO or a custom Centos? Also, what MySQL version are you running? Kind regards, Kevin.
Install was RPMs on CentOS 6.7. MySQL Version is mysql Ver 14.14 Distrib 5.5.49, for Linux (x86_64) using readline 5.1. Installed all dependencies and had no errors during the install of the RPMs or the install of Pandora through the web based install portion of the console. Update manager shows version of Pandora as "The last version of package installed is: 160516" If you need further information please let me know. Thank you - Brad
attached screenshot of the error and main console screen. Regards - Brad
[

](//pandorafms.com/community/media/forum/0/19581=977-Screenshot.png)
Hi again Brad, In that case, most likely you have been affected by this issue. No problem though, just replace the console with the SourceForge version (as stated in that post). Sorry for the inconveniences. Kind regards, Kevin.
I have same problem, and solution http://forums.pandorafms.com/index.php/topic,9678.0.html doesn't exist. Please help. SQL error: Unknown column 'server_keepalive' in 'where clause' ('SELECT COUNT(id_server) FROM tserver WHERE status = 1 AND keepalive > NOW() - INTERVAL server_keepalive*2 SECOND') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 435 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 638 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 376 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 492 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 484 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 400 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 643 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 531 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 420 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93 SQL error: Unknown column 'alias' in 'field list' ('SELECT alias FROM tagente WHERE id_agente = 596 LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 93
Solution: http://wiki.pandorafms.com/index.php?title=Pandora:Documentation\_en:Anexo\_Upgrade
Hello Gremlin_groj, It looks like you've upgraded your console (and maybe server) without also applying the database upgrade. Take a look at this guide to complete all the process properly: http://wiki.pandorafms.com/index.php?title=Pandora:Pandora\_Upgrade\_6.0\_to\_7.0 Kind regards, Antonio.
Entra en tu cuenta para publicar.

