Hi I've just updated to Pandora FMS v7.0NG.732 - Build PC190227 - MR 24 via 'yum update' on CentOS 7.6 I am now receiving the following error at the top of each page SQL error: Table 'pandora.tnotification_source' doesn't exist ('SELECT * FROM `tnotification_source` WHERE `description` = 'System status' LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116 SQL error: Table 'pandora.tnotification_user' doesn't exist ('SELECT * FROM ( SELECT DISTINCT tm.*, utimestamp_read > 0 as "read" FROM tmensajes tm LEFT JOIN tnotification_user nu ON tm.id_mensaje=nu.id_mensaje AND nu.id_user="jt.admin" LEFT JOIN (tnotification_group ng INNER JOIN tusuario_perfil up ON ng.id_group=up.id_grupo AND up.id_grupo=ng.id_group ) ON tm.id_mensaje=ng.id_mensaje WHERE utimestamp_erased is null AND (nu.id_user="jt.admin" OR up.id_usuario="jt.admin" OR ng.id_group=0) ) t where t.read is null ORDER BY timestamp DESC LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116 The top menu bar (Search, Help, User Maintenance Logout) is non-functional On Discover->Task list page SQL error: Table 'pandora.tuser_task_scheduled' doesn't exist ('SELECT * FROM tuser_task_scheduled WHERE id_grupo IN (0,12,18,8,4,16,9,17,19,14,2,15,10,13,11)') in /var/www/html/pandora_console/include/db/mysql.php on line 116 I ran the Online Update and now have Pandora FMS v7.0NG.732 - Build 191231 - MR 24 However error still occurs. Also the online update process mentioned DB inconsistencies Happy to edit the relevant files to fix if someone can let me know what needs to be done Regards Jodi
MySQL error following update
jwthomson · 27 feb 2019, 23:30 · 19 mensajes · 65 visitas
- Inicio del debate
Also when entering an agent alias containing '-' e.g rtr-loc-a it reverts to 'rtrloca' after creation To resolve I update the agente table directly in MySQL
I have the same thing after a 'yum update' last night. 7.0NG.732(Build 190227) Two SQL errors across the top of all pages. Thanks. Regards, Jon.
[

](//pandorafms.com/community/media/forum/10841/27863=2719-Pandora-SQL-Error.png)
Hi I've just updated to Pandora FMS v7.0NG.732 - Build PC190227 - MR 24 via 'yum update' on CentOS 7.6 I am now receiving the following error at the top of each page SQL error: Table 'pandora.tnotification_source' doesn't exist ('SELECT * FROM `tnotification_source` WHERE `description` = 'System status' LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116 SQL error: Table 'pandora.tnotification_user' doesn't exist ('SELECT * FROM ( SELECT DISTINCT tm.*, utimestamp_read > 0 as "read" FROM tmensajes tm LEFT JOIN tnotification_user nu ON tm.id_mensaje=nu.id_mensaje AND nu.id_user="jt.admin" LEFT JOIN (tnotification_group ng INNER JOIN tusuario_perfil up ON ng.id_group=up.id_grupo AND up.id_grupo=ng.id_group ) ON tm.id_mensaje=ng.id_mensaje WHERE utimestamp_erased is null AND (nu.id_user="jt.admin" OR up.id_usuario="jt.admin" OR ng.id_group=0) ) t where t.read is null ORDER BY timestamp DESC LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116 The top menu bar (Search, Help, User Maintenance Logout) is non-functional On Discover->Task list page SQL error: Table 'pandora.tuser_task_scheduled' doesn't exist ('SELECT * FROM tuser_task_scheduled WHERE id_grupo IN (0,12,18,8,4,16,9,17,19,14,2,15,10,13,11)') in /var/www/html/pandora_console/include/db/mysql.php on line 116 I ran the Online Update and now have Pandora FMS v7.0NG.732 - Build 191231 - MR 24 However error still occurs. Also the online update process mentioned DB inconsistencies Happy to edit the relevant files to fix if someone can let me know what needs to be done Regards Jodi
Greetings, jwthomson You are running your Pandora FMS installation using MR 24 and the build 732 requires MR 25. To update the MR version you'll need to access the database and execute the following commands: - use pandora; - source /var/www/html/pandora_console/extras/mr/XX.sql where XX is the number of the MR to be uploaded, from 1 to the last one, in order. Once you have updated the MR without errors, you'll need to access the database again and execute these commands: - use pandora; - update tconfig set value='XX' where token='MR'; Notice that in the last query you need to set 'XX' as 25, which is the last MR available. Regards, Eduardo.
I have the same thing after a 'yum update' last night. 7.0NG.732(Build 190227) Two SQL errors across the top of all pages. Thanks. Regards, Jon.
Hello, JonRussell Please read the previous post, as you seem to have the same problem. Regards, Eduardo.
OK. Thanks. That fixed it. Can't the MR / DB Schema updates be part of the yum package script ? Or when the server starts up, it runs any outstanding MR scripts for you, or warns you there are outstanding MR scripts to run ? Thanks again ! Regards, Jon.
OK. Thanks. That fixed it. Can't the MR / DB Schema updates be part of the yum package script ? Or when the server starts up, it runs any outstanding MR scripts for you, or warns you there are outstanding MR scripts to run ? Thanks again ! Regards, Jon.
Hello, JonRussell We are really sorry but the feature you request is neither available nor planned for the Community version. Kind regards, Eduardo.
Hello guys, I've the same problem here. Pandora FMS v7.0NG.732 - Build 191231 - MR 25. On menu 'Discovery' -> 'Task lists' I have this error: SQL error: Table 'pandora.tuser_task_scheduled' doesn't exist ('SELECT * FROM tuser_task_scheduled WHERE id_grupo IN (0,12,14,8,4,17,9,2,15,16,10,13,11)') in /var/www/html/pandora_console/include/db/mysql.php on line 116 I have applied all fixes available in the 'extras/mr/' folder and update the token to the position 25. However, I discovery that the table 'tuser_tasks_scheduled' not exists in my setup. How I can create this missing table? I don't have this table in 'pandoradb.sql'. Kind regards, Luciano.
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
I also have no 25.sql after yum update
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
I also have no 25.sql after yum update
I ran a DB Schema check and then did a side by side comparison between the production and test dbs The test db contained the following new tables
- tevent_extended
- tnotification_group
- tnotification_source
- tnotification_source_group
- tnotification_source_group_user
- tnotification_source_user
- tnotification_user
The production db contained two tables not in the test db
- tfiles_repo
- tfiles_repo_group
I dumped the schema for the test db and grabbed out the create table for the new tables and added them to the production db. The SQL errors have now disappeared which freed screen real estate and got the menu working *CAVEAT: Try this procedure at own risk* I did not drop the two tables found only in production db However - issue with stripping '-' out of module names is still occurring A more concrete solution would be appreciated
Hello guys, I've the same problem here. Pandora FMS v7.0NG.732 - Build 191231 - MR 25. On menu 'Discovery' -> 'Task lists' I have this error: SQL error: Table 'pandora.tuser_task_scheduled' doesn't exist ('SELECT * FROM tuser_task_scheduled WHERE id_grupo IN (0,12,14,8,4,17,9,2,15,16,10,13,11)') in /var/www/html/pandora_console/include/db/mysql.php on line 116 I have applied all fixes available in the 'extras/mr/' folder and update the token to the position 25. However, I discovery that the table 'tuser_tasks_scheduled' not exists in my setup. How I can create this missing table? I don't have this table in 'pandoradb.sql'. Kind regards, Luciano.
Greetings, Iogulart We're working to fix this issue with the Community version, it will be solved in the next update. Sorry for the inconvenience. Regards, Eduardo.
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
Greetings, hbh154 Sometimes the update generates a new folder in /var/www/html/pandora_console/extras/mr named "update". If MR25 is not in MR it should be there. However, please try to search the file executing: find /* -name *.sql Run the command from the root folder. Let's see if that way you can find 25.sql. Regards, Eduardo.
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
I also have no 25.sql after yum update
Good morning, jwthomson Please check the answer above to see if it helps to solve that problem. Regards, Eduardo.
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
Greetings, hbh154 Sometimes the update generates a new folder in /var/www/html/pandora_console/extras/mr named "update". If MR25 is not in MR it should be there. However, please try to search the file executing: find /* -name *.sql Run the command from the root folder. Let's see if that way you can find 25.sql. Regards, Eduardo.
What this uncovered is a new folder created at: /var/www/html/pandora_console/pandora_console/extras/mr Unfortunately this folder only contains the files 1.sql through 24.sql, no 25 to be found. 2 - Build 191231 - MR 24
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
I also have no 25.sql after yum update
Good morning, jwthomson Please check the answer above to see if it helps to solve that problem. Regards, Eduardo.
25.sql is not on the system
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
Greetings, hbh154 Sometimes the update generates a new folder in /var/www/html/pandora_console/extras/mr named "update". If MR25 is not in MR it should be there. However, please try to search the file executing: find /* -name *.sql Run the command from the root folder. Let's see if that way you can find 25.sql. Regards, Eduardo.
What this uncovered is a new folder created at: /var/www/html/pandora_console/pandora_console/extras/mr Unfortunately this folder only contains the files 1.sql through 24.sql, no 25 to be found. 2 - Build 191231 - MR 24
Greetings, hbh154 & jwthomson If you can't find 25.sql, please reinstall version 732 rpm package. If anything went wrong updating that should restore everything. Regards, Eduardo.
After updating the CentOS packages using yum, I have no new files in the MR folder. ls /var/www/html/pandora_console/extras/mr shows only my updated folder, containing the sql files 1-24.
Greetings, hbh154 Sometimes the update generates a new folder in /var/www/html/pandora_console/extras/mr named "update". If MR25 is not in MR it should be there. However, please try to search the file executing: find /* -name *.sql Run the command from the root folder. Let's see if that way you can find 25.sql. Regards, Eduardo.
What this uncovered is a new folder created at: /var/www/html/pandora_console/pandora_console/extras/mr Unfortunately this folder only contains the files 1.sql through 24.sql, no 25 to be found. 2 - Build 191231 - MR 24
Greetings, hbh154 & jwthomson If you can't find 25.sql, please reinstall version 732 rpm package. If anything went wrong updating that should restore everything. Regards, Eduardo.
Reinstalling 732 from rpm did not solve issue - however it did provide 25.sql which fixed things when applied Regards
I was able to update a test install at another site and use the 25.sql to resolve my issue as well.
Entra en tu cuenta para publicar.

