By deadpan on

This is not the same problem that every newbie asks about, I promise.

I have checked and unchecked and rechecked the access content permission for anonymous users several times, checked the database to make sure it's taking effect, etc., and still I always get "Page not found" for anonymous users.

I originally installed 4.4.0-rc and have recently upgraded to 4.4.1, but no change. The only files I've messed with are user.module (just added another block) and some stuff in xtemplate. The site is at maa.openflows.org

any ideas what might be wrong?

Comments

david@www.phrixus.net’s picture

david@www.phrixus.net commented

Check your MySQL database and make sure you have an entry with a UID of 0. The anonymous user needs this entry to function properly. From MySQL, you can use this command:

mysql> SELECT * FROM drupal.users WHERE uid=0;

If the query returns an empty set, you'll need to insert a row. Use the following command:

mysql> INSERT INTO drupal.users (uid, rid) VALUES (0,1);

Note: This assumes that your database name is drupal. Change it as necessary.

deadpan’s picture

deadpan commented

thanks!

ramdak5000@www.drupal.org’s picture

ramdak5000@www.drupal.org commented

This almost answers the problem I raised in http://drupal.org/node/20447 yesterday.

But, when I do the select, I get the following message:
1 row in set

If I check the users table in phpmyadmin, I can see 0 in the uid value

Do I still need to run the command (mysql> INSERT INTO drupal.users (uid, rid) VALUES (0,1);) to get anonymous users to view content? I am confused because the row already exists.

I would appreciate some help with this.

Matthew OMalley’s picture

Matthew OMalley commented

never mind - i figured it out.

dvsDave’s picture

dvsDave commented

how did you fix the error?

Citilabs’s picture

Citilabs commented

David is right, I solved the same issue by telling mySQL to INSERT INTO drupal.users (uid) VALUES (0);

michael_lessard_micles.biz’s picture

michael_lessard_micles.biz commented

Just to be more specific for newer Drupal users :

If only anonymous cannot post, this means that in the table called users, you are missing a row with UID 0 (you will see UID 1 and more, but check if there is a UID 0).

Do not get confused with tables : role, users_roles, etc.

HOW TO :

Of course, open your database manager (phpMyAdmin for exemple)

i) check if there is a 0 in the UID column in table users

ii) if not, check if any row so happens to have no name at all: if so, that is your former UID 0 that has somehow changed to another UID. Just change it manually back to 0.

iii) if there both no UID 0 and no nameless row exist, create a brand new one, in which all columns are empty or NULL (will be selected by default when applies) except UID set to 0 manually.

--

For exemple, I had copied a database for a multisite (i.e. using the same core Drupal, you create many sites using different domain names; quite nifty). In my database transfer, for some reason my UID 0 (anonymous users) somehow was transformed in a new UID. So anonymous could never post anything successfully.

Michael Lessard
webmaster of Quebec City "democracy in action" media