Posted in site bugs
726
6:16 am, August 6, 2021

still more comment spam

this is getting annoying now. so much spam. i already have the google recapture, but spam is still getting through.

who runs this stuff, bots i guess. annoying. 

update: 10 August 2021

Still getting random spam here, i guess i need to add more spam checks, how does it bypass the google recapture. Unless its posting it without the form.

find the ip address, it seems they are adding the "code" to the user or nick name field, so i need to limit the characters on that one, its all sql safe and escaped anyway so it cant harm anything, its just annoying to delete 2500 rows of spam every day. 

SQLite

SELECT * FROM "comments" WHERE "user_ip" LIKE '%88.218.66.72%'

now delete all this spam and move to the next ip, also add the ip to the block list

SQLite

DELETE FROM "comments" WHERE "user_ip" LIKE '%88.218.66.72%'

I think the issue or one of the issues is that there is no limit or filter on the nickname field, so need to add a filter and limit here. 

https://i.imgur.com/9jFDikl.png

Update: 14 Sep 2021

It seems i have still not solved this particular issue and have to keep going into the database and clearing out all the spam. 

Here is an example:

No Items Found.

Add Comment
Type in a Nick Name here
 
Search Code
Search Code by entering your search text above.
Welcome

This is my test area for webdev. I keep a collection of code snippits here, mostly for my reference. Also if i find a good site, i usually add it here.

Join me on Substack if you want me to send you a collection of the things i have done or found or read for the week. Or follow me on twitter if you prefer, i dont post much but i probably should!

❤👩‍💻🕹

Random Quote
I believe that success can be measured in the number of uncomfortable conversations you're willing to have.
Unknown