ISSUE SUMMARY:
Users with an asterisk in their username can not login anymore.

STEPS TO REPLICATE:
1 Register in JomSocial community
2 Username: Test*8
3 Password: Cmh3y8

THIS PROBLEM CAN BE CHECKED IN YOUR OWN JOMSOCIAL COMMUNITY.

RESULT
Username and password do not match or you do not have an account yet.

EXPECTED RESULT
Login should work. It did before and users could register with asterisks.

BROWSER
IE, Firefox, Chrome

Looks like there is a general login problem as other users tell me and submit in this forum. It is not just special characters like * also whitespace and other allowed chars german umlauts (äöü). I think it came up after upgrading MySQL to allow emoji support. This bug seems to be huge unfortunately.

Also registered on JomSocial community with

username: Testwithspecialcharslikeä
password: testäää

Hi,

I cant reproduce this issue:

please elaborate more if I missing something.

Regards

I set up a plesk account with this website for you to use parallel and checked above again.

Login for test user
Username: Test*8
Password: test123

After upgrading it does NOT work anymore.



I only updaded JomSocial, not the tables yet. So my thought of the table update could cause this issue is not correct. It already happens after updating (also in your community jomsocial.com too).

Because of my second support cause (emoji support the tables are now upgraded but this problem came up immediately after upgrading and includes whitespaces, special chars like * and german umlauts like äöü)

Hi,

for login issue please apply this fix:
[url]
https://www.jomsocial.com/forum/installation/33242-members-can-not-connect-from-the-upgrade-to-4-2-jomsocial#160702
[/url]

Regards

Thank you. This is working. You should make this bugfix public asap because this bug is really bad.