Version: v1.7.0
I've been demoing and testing an install of osTicket internally and the company is getting ready to start using it for production. I went through and deleted all of the "test" tickets that I entered, however, they still seem to show up in the Dashboard -> Ticket Activity and Statistics.
Is there a way to reset that info or tell the system to exclude deleted items? Thanks!
Bump! - I can't be the only one to have deleted tickets and want them out of the dashboard. :)
Bump! - I can't be the only one to have deleted tickets and want them out of the dashboard. :)
The best solution would be to delete entries from Tables.
Deleting a ticket from inside osTicket deletes the bug from ost_ticket, however, it doesn't seem to remove the events related to that bug from ost_ticket_event, which is what appears to be generating the dashboard info. However, in the past, when I went in and manually removed items from ost_ticket_event, it appeared to cause the dashboard to go weird and show "NaN" all over the place and no longer give accurate report data.
Am I missing a table that needs to have data removed?
Deleting a ticket from inside osTicket deletes the bug from ost_ticket, however, it doesn't seem to remove the events related to that bug from ost_ticket_event, which is what appears to be generating the dashboard info. However, in the past, when I went in and manually removed items from ost_ticket_event, it appeared to cause the dashboard to go weird and show "NaN" all over the place and no longer give accurate report data.Am I missing a table that needs to have data removed?
I would suggest, I haven't tried it, but deleting all tickets except 1 and match that ticket_id in ticket_event table and leave that ticket record and delete rest of the records should solve your problem.
Cheers
my ticket_event table is read only so i cant delete the data. How do i change it? i tried adding a primary key and a unique id but no dice.
If you find that your ost_ticket_event table is read only... then its likely that your not using the same username/password that your osTicket installation is using (because your user should have full privileges to your database tables).
I also suspect that this thread is what you all are looking for:
http://www.osticket.com/forums/showthread.php?t=15539(http://www.osticket.com/forums/showthread.php?t=15539)
The funny thing is, i can edit the other tables. idk. but yes that link was exactly what i was looking for. Thank you so much!
That's bizarre. Maybe its the tool your using then?
Very welcome. :)
@[deleted] : any idea where I can find the info on the link you provided, as the link seems to be expired now.I would like to delete all entries from my dashboad page as well, but not sure how to do that ?
Huh that link is dead. Someone must have deleted the post... or maybe it was lost when we migrated over to the new forum software. If you are just looking to zero out the results on the dashboard you would go into the DB and drop the contents of the ost_ticket_event table. Something like:Truncate table ost_ticket_eventIf you're looking to empty the entire database you can drop it, and re-import it from the mysql file at: setup\inc\streams\core\install-mysql.sql. If you need more specific directions you an post or pm me.
