Textpattern CMS

#1 2008-01-07 12:55:37

johnnie

Member

Registered: 2007-03-10

Posts: 58

quickly empty the log

My visitor log is clogged with me F5-ing to check changes to the lay-out and content. How do I quickly empty this without having to sort through all the pages?

Last edited by johnnie (2008-01-07 12:56:04)

#2 2008-01-07 13:27:27

jm

Plugin Author

From: Missoula, MT

Registered: 2005-11-27

Posts: 1,746

Website

Re: quickly empty the log

Admin > Prefs > Advanced > Delete logs after X days – enter 0

---

What? My name is… | GitHub

#3 2008-01-07 13:37:18

johnnie

Member

Registered: 2007-03-10

Posts: 58

Re: quickly empty the log

Brilliant, thanks!

#4 2008-01-09 13:00:19

gerhard01

Plugin Author

Registered: 2006-12-07

Posts: 108

Re: quickly empty the log

Or do it via SQL (e.g. via rss_admin_db_manager):

DELETE from txp_log WHERE id < INT

where INT is the index number

Last edited by gerhard01 (2008-01-10 07:15:30)

#5 2008-01-10 05:02:56

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: quickly empty the log

If you’re just wanting to empty the whole table, the simplest query is:

TRUNCATE txp_log;