WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I recently restored a WP multi-site 3.0.1 database from production to a staging environment, and when I try to login, I am being redirected to an HTTPS URL. The browser complains that the certificate is bad, and then when I click "proceed", it says page not found. I have cleared my browser cookies and all that good stuff, but it still won't let me login.

Also, I am experiencing intermittent "No site defined on this host" errors when I try to login.

I've never seen this issue before, and I have definitely done this backup db restore process before.

Thanks for your help, Dave

share|improve this question
up vote 2 down vote accepted

I figured this one out finally. It turns out that the data in the wp_usermeta table for user_id=1 (admin) was corrupted. This was apparently causing the SSL redirect issue when trying to login to any domains.

Once I restored the proper data for user_id=1 into wp_usermeta, everything worked fine. I would much rather have WordPress give an error like "hey, your usermeta data is messed up", rather than have some strange random behavior like that.

Thanks for the help, Dave

share|improve this answer

Check if constants, enforcing SSL are defined:


See Administration over SSL in Codex for details.

share|improve this answer
It's not. The only place in the code where I see that is in default-constants.php. The only other thing I have noticed recently is that our database server ran out of disk space. Could that cause an issue like this? – Dave Morris Dec 1 '10 at 14:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.