By MadKad on

Hi

I have just transferred my database and files to another server, and now when I log into my admin section I get the user page then all the other pages are access denied and it throughs me out of the admin.

Why could this be?

please some one help, I have looked all over and even tried things i have seen people say but it didn't fix anything

⋅ Categories: Drupal 4.7.x

Comments

dbeall’s picture

dbeall commented

Resetting your Drupal admin password
Login to your host control panel, goto phpmyadmin
Over on the left side, click on the database name for your Drupal install, that will load the tables on the right.
Then click the Query Tab at the top, that will load the query screen with a query text area.
Copy this sql query string to the text area and change ('newpassword') to your new password.
UPDATE users SET pass = md5('newpassword') WHERE uid = 1;
Then click submit query
---
Enter your new password in the md5 function - it will automatically be converted via a one-way hash (this is why we can't retrieve your old password - the decryption is a one-way process).
---
Then log out, go to your site and log in with your new password.

-----------------------------------------------------
If your email address is right, no worries, but if it's not...

login to host control panel, goto phpmyadmin
Click the database name for the Drupal install
Then look for the table name 'users' , click the browse button just to the right of the label.
Then click the edit button on the left side of the uid1, edit the email address to the right one and then click GO.
Close the phpmyadmin window, log out of host control panel.
Goto your site and log in

dbeall’s picture

dbeall commented

sometimes, it's a guessing game with out knowing all the history.
Where the site was moved from, localhoast, shared host, vps.
What was done in preparation before moving.
Is the old install still intact so you can get a new dump of database after doing some drupal settings.
Are all the sites/all/modules in place that were in the old install.
Is the htaccess file there ?? after the move.

well, i could keep asking things to get a better idea of what is going on.

dbeall’s picture

dbeall commented

A PHP file to clear caches and rebuild the routing tables

Be careful not to leave this on the server as anyone can clear caches if they know the file name. Create a file named clear.php with the following code. Place the file in drupal base directory and run it by browsing to http://example.com/clear.php.

include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
drupal_flush_all_caches();
MadKad’s picture

MadKad commented

Hi thanks for the replies, I just tried your ways but still no luck, I did the database and it changed the password, it let me log in but then the next admin page after that webit to the access denied again.

I tryed the clear cache, I dont no it it worked as it just showed an page not found but in the drupal style (not a real page not found thing)

for your questions:

Where the site was moved from, localhoast, shared host, vps.?
From 1&1 hosting to another one there both shared

What was done in preparation before moving.?
Just downloaded the files and dumped the database.

Is the old install still intact so you can get a new dump of database after doing some drupal settings?
Nope sorry

Are all the sites/all/modules in place that were in the old install?
Should be

Is the htaccess file there ?? after the move?
Yep

Thanks for helping by the way :-)

dbeall’s picture

dbeall commented

Goto host control panel, phpmyadmin
Click on the drupal database to load all the tables
Click the 'browse' button just to the right of the 'variable' table
Find the row labeled as clean_url
Click the edit button
Change this s:1:"1";
To this s:1:"0";
Then save it(go) and try to log in to your site.

Also double check the settings.php file for the; database name, location, user, password that they are all correct for the new install location.

dbeall’s picture

dbeall commented

did all the database tables make the trip?
sometimes the import stops due to different reasons and remaining tables don't get imported..
You should have received an error upon import if this happened, but we still don't know what is the issue yet..

dbeall’s picture

dbeall commented

go into the phpmyadmin and make sure you have proper permissions for the new database...

EDIT: The more I think about this, the db privileges may very well be the problem.

dbeall’s picture

dbeall commented

load the site on your localhost wamp or xamp and work with it there..
or
use my email, send me the sql file and let me work on it in my development machine to see what's up.
This is Drupal 4 ? hmmm sounds like time to upgrade to Drupal 6