Not sure exactly what happened, everything has been great for 2 years. Since last week I haven't been able to login, I thought it was a password issue so I went into the DB and changed the password (i've done it in the past for clients many times before). Didn't help anything, I can see the password changing so I know it's actually updating and I have checked and double checked that it's the right DB and login.
I noticed that I can't use the retrieve password functionality and that I am getting 300 errors in the log file for 'files that don't exist' but the pages all load so I am pretty confused. To try to fix it I uploaded, and replaced, files in my directory with a new d/l of drupal except for my theme which I have been using for over a year with out incident.
I can't for the life of me figure out what to do to fix this issue, any advice?
Comments
Did you check if the same
Did you check if the same site works on a different server or a PC (to exclude possible server problems)? If it does not work on a PC, the next thing I would try it to see whether it works after restoring a copy of the db from when the site worked.
You probably know that changing pwd is not the same in D7 as D6 owing to change in encryption method.
Basic stuff I know but checking the obvious things has to be the starting point!
Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors
I have tested it on two
I have tested it on two separate computers in Chrome, IE, FF and all of the pages load, I still get the errors in the log "File does not exist:" which is really weird and may not be related.
I have installed local versions of drupal, set up a new user, went into the DB copied the hash and replaced it on my site running this sql query: UPDATE users SET pass = MD5('$S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML') WHERE uid = 1;
I can see the new password saving in the DB, however when I try to access it, it still isn't letting me in, so freaking weird :/
I wonder too why the reset password isn't working either, this is the first time I have attempted to use it but I haven't modified it so im not sure if this is related to the login issue.
I posted aboveYou probably
I posted above
It seems rude of me to repeat the point, as you have presumably read my post?
Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors
^
Although md5() works in Drupal 6, no longer in D7.
D7 uses sha512 by default withsalt.
http://api.drupal.org/api/drupal/includes!password.inc/function/user_has...
http://api.drupal.org/api/drupal/includes!password.inc/function/_passwor...
What's new and changing in PHP 8.4
Is this page out of date
Is this page out of date then?
http://drupal.org/node/1023428
^
it should work, but you don't have to md5 the password again.
UPDATE users SET pass = '$S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML' WHERE uid = 1;Assuming "$S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML " is the hash you got from ssh.
What's new and changing in PHP 8.4