Batch-deleting Posts

[DrNI]

Hi folks,

do you know this feeling... when your past keeps haunting you like a ghost?

I want do delete some old posts, identified by their post number. Is there a way to do this automatically?

I know how to use Unix commands and the cmd line mysql client, if that should be needed. Feel free to post nerdy answers.

Thanks for your assistance and thanks to all of you making s9y available. Great software.
DrNI

[garvinhicking]

Hi!

If you want ot do that, the best way would be to use SQL directly:

DELETE FROM serendipity_entries WHERE id IN (4,8,15,16,23,42)

This leaves some corpses of data in the database, but that should not really be relevant.

Of course, the cleaner way would be a script like:

Code: Select all

<?php
include 'serendipity_config.inc.php';
serendipity_deleteEntry(4);

serendipity_deleteEntry(8);

serendipity_deleteEntry(15);
...

HTH,
Garvin

[DrNI]

Hi Garvin et al,

it's deletion day again, but somehow this doesn't work any more:

Code: Select all

<?php
include 'serendipity_config.inc.php';
serendipity_deleteEntry(4);

serendipity_deleteEntry(8);

serendipity_deleteEntry(15);
...

Nothing happens, the log remains silent, except for a nice 200 OK line in the access log.

Are there changes to the s9y code that make this solution not work?

Thanks for your help

DrNI

[garvinhicking]

Hi!

Which s9y version? Also, are you logged in before you call the PHP script? It needs authentication.

Regards,
GArvin

[DrNI]

Hi Garvin,

Which s9y version? Also, are you logged in before you call the PHP script? It needs authentication.

I could have guessed that. Did it again after login and of course it worked. Thanks for your help.

DrNI