Clean up spamblocklog and visitors tables?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
Zugschlus
Regular
Posts: 139
Joined: Sun Feb 05, 2006 12:54 am
Location: St. Ilgen, Germany
Contact:

Clean up spamblocklog and visitors tables?

Post by Zugschlus »

Hi,

I would like to clean up my spamblocklog and visitors tables as they take up quite a big amount of disk space. Do I break my s9y installation by simply zapping all records older than january 2009 according to Unix timestamp (spamblocklog) or date/time (visitors)?

Or does s9y have a high-level frontend function to clean up?

Greetings
Marc
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
onli
Regular
Posts: 2828
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: Clean up spamblocklog and visitors tables?

Post by onli »

As far as I know, you can even delete the spamblocklogtable, reinstall the plugin, and the table should get recreated. If you delete the content of the table a reinstall of the plugin shouldn't be necessary.
sincerely
Zugschlus
Regular
Posts: 139
Joined: Sun Feb 05, 2006 12:54 am
Location: St. Ilgen, Germany
Contact:

Re: Clean up spamblocklog and visitors tables?

Post by Zugschlus »

onli wrote:As far as I know, you can even delete the spamblocklogtable, reinstall the plugin, and the table should get recreated. If you delete the content of the table a reinstall of the plugin shouldn't be necessary.
sincerely
Does that also apply to the visitors table?

Greetings
Marc
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Clean up spamblocklog and visitors tables?

Post by garvinhicking »

Hi!

s9y has no high level function for that yet, sadly. But you can easily truncate (not drop) the table, without the need to reinstall a plugin. Of course, first backup the data you want to backup :)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Zugschlus
Regular
Posts: 139
Joined: Sun Feb 05, 2006 12:54 am
Location: St. Ilgen, Germany
Contact:

Re: Clean up spamblocklog and visitors tables?

Post by Zugschlus »

garvinhicking wrote:s9y has no high level function for that yet, sadly. But you can easily truncate (not drop) the table, without the need to reinstall a plugin. Of course, first backup the data you want to backup :)
Thanks!

Greetings
Marc
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
Post Reply