shyamuthaman

I ran a SQL to delete all comments created since 2020 .. didn’t have a smarter way to do this.

Thanks. The wp-sweep approved all 20k comments and the database restore didn’t unapprove them. It brought back 20k unapproved plus 20k approved ..arghhh ??
Is there any SQL I can run to get rid of all comments that I approved today?

Hi Steven,
Thank you for the reply.
The problem here is that wordpress is not considering these spam comments as spam.
When I use wp-sweep on the 20k unapproved comments, all it does is that it approves all of them instead of removing them and my site gets littered with random garbage.

Akismet used to block these well but ever since I put ads on my site, I can’t use the free version and my site doesn’t generate enough revenue to cover the cost of Akismet.

Somehow, wordpress doesn’t consider these comments as spam. What am I missing here?
For example, the latest comment that I have is (Why doesn’t this obvious comment get captured in spam):

comment6, <a href="https://achatacheter.fr/cephalexin_fr.html" rel="nofollow ugc">achat cephalexin</a>, 244, <a href="https://achatacheter.fr/antabuse_fr.html" rel="nofollow ugc">achat antabuse</a>, ghbnw, <a href="https://achatacheter.fr/mestinon_fr.html" rel="nofollow ugc">acheter mestinon france</a>, 231, <a href="https://achatacheter.fr/etodolac_fr.html" rel="nofollow ugc">achat etodolac</a>, 8503, <a href="https://achatacheter.fr/trandate_fr.html" rel="nofollow ugc">acheter trandate</a>, >:-(, <a href="https://achatacheter.fr/kemadrin_fr.html" rel="nofollow ugc">vente kemadrin</a>, wmnt, <a href="https://achatacheter.fr/lexapro_fr.html" rel="nofollow ugc">acheter lexapro en ligne</a>, :-(((, <a href="https://achatacheter.fr/doxycycline_fr.html" rel="nofollow ugc">prix doxycycline</a>, 6040, <a href="https://achatacheter.fr/asendin_fr.html" rel="nofollow ugc">acheter asendin</a>, sepyk, <a href="https://achatacheter.fr/proscar_fr.html" rel="nofollow ugc">commander proscar</a>, hcc, <a href="https://achatacheter.fr/betapace_fr.html" rel="nofollow ugc">acheter betapace</a>, 8DDD, <a href="https://achatacheter.fr/eulexin_fr.html" rel="nofollow ugc">acheter eulexin france</a>, ejfqmn, <a href="https://achatacheter.fr/trimox_fr.html" rel="nofollow ugc">vente trimox</a>, =D, <a href="https://achatacheter.fr/rumalaya_fr.html" rel="nofollow ugc">commander rumalaya</a>, 2363, <a href="https://achatacheter.fr/cardura_fr.html" rel="nofollow ugc">acheter cardura</a>, %-[, <a href="https://achatacheter.fr/celebrex_fr.html" rel="nofollow ugc">achat celebrex</a>, %((, <a href="https://achatacheter.fr/ditropan_fr.html" rel="nofollow ugc">vente ditropan</a>, %-(,

I had migrated this from godaddy to inmotion. Google research shows that the godaddy migrated sites seem to have this problem. No clear indication as to what causes this or a clear fix.

Thanks but I am looking just for a free plugin and not a paid full blown solution for now. I am sure there must be something out there

Ah yes. The cache was the problem. That was silly of me.
Thank you for your time and help.

Doesn’t work either

Nothing happened ??
I added below code after the last } bracket
/* Hide featured Image 17-May-2016 Shyam Uthaman */
.attachment-post-thumbnail{
display: none;
}

Thanks but can I just add it anywhere like at the end?

I used the Advanced Excerpt plugin. It worked fairly enough without any code.
Thanks for the reply.

It’s clear now.
Thanks for the quick replies.

Hi John,
I hadn’t found my answer. Thank you so much for your inputs.

Regards,
Shyam

I am sorry but am on localhost currently.
This is the screenshot

Sorry I am on a localhost right now. I wanted to make the basic layout before I buy this to be sure that I can do this.

This link is a screenshot of the problem.

Hi,
Thank you very much!
This is what I needed.

Shyam