Technote Details :: I cannot login although the password is correct

After creating an account, when I enter the exact same password in the login form I get a wrong password message and can't login. This happens for every account, with or without password encryption.

This happens because the field used to store the password is of type char or ntext (if using Microsoft SQL Server). These data types have a variable length which must be set by the developer. When a value smaller than this length is entered in the database, the remaining characters are filled with spaces. This means that in fact, the password stored in the database is not the same with the one entered in the form. Thus, it cannot be correctly recognized by our Transaction Engine.

To solve this issue you must change the field type from char or ntext to varchar. Varchar fields accept as parameter the maximum accepted length, but do not allocate space for more than what is actually entered. This way, the passwords will be correctly recognized.

Login to add a new note