SPAM Comments for Ghost-Pictures

[doeni188]

Hi!

Have a little problem with spam.

My page: www.mannmitstativ.de
Like you can see, you can see nothing.
No comments!

So far no problem. But I get emails which tell me that someone write a comment.
GREAT! -.- :(

"Hello,
a new comment was written: http://www.mannmitstativ.deindex.php?showimage=44"

But there is no image with the id 44!

The only way to delete this comments is in SQL because there is the same problem like in this thread: http://www.pixelpost.org/forum/showthread.php?t=8417&highlight=moderation+awaiting

Now my question:
I think the image 44 is somewhere in the database. But where? I whant to delete the entry out of the table, so no one and nothing is able to write a comment to this "ghostimage".

Thanks for help,
Dennis.

[domc]

I am having the same problem with one of my photos that I deleted and still has comments but can't delete them. They were awaiting moderation but I deleted the photo before I deleted the comments.

[doeni188]

To delete the comments is no problem with SQL Database. (Take a look in the thread I posted in my first post).
But if I have deleted them, I still get new comments for a picture that doesn't exist anymore.

That 's my problem.

[Dennis]

That is automated spam and we cannot do very much about it at this point.

[doeni188]

But is there no chance to reset the image IDs, so that it starts from one?

[Dennis]

Yes, that is possible but it is really difficult depending how many images you have. And you need to change stuff in multiple tables.

[doeni188]

I have reseted the whole page, so I don't have this much pictures.

Could you tell me which tables I have to clear?
But it's also possible to me to give you the mySQL rights, so you can do it for me.

I would do it if I wouldn't be a noob in this issue. ^^

greetz Dennis (also my name ;) ).

[Dennis]

How many pictures do you have?

[doeni188]

Six, ID 116 to 121.

[folgerj]

They found some pictures that I've deleted and now I have over 1000 ghost comments that I can't clear.... I'm think about starting over or just deleting my blog entirely...

I hate to do this because I have many links to it...

I hope to avoid this by finding a good work around...

Ideas???

[jaywilliams]

Why don't you enable Defensio? It does a good job stopping all spam, from Ghost photos, to real photos.

[folgerj]

I do have defensio ver 1.4 running but this is a hole that if spammers can find a deleted picture they can target that picture and defensio can't grab it first...

It's a big hole in PP 1.7.1 so I assume I'll have to delete all that I have and either start over or just let it go... I have other blogs but this was my first and I hate to lose all the wonderful comments...

Jeff

[Dennis]

doeni188, ow... in that case it should be easy. Send me an SQL dump of the pixelpost database.

folgerj: What are your settings? Do you have set your comments to moderation or do you publish them as they come? If you use moderation and you want to get rid of any unapproved comments open up PHPMyAdmin and execute this


DELETE FROM `pixelpost_comments` WHERE `publish`='no';
DELETE FROM `pixelpost_comments` WHERE `publish`='dfn';

The code above clears the comments table for each comment that wasn't published or comments flagged by defensio.

To delete all comments for a non-existent IMAGE ID:

DELETE FROM `pixelpost_comments` WHERE `parent_id`=xxx;

with xxx representing the missing image ID

[folgerj]

Due to a rebuild a while back some of my comments were set for publish immediately and the rest are to moderation.

There is no way to tell which pictures there targeting because all I see is an empty que with 106 pages of nothing, and each one is blank.

I'll look at the sql commands and figure them out later. I can usually figure that stuff out but I have to have time to do it... It's my busy season...

I appreciate it the help though and if I get it squared away I'll let you know...

Jeff