By idcm on

I have two sites running on one install of Drupal 6.10 that have anonymous comments enabled. One site works fine. The other, not so much. The other has organic groups running. The story content type is not part of OG. When I create a story node, only comments from authenticated users show up with the node AND in the comments management screen.

I see comments in the comment table from anonymous users so I know they exist. Anyone got an idea as to what the issue might be?

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

are the anon comments published?

idcm’s picture

idcm commented

they dont show as published in the comment screen nor do they show on the node. check it out. go to http://groups.idcminnovations.com/ and scroll to the last post in the list. 4 comments counted. when you open the node, only two show. they happen to be from authenticated users. they are the only ones i see in the comment screen. The db shows the others.

vm’s picture

vm commented

are permissions set correctly for anonymous users to post comments without approval or are the unpublished comments awaiting approval from you ?

idcm’s picture

idcm commented

yep. permissions set just as the other site. none waiting to be approved.

vm’s picture

vm commented

well if they are unpublished something isn't working correctly. With so little information, I don't know what else to look for.

idcm’s picture

idcm commented

thanks for trying

loic_e’s picture

loic_e commented

Hi,

Same issue here: permissions configured correctly,
I can see the comment in the block, when clicking on the link, it brings me to the node, but here I can only see the admin-comments.
In the published comment admin page, I can't see other comments than from admin.

Drupal 6

idcm’s picture

idcm commented

are you running the organic groups, notifications, and/or messaging modules? The site that is running these is having the issue but my site that isn't running these isn't having the problem (two sites same D6 install).

I created a hack/manual work around. I created an account on my site called anonymous. Went into the comments table and changed the UID from 0 to 10. It worked, which means for some reason, a zero UID value is not being accepted as okay to display. I wonder if the OG module settings I have is causing this.

isantyas’s picture

isantyas commented

Hi,
I am currently having the same problem. That is, the anonymous comment posts are not showing anywhere but the database. It doesn't show even when I set it to allow posts without approval. I'm not running organic groups.

Was there a solution to this?

Tq

ashrobertenterprises’s picture

ashrobertenterprises commented

I had to try twice, but I saw something about no user with uid 0, so I went into the database back end and added a user with the uid 0 and now it works.

I suppose this should be filed as a bug, but I don't have the time. So hopefully some one will...

vm’s picture

vm commented

hard to file a bug report when we can't determine how it's breaking.

Drupal core is installed with a UID 0, the question becomes what is removing it.

chrisrockwell’s picture

chrisrockwell commented

I have not come across a module that removes it, but I have seen several times when a developer removes all users from the users table after testing is complete with a sql statement like remove * from users where uid is not 1 (admin), forgetting that anonymous is needed...

humanaut’s picture

humanaut commented

I am having the same problem..

Annonoymous comments are not being show in the "awaiting approval" page, and even if i give that group full permissions, their comments still don't show up. Go in to the DB, and the uid is 0.. switch it to 1, and the comments appear as they should.

I also have this if I am posting an article in my new content type and change the author information from the user name to blank, empty, etc, so no author shows up, the article gets a uid of 0 in the DB, which results in that page "cannot be found". If i go into that node / article and change it from 0 to 1 ( I assume 1 is super admin) then the article / node appears.

mmatsoo’s picture

mmatsoo commented

I was having this problem and the post about developers accidentally deleting all records from the users table rang a bell. (users table should at least have UIDs 0 and 1 for anonymous and superuser)

Sure enough, I checked my users table and uid = 0 (anonymous user) was not there. I added it manually into the DB and now anonymous posts are showing.

I am not sure why it was deleted in the first place because I hadn't done any direct table deleting/truncating in the DB. However, I have seen this happen in other situations too so it's something to keep in mind when dealing with anonymous user content. Make sure there's a record for the anonymous user (uid=0) in the DB.

yoda-fr’s picture

yoda-fr commented

Thanks mmatsoo,
I don't know why during a phpmyadmin export the uid=0 was changed to uid=12.
Changing the 12 to 0 resolve the problem and the anonymous comments are now displaying.

mherchel’s picture

mherchel
he/him
Primary language English
Location Gainesville, FL, US
commented

Same issue. Drupal 6.22.

I was running Captcha, and Mollom, but don't know if any of those are related.

mmatsoo's fix worked for me.

Premium component based Drupal themes

Ganganation’s picture

Ganganation commented

Hi there,

I've done the "create an user with id 0"-fix and that worked... for a day.
It just removed the user again?
I can't all the time create new users.
I can't recall doing anything removing the user (I did nothing the be honest).

Anyone an idea?

Thanks :D
Drupal 6.22

satvision83’s picture

satvision83 commented

I have this problem too.

When I try to comment with anonymous user, the comment is missing and it has this error:

Notice: Undefined variable: key in comment_prepare_thread() (line 901 of /www/examplesite/test1/root/modules/comment/comment.module).
EntityMalformedException: Missing bundle property on entity of type comment. in entity_extract_ids() (line 7633 of /www/examplesite/test1/root/includes/common.inc).

The permissions for View comments, Post comments and Skip comment approval are activated for anonymous users..
In the phpAdmin on table comment I can see all the comments there and uid is 0.

This problem doesn't occur when is commented with admin account.

alfthecat’s picture

alfthecat commented

This issue can indeed be caused by a missing/ accidentally deleted anonymous user. UID0 then doesnt exist in the system anymore and it will cause numerous, hard to detect problems.
You can fix this by executing the following mysql query (use phpmyadmin or go into your database or log into it from the command line)

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `mode`, `sort`, `threshold`, `theme`, `signature`, `created`, `access`, `login`, `status`, `timezone`, `language`, `picture`, `init`, `data`)
VALUES ('0', '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, NULL, '', '', '', NULL);

It will fix this and other problems you might not even know you have.

----
"People make mistakes. To really mess something up you need a computer."