Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By Keith2005 on
Something blew out my MySQL users table. at my home site http://www.pioneer-net.com. I came to conclusion when I dropped its users and the user_roles into another working drupal I get access denied just like the home page. Until I login then everything is back to norm as far as the home page being able to be viewed.. How do I fix without loseing user data? Any input PLEASE
Comments
Well...
I don't think just dropping users and roles into another working Drupal is a good idea because there are so many places where uid is used and it would be out of sync.
However, the first thing I would suggest trying is to go to admin >> content >> post settings and rebuild your access permissions.
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
NancyDru
Access Denied
Thanks for helping; In Drupal when I open content from the admin menu all I see is a tab list,configure,search,setting and default workflow??
Hmm...
It sounds like you are either A) not the admin (user/1), or B) not on 5.1. I don't remember if or where that button was prior to 5.1. But it would certainly only be available to user/1.
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
NancyDru
Access Denied
I thought I was the admin until Sat and somehow deleteing a user with a .ru email pooched the sys and the next thing I was getting calls about Access denied when coming to the home page. I got looking at my MySQL user table and it was missing UID 0 and haven't been able to correct the problem.
Hmm...
This might help a little: http://drupal.org/node/134505
Looking at my user/0, I see 0 in the uid, mode, sort, theshold, created, access, login, and status fields. Everything else is empty. Maybe that will help you rebuild the anonymous user entry.
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
NancyDru
Access denied by Anonymous at home page untill logged in ???
I already tried that originally, and UID 0 is back with the right permissions, but still have the same problem. :( Just has me stumped. If I upgrade to drupal-4.7.6 will it run on php 4.3.4 ? Also I'll lose all the extra features on my site won't I?
Yes and no
Yes, it should work with php4. But why stop with 4.7.6? Go on to 5.1.
Why would you think your extra features wouldn't work? They might need to be updated, but there are instructions on how to do that. Most contributed modules are now updated.
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
NancyDru