Pandora FMS Community

Console SQL Error

bjensen34 · 18 may 2016, 2:44 · 7 mensajes · 59 visitas

  1. Inicio del debate

    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

  2. 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.

  3. 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

  4. attached screenshot of the error and main console screen. Regards - Brad

    [

    ](//pandorafms.com/community/media/forum/0/19581=977-Screenshot.png)

  5. 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.

  6. 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

Entra en tu cuenta para publicar.