No anonymous comments

I was having the exact same problem. Spent a lot of time disabling modules & etc. No change. Authenticated users could post comments & they would show up. Anonymous users appeared to be able to post comments -- and the comments would be stored in the comments table in the database -- but if set to moderated, they'd never show up in the moderation queue. If set to unmoderated, they just wouldn't ever show up at all, neither inline in the pages nor in the comments list in the admin menu.

Setting aside my urge to dig into the comments module to see what was happening, I went ahead & looked at my users table in the database. There was an empty user with a UID = 1+ the UID of my last legitimate user, and there was *no* user with UID=0. I compared this with a drupal 6.9 install I have, where anonymous comments are working correctly, and confirmed that its users table has an empty user with UID=0, and does *not* have an empty user with a UID at the top of the list.

I can modify the empty user with the high UID and change that UID back to 0 and I can confirm that this fixes anonymous commenting.

It appears that perhaps something in the system module's system.install in 6.10 is breaking this? This probably should be opened against that module.

I'd had this problem since 6.4, but didn't have the problem with my second site that started out at 6.9 or 6.8 or some time around there. I kept hoping it would be fixed in the next upgrade.

The site where the anonymous comments were stuck in the database didn't have a user 0 or a UID+1 so I inserted a user 0 into the table, left all the fields blank except for UID, and the comments all came through.

Thanks so much!

I million thanks! That worked. I'm new at directly playing with MySQL databases, but yes, if using PhpMyAdmin:

click your "users" table, browse tab.
sort by UID
there should be a blank user with UID 0. If not, click the insert tab, and add a used with UID 0, nothing else.

PS: yeesh!

Can confirm the same problem with the same solving
creating usr with UID 0

this must be some sort of a bug

I am still having the same problem. I had uid 0. Deleted them. Added a new one with UID = 0 and nothing else. Did not work. I also edited one of the user and set it uid to 0. That did not work either. I am using views to add a field to show number of comments on the page (0 Comments).

Anyone!!

The comments shows up for Anonymous users on the page but when using views to add "Node: New Comments", it shows up like "0 Comments" for anonymous users.

The solution remains: Create an user with UID 0.

This isn't bug. For some reason you guys lost uid0 and this most likely wasn't caused by drupal itself but instead by a migration or back-up upload.