By petiar on

Hi,

my problem is that after anonymous user submit a comment, I can't see it in the approval queue in the admin menu, however, I can see the comment in the database table (comments), so it has been definitely submitted. As per my permissons settings an anonymous user is allowed to access (read) comments and post comments. It is not allowed to submit comments without approval. Drupal doesn't even shows the message saying "Your comment will be displayed after approval..." when submitted.

The funny thing is that on my localhost this works perfectly. It is the same version of Drupal. Does anybody have any idea what might have impact on this? I've imported users and content from Joomla - do you think that the problem could be on the database level?

Thanks a lot,
Peter.

⋅ Categories: Drupal 6.x

Comments

petiar’s picture

petiar commented

So,

after low-level investigation (SQL commands debugging) I've sorted this out. A record with uid 0 has to be in the users SQL table! I've probably deleted it while importing users from Joomla tables.

Being sarcastic I would say "Thanks for your help!", but I just enjoy the moments when I solve something by my own. So - thanks! ;-)

Petiar
http://petiar.sk

--
Petiar
http://petiar.sk

tgeller’s picture

tgeller commented

Hey, Petiar. I'm having the same problem, but am uncertain that your solution is quite right. I don't think Drupal usually has a user where uid = 0!

Possibly a bug? If so, I can't believe it hasn't been reported before. Ideas, anyone?

Thanks,

---
Tom Geller * San Francisco
Author/Presenter, "Drupal Essential Training" video series at Lynda.com
GellerGuides.com (Drupal) * SaveMyHomeBook.com (Drupal) * TomGeller.com (not Drupal)

---
Tom Geller * tomgeller.com * Oberlin, Ohio
See my lynda.com videos about Drupal

tgeller’s picture

tgeller commented

So I added a user=uid0, and my moderated comments suddenly started appearing again. So the solution works, but clearly we need to find the cause.

One curious matter: This was on a site where I'd created no users other than the admin. However, there was another user in the "users" table with uid=3, and no other non-zero information. Perhaps the anonymous user "migrated" from uid-0 to uid-3 somehow?

The biggest peculiarity about my site is that I had CiviCRM installed, but lately have been having serious problems with it and subsequently removed it. Perhaps it did something odd with my users? Petiar, had you tried using CiviCRM as well?

Thanks,

---
Tom Geller * San Francisco
Author/Presenter, "Drupal Essential Training" video series at Lynda.com
GellerGuides.com (Drupal) * SaveMyHomeBook.com (Drupal) * TomGeller.com (not Drupal)

---
Tom Geller * tomgeller.com * Oberlin, Ohio
See my lynda.com videos about Drupal

petiar’s picture

petiar commented

Well, I can't remember exactly what was the reason to have uid 0 in db, but I am almost sure that this user is anonymous. So if you does not have it in your db than SQL SELECT trying to select both from users and comments table will not give any results for anonymous users. Unfortunately I do not even know what is CiviCRM module for, so no, I have not try...

--
Petiar
The biggest slovak folk music magazine proudly uses Drupal
http://folk.sk

--
Petiar
http://petiar.sk

jeefers’s picture

jeefers commented

Im having this Same problem but have never installed CIVI-CRM or migrated from Joomla.... Just a basic 6.8 install.
I checked the users area within the administration and Anonymous was listed as blocked in there.

After inserting the uid 0 into the database it still stayed the same but worked.

achusudhakar’s picture

achusudhakar commented

Great Help Petair. I inserted a new user with uid 0 in my db, now it works good. Once again Thanks for your help.

Konstantin_by’s picture

Konstantin_by commented

You solve my problem! YES thankS!

I just go to database table "users" in first column change uid=16 to uid=0

lugovsa’s picture

lugovsa commented

Had had the same problem. Now it's been solved - thanks to you.

Sincerest respect!

jojo86’s picture

jojo86 commented

This was very helpful and solved my problem really quickly :) It's weird that Drupal does have a user ID of 0 but hey, at least I know how to solve it if it happens again.

siramsay’s picture

siramsay commented

for some reason on a site migration the uid 0 changed to 51, it was the top record so went changed it back to 0, fixed.

rionka’s picture

rionka commented

Thank you a lot, this is exactly what was missing after transfer between the old and the new server. Creating the uid 0 works immediately and everything new is visible again (although i don't use approval and copied the old files from Drupal 6 to the same Drupal 6). Thanks again :)