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.
Spam trouble
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Spam trouble
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
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
# 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/
# 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/
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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
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
# 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/
# 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/
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?
http://myuseless.com/coppermine/display ... m=12&pos=0
Do need to delete all of these entries?
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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
If you need/want, you can delete those "bad" comments already.
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/
# 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/