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 LancelotG on
Hi,
I've had trouble recently with the website and lost access. Now, it displays the theme, menus and blocks, but it apparently can't find the nodes. I need to get the texts back, though. Do you know where I could find the node content in the database, say through phpmyadmin? In which tables could I find the page content?
Comments
The content is in the
The content is in the node_revisions table, but don't give up yet.
What exactly do you see in the content region? A Drupal-themed "Page not found"?
Is anything improved when you browse to ?q=node/nnn instead of just /node/nnn?
Also try running update.php, even if there are no updates, and see if it completes and doesn't stall.
thanks a lot for your help.
thanks a lot for your help.
I'm getting the standard, drupal-themed (actually, modified-themed, as I had customised it before the problems), "page not found error".
I did not have clean urls installed, so clicking on the links in the menus automatically sent to ?q=node/nnn anyway.
Unfortunately, I'm absolutely useless at php, so I wouldn't know how to run update.php.
Thanks!
G.
Try switching to Garland or
Try switching to Garland or Bluemarine to see if they have the same problem.
Also, if you have modified the .htaccess file in any way, upload a fresh one from the Drupal package.
What I meant by "run update.php" was "browse to http://www.yoursite.com/update.php and proceed until the program completes".
What I didn't mention (but
What I didn't mention (but should have) is that I can't change anything to the site as I can't log on. Any username I try comes up "does not exist or is inactivated". So I can't switch themes, for example.
I think that's related to the fact that when I tried to run update.php I got a page saying "access denied". EDIT: after modifying the settings.php file I was able to run update, but I got "access denied" when I clicked on the link to the log of report.
Then the main problem seems
Then the main problem seems to be that you can't log in.
Did update.php complete successfully?
Go to the database using phpmyadmin,
- browse to the 'users' table
- find the user with uid=1 and make sure that it also has status=1
- give it a user name with only English characters (not necessary, just to be safe from possible character encoding problems)
- give it a new password with only English characters and select function MD5
Then save the changes, go back to http://yoursite.com/?q=user and try to login.
I don't know what "select
I don't know what "select function MD5" means. Is that a field in the user table? Because I can't find it.
The rest doesn't seem to be working, though. I created a new user with uid 1 (I think I deleted the original one in my earlier attempts to regain access to the site at all), but I can't login with it as the website tells me the password is wrong. At least that's different from the previous attempts when it told me the user didn't exist at all.
In any case, I want to thank you for the time you're spending on this. I really appreciate it.
MD5 should be in a MySQL
MD5 should be in a MySQL column titled "Function" which appears when you are editing a field, and is necessary for the password to work. But never mind. Try it in a different way:
- Delete that user 1 from the users table in the database
- Go back to Drupal and register a new user, with a new password.
- Then go back to the database, and change the new user's uid to 1 (and make sure that its status=1 as well).
Ok, I got it, and I now have
Ok, I got it, and I now have access to all my pages. You, sir (EDIT: or madam, of course, should that be the case), rock in an awesome way.
Thank you so, so much.
G.