Hello All, I've recently moved a working Drupal website to a new server, I’ve got a SQL dump, copied the directories etc from old server, created a new SQL database, imported SQL dump, uploaded the directories, edited settings.php with the relevant information and everything is working fine with the website apart from being able to logon.
When entering the user name and password i am brought straight back to the logon page with the username box highlighted in red, if I look at the users table using phpmyadmin I am using the correct user name and even if I edit the password with a MD5 hash i am still unable to logon.
If I try request a new password on the logon screen I’m asked to enter username or email address again I’m displayed the same screen with the username or email input box highlighted in red.
Any help would be greatly appreciated
Many thanks in advance
Comments
_
Try clearing the cache* tables and the browser's cache.
Thank you for you reply
Thank you for you reply
I've cleared the cache tables and browser cache and i'm still experiencing the same problem.
_
I forgot to mention, also clear the sessions table. Also, instead of editing the password field directly, follow the site's reset password procedure. And don't forget to use the exact case in the username and password.
Again same results still
Again same results still unable to logon, once again thank you for your efforts
_
hmmm... i'm running out of ideas-- do you maybe have some stray directories in your drupal root (ie /user or /admin)?
no i don't have either
no i don't have either directories in drupal root
Update
After looking through the database, in the table called 'users_roles' there were only two entries in the table both user ID's were not that of the Admin account I was trying to logon with.
I tried entering the user ID of the admin account I was trying to use (ID=1) as a new entry into the 'users_roles' table', however the account still wouldn't logon so I've changed one of the accounts who's ID was in the 'users_roles' table to reflect the details of the account I was trying to logon with.
This gained me access to the backend of the site and I’m able to carry out the rest of the work i need to finish.
Once again WorldFallz Many thanks for your time spent trying to help me resolve this issue.