Scot et.al.; I believe I am having the same strange problem. I am using web2py version 2.21.1 with python 2.7.5
I found that particular line of code tyou mentioned in web2py/gluon/tools.py about line: 3468 "if not self.settings.email_case_sensitive: table_user.email.requires.insert(0, IS_LOWER())" Is the best solution to simply enter the email address for login in lower case? Is it possible to edit that line of code in tools.py? I realize your post is 4 years old. Maybe this bug has been fixed. best, Tele Tom On Thursday, November 30, 2017 at 1:40:44 PM UTC-8 scot...@gmail.com wrote: > I think you're right. It looks like the execution hangs up in > Auth.request_reset_password at the point where the system is checking a > setting for password case sensitivity: > > if not self.settings.email_case_sensitive: > table_user.email.requires.insert(0, IS_LOWER()) > > I did a search in the current web2py book for "email_case_sensitive" and > came up empty. Is this something we're supposed to be aware of and set in > db.py? > > More importantly, if email_case_sensitive is False, the behaviour seems > wrong. What should happen is that a stored email with some uppercase > matches a submitted email regardless of the case. Instead, it's assuming > all stored email addresses are lowercase. I think what happened is that > this behaviour changed (was introduced?) in a recent update. So my old > stored email addresses were stored with some uppercase. But when I updated > to the newest version of web2py this new behaviour broke login and auth for > anyone with uppercase in their email. Or am I missing something? Setting > Auth.email_case_sensitive = True does seem to have fixed the issue. > > On Thursday, November 30, 2017 at 4:06:13 PM UTC-5, Leonel Câmara wrote: >> >> Looks like a bug due to case sensitivity, either in web2py or in the dal > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/eb35c73d-68e0-4695-af06-81ce304016a3n%40googlegroups.com.