Hi, I'm running pandoraFMS on ubuntu and I recently updated pandoraFMS from 7.0.740NG to 7.0.749NG by using the deb packages. I also applied all "MR" sql scripts in the database. All seems to be working but I have a sql error on the dashboard when I'm connected. SQL error: Unknown column 'td.id_group' in 'field list' ('SELECT td.id, td.name, td.id_user, td.id_group, td.active, count(twd.id) as cells, td.cells_slideshow FROM tdashboard td LEFT JOIN twidget_dashboard twd ON td.id = twd.id_dashboard WHERE 1=1 AND td.active = 1 GROUP BY td.id ORDER BY name') in/var/www/pandora_console/include/db/mysql.php on line 114 I probably have an issue in the database. Could you help me to fix it ? Thanks for your help
Sql error after an update of pandoraFMS
gohone35 · 16 sept 2020, 23:14 · 8 mensajes · 79 visitas
- Inicio del debate
Hi guys, hello girls! With all due respect, please check out this: http://pandorafms.org/forum/thread-15210.html It maybe is useful for you! Read there my proposal, have a nice day! 8-)
Hi guys, hello girls! With all due respect, please check out this: http://pandorafms.org/forum/thread-15210.html It maybe is useful for you! Read there my proposal, have a nice day! 8-)
Thanks for your help. I took a look on your link but I don't know what to do except applying the MR sql scripts. The thing is I already did that. The upgrade should be basically minor because pandoraFMS stays on the same branch (from 7.0NG.740 to 7.0NG.749) I checked in the tables referenced in the sql error and I have that mysql> show columns from tdashboard; +-----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------+----------------+ | id | int(20) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(60) | NO | | | | | id_user | varchar(60) | NO | | | | | active | tinyint(1) | NO | | 0 | | | cells_slideshow | tinyint(1) | NO | | 0 | | +-----------------+------------------+------+-----+---------+----------------+ mysql> show columns from twidget_dashboard; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | id | int(20) unsigned | NO | PRI | NULL | auto_increment | | options | longtext | NO | | NULL | | | container | varchar(30) | NO | | | | | order | int(3) | NO | | 0 | | | id_dashboard | int(20) unsigned | NO | MUL | 0 | | | id_widget | int(20) unsigned | NO | MUL | 0 | | | position | text | NO | | NULL | | +--------------+------------------+------+-----+---------+----------------+ I guess I need to put a sql command to add the missing "id_group" column but I don't have the details. Maybe something like ALTER TABLE tdashboard ADD COLUMN 'id_group' .... Unfortunately for me, I'm a beginner with sql. If someone has an idea... Thanks in advance
Finally, I fixed this particular issue by myself. I found the sql script used to initialize the database when you install pandorafms V7 at the first time.(for me: /var/www/pandora_console/pandoradb.sql) I saw the details about the creation of "tdashboard" table and I used this information to add two missing columns in the table. ALTER TABLE tdashboard ADD COLUMN id_group int(10) NOT NULL default 0 AFTER id_user; ALTER TABLE tdashboard ADD COLUMN cells int(10) unsigned default 0 AFTER active; The sql error message doesn't appear anymore in the dashboard.
Hey, maybe someone can also help me with this I have been using Pandora FMS on Windows 10 for a few months, with employee monitoring software if this is matters, and everything was great, however just the other day I added a new agent with the same configuration that I used many times and all modules are uninitialized. I tried to install the agent on different computers with the same results. It seems like every new agent I add to Pandora fails to initialize its modules. All my control agents are showing fine. My version is v7.0NG.737 - Build PC190731 - MR 30
Hey, maybe someone can also help me with this I have been using Pandora FMS on Windows 10 for a few months, with employee monitoring software if this is matters, and everything was great, however just the other day I added a new agent with the same configuration that I used many times and all modules are uninitialized. I tried to install the agent on different computers with the same results. It seems like every new agent I add to Pandora fails to initialize its modules. All my control agents are showing fine. My version is v7.0NG.737 - Build PC190731 - MR 30
Hey, maybe someone can help me with this. I've been using Pandora FMS on Windows 10 for a couple of months, with employee monitoring software(if it's worth mentioning) and it's been great, but just the other day I added a new agent with the same configuration that I used many times and all the modules are uninitialized. I was trying to install an agent on different computers with the same results. It seems that every new agent I add to Pandora is unable to initialize its modules. All my control agents are doing fine. My version of this is v7.0NG.737-Build PC190731-MR 30
Hey, maybe someone can help me with this. I've been using Pandora FMS on Windows 10 for a couple of months, with employee monitoring software(if it's worth mentioning) and it's been great, but just the other day I added a new agent with the same configuration that I used many times and all the modules are uninitialized. I was trying to install an agent on different computers with the same results. It seems that every new agent I add to Pandora is unable to initialize its modules. All my control agents are doing fine. My version of this is v7.0NG.737-Build PC190731-MR 30
Entra en tu cuenta para publicar.
