CMS MADE SIMPLE FORGE

Frontend Users

 
Back Back to List

[#9591] Wrong database insert for users with name as email

avatar
Created By: mr. Kembl (kembl)
Date Submitted: Sun Oct 13 11:03:01 -0400 2013

Assigned To: Robert Campbell (calguy1000)
Version: 1.21.18
CMSMS Version: 1.11.9
Severity: Trivial
Resolution: Invalid
State: Closed
Summary:
Wrong database insert for users with name as email
Detailed Description:
Small problem with FrontEndUsers module when users have email as username. 

When I edit some prperty of FrontEnd user from FrontEndUsers interface, the
symbol "@" in they name became %40 in database field and user cannot login to
system

I am not too often change users details but every time needs to came in to
database and correct broken names with replace request, but this is not too good
workaround.  ;D

Code:
UPDATE `cms_module_feusers_users` SET `username` = REPLACE(`username`, '%40',
'@')

Forum post: http://forum.cmsmadesimple.org/viewtopic.php?f=7&t=60616


History

Comments
avatar 
Date: 2013-10-13 13:00
Posted By: Robert Campbell (calguy1000)

Just tested..... registered a new user account with selfreg...  and when pushed
to FEU there was an @ in the database not a %40.
Must be something unique about your setup.
avatar 
Date: 2013-10-13 13:02
Posted By: Robert Campbell (calguy1000)

Also tested changing user settings on the frontend, and in the admin.... no
issues.
avatar 
Date: 2013-10-15 07:27
Posted By: mr. Kembl (kembl)

Thank you for attention, I will check my results deeper!
Updates

Updated: 2014-04-26 12:22
state: Open => Closed

Updated: 2013-10-13 13:00
resolution_id: => 9