By jorre on

guys, really,
I'm working on my site since a few weeks, and today I had the strangest thing happening

I use the "admin" account to login, but since a few minutes ago, I cannot login anymore with my account;.. it says it doesn't exist anymore when trying to request my new password....

I cannot change my site anymore or nothing without this login :(

can I manually add a database entry to my users table, so that I have my admin account back?

of course, I have full access to my backend database, but there, the line that should mention my admin account in the users table is totally empty!!!!

HELP please!

⋅ Categories: Drupal 4.7.x

Comments

mndonx’s picture

mndonx commented

I solved this problem earlier today by adding:

ini_set('register_long_arrays', 1);
ini_set('session.cookie_domain', 'domainname');

to my settings.php page (domainname is your base url, no http:// or folders).

There is are a lot of other ideas here if that doesn't work for you:

http://drupal.org/node/6696

mndonx’s picture

mndonx commented

Now that I think about it, I'm not sure if that is the same problem; my admin account was still there and the log said I _was_ logged in -- just kept throwing me back to the log in page each time I tried. But maybe you can find a solution in that discussion nonetheless. Good luck!

newms’s picture

newms commented

Did your host upgrade to php 5.2.0 without telling you? This will cause you to log back out whenever you click on a link, even if you're admin. If so, then apply the appropriate patch here. (There are about 3 different versions on the page so, if one doesn't work then try another).

newms

cog.rusty’s picture

cog.rusty commented

Does the admin account exist or not?
Take a look at your 'users' table for a user with uid=1, a 'name', an encoded 'pass' and a 'mail'.

jorre’s picture

jorre commented

no, my account doesn't exist anymore, and I have absolutely no idea how this happened?

the site is still not open to public... the admin user is totally gone.. it turned into an empty row in my sql table...

can I add this manually? I managed to add a users manually, but this user doesn't have the right permissions

does anyone know how to manully add admin permissions to a user in the drupal mysql database?

Pakfriet.be

jorre’s picture

jorre commented

kind of critical situation guys...

any ideas on how to create a full-priviliged user in drupal in the database? or how to grant full access to an existing user ...

Pakfriet.be

jorre’s picture

jorre commented

somehow, the number 1 user wasn't called admin anymore, but something else, don't know how it happened

i manually changed it, pasted in the encoded password from my local host (thank god i stored this password there too)

and it works again!

Pakfriet.be