Problems Recognizing Members-HELP Please 12/19/05

[Compuart]

Can you try this query and post its results?

Code Select Expand

SHOW CREATE TABLE smf_members

[chinathetimes]

Can you try this query and post its results?

Code Select Expand

SHOW CREATE TABLE smf_members

Host: localhost
Database: XXXX
Generation Time: Apr 27, 2006 at 07:35 PM
Generated by: phpMyAdmin 2.6.2-pl1 / MySQL 4.1.16-log
SQL query: SHOW CREATE TABLE smf_members;
Rows: 1

smf_members

CREATE TABLE `smf_members` (\n  `ID_MEMBER` mediumint(8) unsigned NOT NULL auto_increment,\n  `memberName` varchar(80) collate utf8_bin NOT NULL default '',\n  `dateRegistered` int(10) unsigned NOT NULL default '0',\n  `posts` mediumint(8) unsigned NOT NULL default '0',\n  `ID_GROUP` smallint(5) unsigned NOT NULL default '0',\n  `lngfile` tinytext collate utf8_bin NOT NULL,\n  `lastLogin` int(10) unsigned NOT NULL default '0',\n  `realName` tinytext collate utf8_bin NOT NULL,\n  `instantMessages` smallint(5) NOT NULL default '0',\n  `unreadMessages` smallint(5) NOT NULL default '0',\n  `buddy_list` tinytext collate utf8_bin NOT NULL,\n  `pm_ignore_list` tinytext collate utf8_bin NOT NULL,\n  `messageLabels` text collate utf8_bin NOT NULL,\n  `passwd` varchar(64) collate utf8_bin NOT NULL default '',\n  `emailAddress` tinytext collate utf8_bin NOT NULL,\n  `personalText` tinytext collate utf8_bin NOT NULL,\n  `gender` tinyint(4) unsigned NOT NULL default '0',\n  `birthdate` date NOT NULL default '0001-01-01',\n  `websiteTitle` tinytext collate utf8_bin NOT NULL,\n  `websiteUrl` tinytext collate utf8_bin NOT NULL,\n  `location` tinytext collate utf8_bin NOT NULL,\n  `ICQ` tinytext collate utf8_bin NOT NULL,\n  `AIM` varchar(16) collate utf8_bin NOT NULL default '',\n  `YIM` varchar(32) collate utf8_bin NOT NULL default '',\n  `MSN` tinytext collate utf8_bin NOT NULL,\n  `hideEmail` tinyint(4) NOT NULL default '0',\n  `showOnline` tinyint(4) NOT NULL default '1',\n  `timeFormat` varchar(80) collate utf8_bin NOT NULL default '',\n  `signature` text collate utf8_bin NOT NULL,\n  `timeOffset` float NOT NULL default '0',\n  `avatar` tinytext collate utf8_bin NOT NULL,\n  `pm_email_notify` tinyint(4) NOT NULL default '0',\n  `karmaBad` smallint(5) unsigned NOT NULL default '0',\n  `karmaGood` smallint(5) unsigned NOT NULL default '0',\n  `usertitle` tinytext collate utf8_bin NOT NULL,\n  `notifyAnnouncements` tinyint(4) NOT NULL default '1',\n  `notifyOnce` tinyint(4) NOT NULL default '1',\n  `notifySendBody` tinyint(4) NOT NULL default '0',\n  `notifyTypes` tinyint(4) NOT NULL default '2',\n  `memberIP` tinytext collate utf8_bin NOT NULL,\n  `secretQuestion` tinytext collate utf8_bin NOT NULL,\n  `secretAnswer` varchar(64) collate utf8_bin NOT NULL default '',\n  `ID_THEME` tinyint(4) unsigned NOT NULL default '0',\n  `is_activated` tinyint(3) unsigned NOT NULL default '1',\n  `validation_code` varchar(10) collate utf8_bin NOT NULL default '',\n  `ID_MSG_LAST_VISIT` int(10) unsigned NOT NULL default '0',\n  `additionalGroups` tinytext collate utf8_bin NOT NULL,\n  `smileySet` varchar(48) collate utf8_bin NOT NULL default '',\n  `ID_POST_GROUP` smallint(5) unsigned NOT NULL default '0',\n  `totalTimeLoggedIn` int(10) unsigned NOT NULL default '0',\n  `passwordSalt` varchar(5) collate utf8_bin NOT NULL default '',\n  PRIMARY KEY  (`ID_MEMBER`),\n  KEY `memberName` (`memberName`(30)),\n  KEY `dateRegistered` (`dateRegistered`),\n  KEY `ID_GROUP` (`ID_GROUP`),\n  KEY `birthdate` (`birthdate`),\n  KEY `posts` (`posts`),\n  KEY `lastLogin` (`lastLogin`),\n  KEY `lngfile` (`lngfile`(30)),\n  KEY `ID_POST_GROUP` (`ID_POST_GROUP`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin

   

[Compuart]

Just as I expected. The utf8_bin collation will compare any text string in a binary way (and therefor case sensitive).

In order to resolve this, you could either replace:

Code (Subs-Auth.php) Select Expand

WHERE (memberName LIKE '" . implode("' OR memberName LIKE '", $names) . "'
OR realName LIKE '" . implode("' OR realName LIKE '", $names) . "'$email_condition)" : "
WHERE (memberName IN ('" . implode("', '", $names) . "')
OR realName IN ('" . implode("', '", $names) . "')$email_condition)") .
by:

Code Select Expand

WHERE (LOWER(memberName) LIKE '" . implode("' OR LOWER(memberName) LIKE '", $names) . "'
OR LOWER(realName) LIKE '" . implode("' OR LOWER(realName) LIKE '", $names) . "'$email_condition)" : "
WHERE (LOWER(memberName) IN ('" . implode("', '", $names) . "')
OR LOWER(realName) IN ('" . implode("', '", $names) . "')$email_condition)") .


or, change the collation of the members table:

Code Select Expand

ALTER TABLE smf_members
CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

[chinathetimes]

Compuart,

You're not a 'Hero' member.

You're a GOD!!!!

The one bug that has plagued me for months is GONE!!!

I used the 'alter' command in the database by the way.

I owe you a beer next time you're in town.  <--- Well, there is no handshake.

[massillon]

All better, moved from a local hosting company to 1and1 and everything works fine!  Thanks TGO, for all the hard work!

[Oran]

Gosh, I have same problem, but I don't have in my subs-auth.php line which you specified (it's bit different).

I attached my subs-auth.php with little modifications - from this topic

and the second attachement is 'clean'.

I hope you can help me, also there I attached smf_members in HTML.


EDIT:

If you cant help me maybe there is some mod to allow only lowcase letters on registration?

EDIT2:

If someone know which function is responsible for lower casing user names - please tell me which!!!

I am 99% sure if I remove it, all will be fine.

[Sarge]

Now, this topic is more than a year old and a lot of things have changed since then.

SMF version?

What are the charsets and collations for the forum database and the smf_members table? You can find this in phpMyAdmin -- select your forum database and click on the Operations link on the top right side; the current collation should be listed for the Collation field. Same with the smf_members table.