Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: GeriX on May 23, 2006, 03:23:46 AM

Title: I cant send PMs!!! Plz Help!!!!
Post by: GeriX on May 23, 2006, 03:23:46 AM
SMF Version: SMF 1.0.7
Hi, I have a problem with sending Personal Messages. If I put a name with big capital letter, then it writes an error.
Example:

I send message to GeRiX, then it write: Unable to find member 'gerix'..

Automatically rewrites the name to small letters: GeRiX to gerix ,but gerix don't exist in memberlist.

Where can I set it?
please help me!
Title: Re: I cant send PMs!!! Plz Help!!!!
Post by: nibuk on September 23, 2006, 01:54:30 PM
Hee GeRiX,

I'm having the same problem and concluded it's because of the LIKE mysql function in the database. Although this should not be case sensitive, It seems to be depended on the creation of the table.

The Collation of the membernamefield is now latin1_bin (in which LIKE is case sensitive), this should be changed to ascii.

However if you change that, simple machines will give an database error  >:(
Title: Re: I cant send PMs!!! Plz Help!!!!
Post by: nibuk on September 23, 2006, 02:23:37 PM
haha, my PHPadmin changed the collation to latin1_swedish_ci instead back to latin1_bin. This resulted in a perfectly working PMs and member search!  ;D

And since english (or dutch) does not use that many special character, the swedish characterset will not give any problems.
Title: Re: I cant send PMs!!! Plz Help!!!!
Post by: GeriX on October 13, 2006, 04:48:58 AM
where can I that change?
Title: Re: I cant send PMs!!! Plz Help!!!!
Post by: jerm on October 13, 2006, 05:08:00 PM
In phpmyadmin.