Problems Recognizing Members-HELP Please 12/19/05

[the_growling_one]

I have found that if I can change the display name to all lower case, it does allow me and all members to PM flawlessly. That seems like a hassle though. There must be something that causes this.

[Grudge]

How very odd, we must look into this.

[the_growling_one]

Thanks. Keep me updated. I really appreciate it.

[devic]

same problem here  any ideas?
another strange thing, and i think the problems are related, is that i can register the username 'DEVIC' when already exists one 'devic' and this is not good 

[JayBachatero]

What version of PHP and MySQL are you using?  Go to Admin > Support and Credits.  It tells you there.  Copy all of that information and post it.

@the_growling_one did you upgrade to RC2?

-JayBachatero

[devic]

Current SMF version: SMF 1.1 RC2
PHP version: 4.3.11
MySQL version: 4.1.13-standard-log

[the_growling_one]

What version of PHP and MySQL are you using?  Go to Admin > Support and Credits.  It tells you there.  Copy all of that information and post it.

@the_growling_one did you upgrade to RC2?

-JayBachatero

Haven't yet upgraded to RC2. Do you think that might help?

[Grudge]

OK, I think it's an MySQL funny, but can you try this. Open Subs-Auth.php and find:

Code Select Expand


// Nothing found yet.
$results = array();

// This ensures you can't search someones email address if you can't see it.
$email_condition = $user_info['is_admin'] || empty($modSettings['allow_hideEmail']) ? '' : 'hideEmail = 0 AND ';

if ($use_wildcards && $maybe_email)
$email_condition = "
OR (" . $email_condition . "emailAddress LIKE '" . implode("') OR ($email_condition emailAddress LIKE '", $names) . "')";
elseif ($maybe_email)
$email_condition = "
OR (" . $email_condition . "emailAddress IN ('" . implode("', '", $names) . "'))";
else
$email_condition = '';

// Search by username, display name, and email address.
$request = db_query("
SELECT ID_MEMBER, memberName, realName, emailAddress, hideEmail
FROM {$db_prefix}members" . ($use_wildcards ? "
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)") .
($buddies_only ? 'AND ID_MEMBER IN (' . implode(', ', $user_info['buddies']) . ')' : '') . "
AND is_activated IN (1, 11)" . ($max == null ? '' : "
LIMIT " . (int) $max), __FILE__, __LINE__);


and replace with:

Code Select Expand


// What are we using to compare?
$comparison = $use_wildcards ? 'LIKE' : '=';

// Nothing found yet.
$results = array();

// This ensures you can't search someones email address if you can't see it.
$email_condition = $user_info['is_admin'] || empty($modSettings['allow_hideEmail']) ? '' : 'hideEmail = 0 AND ';

if ($use_wildcards || $maybe_email)
$email_condition = "
OR (" . $email_condition . "emailAddress $comparison '" . implode("') OR ($email_condition emailAddress $comparison '", $names) . "')";
else
$email_condition = '';

// Search by username, display name, and email address.
$request = db_query("
SELECT ID_MEMBER, memberName, realName, emailAddress, hideEmail
FROM {$db_prefix}members
WHERE (memberName $comparison '" . implode("' OR memberName $comparison '", $names) . "'
OR realName $comparison '" . implode("' OR realName $comparison '", $names) . "'$email_condition)
" . ($buddies_only ? 'AND ID_MEMBER IN (' . implode(', ', $user_info['buddies']) . ')' : '') . "
AND is_activated IN (1, 11)" . ($max == null ? '' : "
LIMIT " . (int) $max), __FILE__, __LINE__);


and let me know if it works?

[devic]

and let me know if it works?

no :\

[chinathetimes]

Did anyone find a solution to this???

I am in the same boat here.

Is the problem with migrating users from Joomla to SMF with Oristo's bridge?

Joomla allows upper case.

[chinathetimes]

OK, I think it's an MySQL funny, but can you try this. Open Subs-Auth.php and find:

Code Select Expand


// Nothing found yet.
$results = array();

// This ensures you can't search someones email address if you can't see it.
$email_condition = $user_info['is_admin'] || empty($modSettings['allow_hideEmail']) ? '' : 'hideEmail = 0 AND ';

if ($use_wildcards && $maybe_email)
$email_condition = "
OR (" . $email_condition . "emailAddress LIKE '" . implode("') OR ($email_condition emailAddress LIKE '", $names) . "')";
elseif ($maybe_email)
$email_condition = "
OR (" . $email_condition . "emailAddress IN ('" . implode("', '", $names) . "'))";
else
$email_condition = '';

// Search by username, display name, and email address.
$request = db_query("
SELECT ID_MEMBER, memberName, realName, emailAddress, hideEmail
FROM {$db_prefix}members" . ($use_wildcards ? "
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)") .
($buddies_only ? 'AND ID_MEMBER IN (' . implode(', ', $user_info['buddies']) . ')' : '') . "
AND is_activated IN (1, 11)" . ($max == null ? '' : "
LIMIT " . (int) $max), __FILE__, __LINE__);


and replace with:

Code Select Expand


// What are we using to compare?
$comparison = $use_wildcards ? 'LIKE' : '=';

// Nothing found yet.
$results = array();

// This ensures you can't search someones email address if you can't see it.
$email_condition = $user_info['is_admin'] || empty($modSettings['allow_hideEmail']) ? '' : 'hideEmail = 0 AND ';

if ($use_wildcards || $maybe_email)
$email_condition = "
OR (" . $email_condition . "emailAddress $comparison '" . implode("') OR ($email_condition emailAddress $comparison '", $names) . "')";
else
$email_condition = '';

// Search by username, display name, and email address.
$request = db_query("
SELECT ID_MEMBER, memberName, realName, emailAddress, hideEmail
FROM {$db_prefix}members
WHERE (memberName $comparison '" . implode("' OR memberName $comparison '", $names) . "'
OR realName $comparison '" . implode("' OR realName $comparison '", $names) . "'$email_condition)
" . ($buddies_only ? 'AND ID_MEMBER IN (' . implode(', ', $user_info['buddies']) . ')' : '') . "
AND is_activated IN (1, 11)" . ($max == null ? '' : "
LIMIT " . (int) $max), __FILE__, __LINE__);


and let me know if it works?

I tried this and the other suggested mod and found that the User Search now works (ie. Find Members beside the 'To:' box) however the PM function still reduces all letters in the User name to lower case rendering it useless.

[chinathetimes]

Anybody ... Anybody ... Beuler .... ?

Was this solved???

[chinathetimes]

I'd swear I just heard crickets chirping.

After 4 re-installs of SMF, this is still happening.

Obviously, it has happened before since I didn't create this thread.

All I want to know is if this has a solution ... It's like reading a good book and finding the last page missing.

[JayBachatero]

This seems to be a hosting issue.  I will try to get a Dev to take a look into this one more time.  Sorry for the inconvenience.

[chinathetimes]

This seems to be a hosting issue.  I will try to get a Dev to take a look into this one more time.  Sorry for the inconvenience.

Thanks Jay.

I know you guys are run off your feet with us idiots.

We appreciate any help you give us.

It's a bit scarey actually when I found myself offering up answers on this forum rather than asking questions.

It is all a plot, isn't it ... make us hang around a long time until we can releive your burden!!!!

Well, it won't work.

We see throught your evil ways!!!!

[ahem]

um ... sorry.

I guess I've been in China past my sell by date. 

[Compuart]

It is all a plot, isn't it ... make us hang around a long time until we can releive your burden!!!!

Yep, you got us there. So... when will you have solved all our bugs? Well??

Instead of Grudge's change, you could try replacing:

Code (Subs-Auth.php) Select Expand

function findMembers($names, $use_wildcards = false, $buddies_only = false, $max = null)
by:

Code Select Expand

function findMembers($names, $use_wildcards = true, $buddies_only = false, $max = null)

Let me know if it works.

[chinathetimes]

Then I will go and start regular attendance at the 'Party' meetings.

Nope ... didn't work.

So I don't have to blow the dust off my Little Red Book quite yet.

[chinathetimes]

Just so you know:

Code Select Expand


PHP built On:    FreeBSD pro26.abac.com 5.4-STABLE FreeBSD 5.4-STABLE #0: Mon Dec 12 12:43:07 PST 2005 [email protected]:/var/obj/usr/src/sys/PRO i386
Database Version: 4.1.16-log
PHP Version: 4.4.2
Web Server: Apache/1.3.34 (Unix) mod_fastcgi/2.4.2 FrontPage/5.0.2.2635 mod_jk/1.2.15
WebServer to PHP interface: cgi-fcgi
Joomla! Version: Joomla! 1.0.8 Stable [ Sunshade ] 26-Feb-2006 05:00 UTC
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2
Relevant PHP Settings:
Safe Mode: OFF
Open basedir: none
Display Errors: ON
Short Open Tags: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: OFF
Output Buffering: OFF
Session save path: /tmp
Session auto start: 0
XML enabled: Yes
Zlib enabled: Yes
Disabled Functions: none
WYSIWYG Editor: No WYSIWYG Editor
Configuration File: <?php
$mosConfig_MetaAuthor = '1';
$mosConfig_MetaDesc = 'China\'s expat news source. Regularly updated listings of news and tourist sites effecting the resident, traveler and visitor to China. Classified ads. Chat. Forums. Travel Information.';
$mosConfig_MetaKeys = 'China News, Chinese News, China, capital, Beijing, People\'s Republic of China, PRC, P.R.C., Zhong Guo, Zhonghua Renmin Gongheguo, ch, .ch, cn, .cn, Chinese, Asia, Sino, sinology, China Weblog';
$mosConfig_MetaTitle = '1';
$mosConfig_absolute_path = '/home/u1/XXXX/html';
$mosConfig_allowUserRegistration = '1';
$mosConfig_back_button = '1';
$mosConfig_cachepath = '/home/u1/XXXX/html/cache';
$mosConfig_cachetime = '900';
$mosConfig_caching = '0';
$mosConfig_db = 'xxxxxx'
$mosConfig_dbprefix = 'jos_';
$mosConfig_debug = '0';
$mosConfig_dirperms = '';
$mosConfig_editor = 'tinymce';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_enable_stats = '1';
$mosConfig_error_message = 'This site is temporarily unavailable.
Please notify the System Administrator';
$mosConfig_error_reporting = '-1';
$mosConfig_favicon = 'favicon.ico';
$mosConfig_fileperms = '';
$mosConfig_fromname = 'China the Times';
$mosConfig_gzip = '0';
$mosConfig_helpurl = 'http://help.joomla.org';
$mosConfig_hideAuthor = '0';
$mosConfig_hideCreateDate = '0';
$mosConfig_hideEmail = '0';
$mosConfig_hideModifyDate = '0';
$mosConfig_hidePdf = '0';
$mosConfig_hidePrint = '0';
$mosConfig_hits = '1';
$mosConfig_host = 'xxxxxx'
$mosConfig_icons = '1';
$mosConfig_item_navigation = '1';
$mosConfig_lang = 'english';
$mosConfig_lifetime = '900';
$mosConfig_link_titles = '1';
$mosConfig_list_limit = '30';
$mosConfig_live_site = 'http://www.chinathetimes.com';
$mosConfig_locale = 'en_GB';
$mosConfig_mailer = 'mail';
$mosConfig_mailfrom = 'admin at spamsucks.com';
$mosConfig_ml_support = '0';
$mosConfig_multipage_toc = '1';
$mosConfig_offline = '0';
$mosConfig_offline_message = 'This site is down for maintenance.
Please check back again soon.';
$mosConfig_offset = '15';
$mosConfig_offset_user = '8';
$mosConfig_pagetitles = '1';
$mosConfig_password = 'xxxxxx'
$mosConfig_readmore = '1';
$mosConfig_secret = 'it is a secret';
$mosConfig_sef = '0';
$mosConfig_sendmail = '/usr/sbin/sendmail';
$mosConfig_session_life_admin = '30000';
$mosConfig_session_type = '0';
$mosConfig_shownoauth = '0';
$mosConfig_sitename = 'China the Times';
$mosConfig_smtpauth = '0';
$mosConfig_smtphost = 'localhost';
$mosConfig_smtppass = '';
$mosConfig_smtpuser = '';
$mosConfig_uniquemail = '1';
$mosConfig_user = 'xxxxxx'
$mosConfig_user = 'xxxxxx'
$mosConfig_vote = '1';
setlocale (LC_TIME, $mosConfig_locale);
?>

[Compuart]

you wouldn't happen to have a UTF-8 formatted database and/or member table, would ya?

[chinathetimes]

you wouldn't happen to have a UTF-8 formatted database and/or member table, would ya?

Oristo's bridge ... Just might do that. I'll look.