Dashboard Broken After Clearing THREAD and THREAD_EVENT Tables

cquinton

After doing some testing, I decided to delete all of the test tickets I had made to start off on a clean slate. I also decided to follow the advice in this thread so that the dashboard would be empty and clear the THREAD and THREAD_EVENT tables in the database: [https://forum.osticket.com/d/93048-reset-dashboard-stats]

To clear these tables, I used the truncate command (truncate table thread, etc.). It seems like this was the wrong way to do this, as since doing that, the dashboard is broken and no longer properly displays the graph or ticket stats, despite tickets being present:

The number of opened and assigned tickets is also no longer accurate. Is there a way I can fix this?

Thanks for your help!

KevinTheJedi

cquinton

Do you have a backup? If not then your SOL. Never manually delete things from the database unless you know what you are doing. To me it looks like the dashboard is stuck on a single date (09/23/2025) - maybe that'll help you track it down.

Cheers.

cquinton

Thanks, I do have a backup luckily. For future reference, what would be the correct way to clear those two tables as described in the other post?

KevinTheJedi

cquinton

I mean there is other related data you must clear too. Look at our ERDs on the documentation site to see how the tables relate, etc.

Cheers.