So, I have a weird problem, and I’m not sure this is the right place to ask it, but I’m going to try because all other options have failed.
I have a site that is running WPML and WooCommerce. On this site, I have a page called Guestbook, which is just like any other page, but it accepts comments. Anyways, I recently decided to do some clean-up of all the “awaiting comments”. They’re all spam so I hadn’t bothered until now. But going into the comments section of Admin, there is nothing there!
So my question is first of all, how do I rectify this? And could it have something to do with my code in the theme? I can’t think of anything personally, but perhaps someone has stumbled upon this before and might have some insight?
“Kommentarer” is “Comments” in Swedish, just FYI.
Similar problem, showed that we had comments even after deleting the entire list -- disabled WooCommerce and then refreshed the Comments list -- poof, gone!
Answered by ioweyouacoke on January 4, 2022
Try to check on DB level.
This SQL should give a list of all spam comments (which I assume skräpposter means):
SELECT * FROM `wp_comments` WHERE `comment_approved` = 'spam';
If the SQL gives 0 lines, the issue is with WordPress counting those comments, but in fact there are none. If the SQL gives a list, the issue is with the listing of those comments.
It may be an issue with the term
spam being translated when writing comments to the db, but not when reading or vice-versa. You can check all approval status tags in your db using this:
SELECT DISTINCT `comment_approved` FROM `wp_comments`;
(or in some dialect:
SELECT UNIQUE `comment_approved` FROM `wp_comments`;)
This should show terms like
trash etc. If you see translated string here, like
skräpposter and similar, you may be in for a ride to find out why those terms are not written in the db as they should.
If all seems fine on the db level, it's trickier to find the reason, why those are not listed. Definitely needs the target system to be investigated more.
But anyway, this is where I'd start my investigation.
*: assuming your db prefix is
It may be a malware infection, which may benefit from removing your ability to manage comments. They could as well hide spam comments from logged in admin user on the frontend, while showing them to regular visitors, so check your site in incognito and probably run some kind of a malware scan on it too!
Answered by sbnc.eu on January 4, 2022
This might be a conflict/issue with your theme. What theme are you using? Have you checked any comment or translation related settings in your themes settings (if any)?
You can also try this method for troubleshooting WPML.
Answered by dylzee on January 4, 2022
1 Asked on January 1, 2021 by paranoid-android
1 Asked on December 31, 2020 by macman
1 Asked on December 31, 2020 by wp_boss
0 Asked on December 30, 2020 by stanislaw
1 Asked on December 28, 2020 by sandy
2 Asked on December 28, 2020 by egr103
3 Asked on December 27, 2020 by click-here
0 Asked on December 27, 2020
3 Asked on December 27, 2020 by the-chewy
1 Asked on December 26, 2020 by kevsterino
2 Asked on December 26, 2020 by craig
1 Asked on December 26, 2020 by gerald
1 Asked on December 26, 2020 by usman-khan
0 Asked on December 26, 2020 by nbowdski
1 Asked on December 24, 2020 by hesham-shawky
1 Asked on December 23, 2020 by stefan-avramovic
0 Asked on December 22, 2020
0 Asked on December 22, 2020 by techn9ne
Get help from others!