Spam trouble

SBY · Post by **SBY** » Sat Apr 30, 2005 11:50 pm

I upgraded to 0.8 today and hoped it might help my spam trouble. I am not getting spammed from an external source it does not look like.

Every time I add a new entry, there is automatically a post from Texas Holdem in the comments section. It does not show on the main page that there is a comment. But if you click the comments link under the entry it is there every time. I can delete it and it does not come back. The messages are always different, but from the same author.

I have entered everything I can think of in the spam blocker plugin but to not avail. I have disabled comment on my entries and they still come up.

Could this be something that has infected (for lack of a better term) my s9y install?

Thanks for any help.

Post by **garvinhicking** » Sun May 01, 2005 1:38 am

This sounds more like a database issue on your installation. Which database system are you using?

How does your serendipity_comments table look like? Does it have entries with entry ids that are set to "0" or nonexisting entries?

Regards,
Garvin

SBY · Post by **SBY** » Sun May 01, 2005 3:32 am

According to the setting in Serendipity it is MySQL.

Where can I look at these databases?

I do not see anywhere I can access to check it in my FTP or in Serendipity.

Post by **garvinhicking** » Sun May 01, 2005 2:18 pm

You could use a tool like phpMyAdmin to view your database; many provider also have that preinstalled on your host. Maybe you can ask your provider if they have a tool for you, or you use phpMyAdmin...?

If that is too hard for you I could offer you to have a look at your installation, but you'd need to give me FTP access to your machine then. Mail me privately if you want to do this.

Regards,
Garvin

SBY · Post by **SBY** » Sun May 01, 2005 5:01 pm

OK, I am looking at the DB with phpMyAdmin, I looked in the _comments table and I have 300+ entires like this:

http://myuseless.com/coppermine/display ... m=12&pos=0

Do need to delete all of these entries?

Post by **garvinhicking** » Sun May 01, 2005 9:12 pm

Now go and order this query result by the "entryid" column (click on the column header). Then see if there are comments related to entryids which do not yet exist in your entries table?

If you need/want, you can delete those "bad" comments already.

Regards,
Garvin

SBY · Post by **SBY** » Sun May 01, 2005 11:52 pm

I never could figure out the time stamp, but I deleted all the SPAM entries from the DB and that has fixed the trouble.

I guess it was putting on one of those entries every time I made an entry.

Thanks for your help Garvin, I am glad that is taken care of.

Spam trouble

Spam trouble

Re: Spam trouble