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.

3 Responses to "MT Activity Log overload"

1 | 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;

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 | 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

Featured Sponsors

Genesis Framework for WordPress

Advertise Here


  • Scott: Just moved changed the site URL as WP's installed in a subfolder. Cookie clearance worked for me. Thanks!
  • Stephen Lareau: Hi great blog thanks. Just thought I would add that it helps to put target = like this:1-800-555-1212 and
  • Cord Blomquist: Jennifer, you may want to check out tp2wp.com, a new service my company just launched that converts TypePad and Movable Type export files into WordPre

About


Advertisements