Thread

I’m working on a site for a client and this is the first time I’ve experienced this problem and I’m finding it infuriating.

I’ve got a copy of the site locally, the host is all correct and the config and path files are correct as far as I can tell. The database was exported and imported locally both using phpMyAdmin.

When I attempt to login I get the following error: The username you submitted was not found in the database.

It’s in the database because I’m looking at it. I’ve spent almost 4 hours on this now and EE gives me zero clues as to what might be the problem. Nothing in the error logs.

I’ve made sure the encoding was correct on the database.
I’ve added $conf[‘admin_session_type’] = “s”; although this made no difference at all.
I’ve been through most of the other advice on the forum for this issue that I’ve found through searching and nothing has brought me closer to the simple task that is logging into the admin panel.

The client is using ExpressionEngine v 1.6.1 for the website

My config looks like this…

<?php

if ( ! defined('EXT')){
exit('Invalid file request');
}

$conf['app_version'] = "161";
$conf['license_number'] = "xxx";
$conf['debug'] = "1";
$conf['install_lock'] = "1";
$conf['db_hostname'] = "localhost";
$conf['db_username'] = "root";
$conf['db_password'] = "root";
$conf['db_name'] = "oyster_db";
$conf['db_type'] = "mysql";
$conf['db_prefix'] = "exp";
$conf['db_conntype'] = "0";
$conf['system_folder'] = "system";
$conf['cp_url'] = "http://mysite:8888/system/index.php";
$conf['doc_url'] = "http://expressionengine.com/docs/";
$conf['is_system_on'] = "y";
$conf['allow_extensions'] = "n";
$conf['multiple_sites_enabled'] = "n";
$conf['admin_session_type'] = "s";
?>

Help would be gratefully appreciated.

That is definitely curious. If you, say, temporarily drop the exp_members table altogether you do get a different error, correct? What character encoding was being used on the live site, and what is the database and its tables set to?

I dropped the members table and I still get the same ‘The username you submitted was not found in the database’ message. That’s pretty strange right?

The character encoding on the database looks like ‘latin1_swedish_ci’ with the tables a mix of ‘latin1_swedish_ci’ and ‘latin1_general_ci’.

The live server MySQL is set to use MySQL charset: UTF-8 Unicode (utf8) and running MySQL client version: 4.1.22
My local server is also set to use MySQL charset: UTF-8 Unicode (utf8) but running MySQL client version: 5.1.44

Hi, newvibes.

are you going to be upgrading this install to 1.7.0?

I could give it a try. I’m working on another site that uses 1.6.7 and it’s running perfectly locally first time. Really weird. Same transfer process but different versions. The database is similar too.

1.6.1 was a very long time ago, if you were asking for support on that particular version, I’d mention updating. 1.6.7 is also older, but closer to 1.7.0.

See if upgrading helps you out locally.