Bug #31537

LOGIN: Error on special characters in password

Added by Ben van 't Ende over 1 year ago. Updated about 1 year ago.

Status:Resolved Start date:2011-11-03
Priority:Must have Due date:
Assignee:Joern Bock % Done:

100%

Category:[FOR] Login
Target version:-
Votes: 0

Description

When I enter "test@#$%" as password during registration a full error page is shown in the login area with the text

"Oops, an error occured!

Unknown column 'tx_ajaxlogin_verificationHash' in 'field list': UPDATE fe_users SET name='ben van \'t ende', email='', username='test768', password='$P$CZxsOuIuGlBGK0of8eYHeCrOoWxec80', tx_ajaxlogin_verificationHash='dfbf18b877f44a82fdf68c0fd90c28fa', tx_ajaxlogin_forgotHashValid='1320311643', usergroup='1', address='', telephone='', fax='', lockToDomain='', title='', zip='', city='', country='', www='', company='', image='', lastlogin='', tstamp='1320311643' WHERE uid='62122'"

_login-error.png - nasty login error (38.4 kB) Ben van 't Ende, 2011-11-03 10:23

History

Updated by Ben van 't Ende over 1 year ago

Special characters should be allowed here. You should be able to paste a generated password from a pwd generator.

Updated by Georg Ringer over 1 year ago

this has nothing to do with special chars, a field is wrong/or missing ... so this should also not working with a password like "benbenben"

Updated by Arno Schoon over 1 year ago

  • Status changed from New to Needs Feedback
  • Assignee set to Ben van 't Ende

For some reason the database wasn't updated during the build. Strange because it's not a new field?!

Added the field to the database via EM. Should work correctly ;)

Updated by Ben van 't Ende over 1 year ago

on further experimenting it is not special characters, but any other password acts the same. it is very hard trouble-shooting this as i get errors with almost everything i do. right georg!

Updated by Felix Kopp over 1 year ago

After testing: you are now successfully logged in after successful registration.

- Registration OK: Logged in OK
- default User group (before) OK

- Verification link displayed correctly (but should be sent via email)
- default user group (after) OK

Only problem still remaining:
The verification link is not sent via email - because the email services are not working yet.

I added the before activation group – that was missing: Group ID is 21

verify-View does not exist.

Updated by Felix Kopp over 1 year ago

  • Status changed from Needs Feedback to Accepted
  • Assignee changed from Ben van 't Ende to Felix Kopp
  • Priority changed from Should have to Must have
  • % Done changed from 0 to 50

Updated by Felix Kopp over 1 year ago

Hi Ben, can you reproduce this issue?
I think we solved it few months back.

Updated by Felix Kopp about 1 year ago

  • Status changed from Accepted to Under Review
  • % Done changed from 50 to 100

I just sucessfully registered a user with the password "test@#$%" (without quotes of course).
This issue is resolved from my pov.

Updated by Joern Bock about 1 year ago

  • Category changed from 1020 to [FOR] Login

Updated by Stefan Masztalerz about 1 year ago

  • Status changed from Under Review to Resolved
  • Assignee changed from Felix Kopp to Joern Bock

Updated by Joern Bock about 1 year ago

  • Target version deleted (1197)

Also available in: Atom PDF