Purging System Logs

arthursim

I had some old 'ticket denied' logs from another older upgrade. I'm on the current version now

v1.10 from Nov. I was hoping that changing the Purge Logs to 3 months would clear up the thousands of system logs I have from August, but that hasn't happened yet and it's 2 days later.Any suggestions?

ntozier

Are you running cron.php?

arthursim

How would I do that? And I do have auto-cron set up under Emails-Settings. I couldn't find an auto-cron on staff activity anywhere any more.

ntozier

You run cron or windows task scheduler to run the cron.php on a regular basis.see schedulinghttp://osticket.com/wiki/POP3/IMAP_Setting_Guide

ntozier

If you can run SQL queries... something like this ought to do the trick:DELETE FROM ost_syslog WHERE created < DATE_SUB(NOW(), INTERVAL 90 DAY);note: you should always backup your database prior to running manual SQL queries.

arthursim

I do have autocron set up to query my email provider and create tickets every 10 minutes. It doesn't seem to purge the logs though. I'll run the sql query, thanks.

arthursim

Cleared over 12500 items. Thanks!

ntozier

Very welcome. :) (I have like 212304 log entries right now which is about 6 months worth)