Time_accounting table error

[gusmaer]

Hello how are you.
We are having a problem with the application version 5.0.42 bd MySql.
The issue is that we detected that the time recorded for each ticket was not being displayed.
Reviewing the application log we noticed that it had indicated an error that said that the time_accounting table did not exist.
We are using MySql, checking the database indeed the table does not exist and checking the corresponding physical files for this table do not exist either.

Can this table be created again?
How should the creation of the table be done?

In case of having information in a report, could the time taken in the cases be re-created?
How could it be done?

Thank you in advance for your help.

[root]

Hi,

This table is created during the installation. But you can check the file scripts/database/otrs-schema.mysql.sql
You will find there the DDL for this table.

- Roy

[gusmaer]

Hi,
Thanks for the comment, do you know if the data in the table can be reloaded if I have a report in excel?

[root]

Hi,

You could give it a try, but I would do sth like this always on a test system. Writing directly to the database and bypassing the API isn't a good thin because of the cache. So, clear the caceh afterwards.

- Roy