scriptygoddess

26 Jul, 2003

MT Activity Log overload

Posted by: Jennifer In: Lessons learned

So, Good News: People have been coming to your site and using your mt-search feature a lot! Bad News: They've been using it so much, and you've neglected it for so long that when you go to try and view your "Activity log" the page won't even load.

If you want to reset your activity log, but can't even get the page to load in order to do so, here is what you need to do…

WARNING – This will DELETE ALL entries in your acitivity log! This is essentially what MT does when you click on "Reset Activity Log" – but just wanted to make sure you knew what you were actually doing here.

If you want to review the log first before clearing it out…
Using phpmyadmin – go into your mt database. Click on mt_log table (to view it's details). If you click on the "Browse" tab, you'll be able to scroll through the entires in the log.

To continue on and delete (ie. reset) the log…
Click on the SQL tab. Enter this code in the "Run SQL query/queries on database…etc.etc…" text field:

DELETE FROM mt_log WHERE 1;

Then click the "go" button.

That's all there is to it.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

3 Responses to "MT Activity Log overload"

1 | girlie

July 29th, 2003 at 6:11 pm

Avatar

You can also just use this URL to reset the log:

http://www.yourdomain.com/mt.cgi?__mode=reset_log

2 | Mark Paschal

July 29th, 2003 at 1:32 am

Avatar

If you're in for some file hacking, you can make MT tail the log instead.

3 | Jay Allen

July 28th, 2003 at 2:52 pm

Avatar

I know it may sound crazy, but if you just wanted to delete the first N entries in the log (the oldest ones) you could do this instead:

DELETE FROM mt_log WHERE log_id < N;

Featured Sponsors

About


Advertisements