You know Jim – what would really be the most helpful thing would be a database dump of an affected post. This is difficult because you don’t know its going to happen before you delete it and once it’s deleted…. I spent hours months back looking closely at every spam post record just in case… and then deleting only to find it wasn’t one it happened to!

Yellow Swordfish said
…what would really be the most helpful thing would be a database dump of an affected post.

I could do that. I have determined that redirection only occurs on spam posts if the status bar shows a link when hovering over the delete button. So…

1. You need just an export of all rows for that specific post, right?
2. Advise if any special export options are necessary.

Looking forward to helping figure this out!

just an export of that single post row in the db would be good. That way we could copy the post content into a development system for testing and see exactly what is happening and try and resolve it. So – nothing special – just a single row export as a sql insert script.

The reason for a single row sql export is, of course, that just copying and pasting the text into an email would almost certainly fall foul of the email spam filters! Whereas you should be able to dump the row, zip it up and email it off intact.

This would be a great help if possible – thanks Jim

OK, just uploaded .zip file with two db row dumps for both you and Steve to test. See PM for details.

Wow – that didn’t take long!
I will take a look – thanks.

Oh this is neat! I have to assume that this is done on purpose of course but they are using malformed html which leaves the whole area open a a link!

reckon we can defeat this!

I want to thank you for your help Jim – a great help having that data.

For the record, the spam link redirection just occurred on our test site where Akismet is deactivated.

I didn’t bother dumping the table rows since y’all said this is figured out, but if you need me to, and it happens again, I will.

yes, when we were able to get the data from you, it was clearly not related to akismet…