Our Table ost_osticket_session have currently millions of entries over the Years.

Can we delete very old entries from this table without any negative Effects or data corruptions in OSTicket?

Best Regards
Guido

There is no ost_osticket_session table...

There is an ost_session table, so maybe you meant that?
Yes you can drop all the old sessions from ost_session.

This SQL query should do the trick.
DELETE FROM ost_osticket_session WHERE session_expire < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY))

NOTE: you can change the INTERVAL to whatever you want. I chose 30 as an arbitrary number.

As a side note my oldest session on my primary installation is a couple days old. I'm not sure why you are seeing ones that are years old... maybe its a bug in the end of life version that you are running (1.9.x).

Yes, we mean the table ost_session.

Thank you for you Answer!

Best Regards

Very welcome.

I'll mark this thread as resolved and close it. Please open a new thread if you have another question.

ntozier changed the title to [resolved] Cleanup of ost_osticket_session.
Write a Reply...