Error applying MR 55.sql. I seem to be missing the tuser_task_scheduled table ? - Pandora FMS Community

Community support

Error applying MR 55.sql. I seem to be missing the tuser_task_scheduled table ?

Posted by JonRussell on junio 28, 2022 at 10:29

Hi.

When I updated to v763 this weekend, and ran MR 55.sql, the update failed.

I had to comment out the tuser_task_scheduled alter table line in the MR file.

I noticed that MR 53.sql also has an alter table for that table too. It would seem that MR failed too.

I looked back through the other MRs and I cant find a create for that table.

Any ideas why I’m missing it ?

Can someone send me the schema, so I can create it ?

Thanks

JonRussell replied 2 years, 7 months ago 2 Members · 2 Replies
2 Replies

vic

Administrator
junio 28, 2022 at 11:13

1552 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master

Like it
Up
0
Down
Drop it
::
Hi JonRussell,

The modification of this table is a development error, the tuser_task_scheduled table is enterprise so it is not defined in the pandoradb.sql nor in the MR (in the opensource version this table is not used).

I’m going to open an internal case to take into account the enterprise tables in the MR.

If possible use the mysql ‘source’ command to insert the MR and skip that error message.

Sorry for the inconvenience.

Best regards,

Víc.
JonRussell

Member
junio 28, 2022 at 13:40

273 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
Ok. I commented it the offending line out, in the MR sql, so it ran ok.

Thanks

Jon.

Log In to Reply