Thread

Hi,

I’m trying to move ExpressionEngine 1.6.4 from one server to another:

The problem is that when I go to my new server’s admin page, and put in my username/pass, I get “The username you submitted was not found in the database”.  I’ve verified that I have DB connectivity from the new server, and I can even go to the “dbtest.php” page in system/utilities/dbtest.php, put in the right values, and I get a success message when connecting to the database.

If I look at the last query executed when trying to log in, it looks like it’s not populating the site_id from $PREFS->ini(‘site_id’) properly:

SELECT exp_members.password, exp_members.unique_id, exp_members.member_id, exp_members.group_id, exp_member_groups.can_access_cp
          FROM   exp_members, exp_member_groups
          WHERE username = ‘admin_user’
          AND   exp_member_groups.site_id = ‘’
          AND   exp_members.group_id = exp_member_groups.group_id

As you can see, site_id is blank, where it should be 1.  I even tried adding $conf[‘site_id’] = “1” in my system/config.php, but that didn’t help.

Any ideas?

Just in case anyone actually reads this: If I manually set site_id = ‘1’, I can get passed the username not found error.  However, I’m just sent back to the login page, no error.  If I put in the wrong password, I get a bad password error, so I know it’s not that.

Help!

Looks like I solved it.  It was a session issue, apparently.  So I added these to my config.php file:

$conf[‘site_url’] = “http://my.site.com”;
$conf[‘theme_folder_path’] = “/var/www/mysite/themes”;
$conf[‘admin_session_type’] = “c”;
$conf[‘user_session_type’] = “c”;
$conf[‘cookie_domain’] = “.my.site.com”;
$conf[‘cookie_path’] = “”;
$conf[‘cookie_prefix’] = “mysite_”;
$conf[‘user_session_ttl’] = ‘7200000’;  // 720000 200 hours
$conf[‘cp_session_ttl’] = ‘7200000’;

I’m pretty sure it was the admin_session_type and user_session_type settings that did it.  Now, to diagnose why sessions are broken…