Topic: Can't register after switching to UTF-8
I get an error from this line:
// Check that the username (or a too similar username) is not already registered $result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE UPPER(username) = UPPER(\''.$db->escape($username).'\') OR UPPER(username) = UPPER(\''.$db->escape(preg_replace('/[^\w]/', '', $username)).'\')') or error('Unable to fetch user info ///02', __FILE__, __LINE__, $db->error());
I've changed everything to UTF-8 in MySQL, and I've added this to common_db.php:
$db->query("SET NAMES 'UTF8'");
I haven't had any other problems (or changes) since switching.
Edit: If I comment out this line, then I can register successfully.