FUDforum: Bug Reports » member search fails in 2.7.4

Home » FUDforum Development » Bug Reports » member search fails in 2.7.4

Show: Today's Messages :: Polls :: Message Navigator

Re: member search fails in 2.7.4 [message #30610 is a reply to message #30379]

Sat, 04 March 2006 19:38

Aonmaster

Messages: 28
Registered: December 2003

Karma:

Junior Member

I found a reason.
MySQL 4.1.7, when given a query "LIKE 's%'" returned zero results.
I changed code to '%s%' and it worked.

Furthermore, I did a little code hack so that the User search would become case insensitive:
in fudforum_data/src/finduser.php.t:

if ($usr_login) {
// case sensitivity hack by MaximP
$usr_login1=strtoupper($usr_login);
$qry = 'UPPER(alias) LIKE '._esc(char_fix(htmlspecialchars(addcslashes('%'.$usr_login1.'%','\\')))).' AND';
// $qry = 'alias LIKE '._esc(char_fix(htmlspecialchars(addcslashes($usr_login.'%','\\')))).' AND';
} else {
$qry = '';
}
then don't forget to rebuild the theme.

Ilia, is it useful enough to be included into further versions?

Report message to a moderator

[Message index]

		member search fails in 2.7.4 By: Aonmaster on Sat, 18 February 2006 17:45
		Re: member search fails in 2.7.4 By: Ilia on Sun, 19 February 2006 20:55
		Re: member search fails in 2.7.4 By: Aonmaster on Mon, 20 February 2006 02:44
		Re: member search fails in 2.7.4 By: Ilia on Mon, 20 February 2006 14:42
		Re: member search fails in 2.7.4 By: Aonmaster on Mon, 20 February 2006 15:02
		Re: member search fails in 2.7.4 By: Ilia on Tue, 21 February 2006 14:41
		Re: member search fails in 2.7.4 By: Aonmaster on Sat, 04 March 2006 19:38
		Re: member search fails in 2.7.4 By: Ilia on Sun, 05 March 2006 16:57
		Re: member search fails in 2.7.4 By: Aonmaster on Sun, 05 March 2006 17:05

Previous Topic:	SD: Invalid SMTP return code: 451 See http://pobox.com/~djb/docs/smtplf.html.
Next Topic:	Collapsed/Compact/Open

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 23:02:09 GMT 2024

Total time taken to generate the page: 0.04283 seconds