#9 Having Trouble with new users

[Timothy]

When I create a new employee I have to leave the
password blank for them to be able to log in. If I go in
as the employee (with the balnk password) and change
the password I get "Login incorrect". I am going to drill
down into this a bit but if anyone has seen this behavior
help would be apreciated..

[Nobody/Anonymous]

Logged In: NO

Also having the same problem. It only occured after
upgrading from MySQL 3.23 to 4.1. If you look at the
SimpleAssets's Employees table, you will notice that when you
set a password on a new user, the password hashing used is
different. If you find a solution, can you post the fix here or
send to alan.johnson@rmb.co.za

[Nobody/Anonymous]

Logged In: NO

Seems the MySQL "password" function is generating longer
passwords than the lenght of the UserPass field.

Change the length of the column in the DB to fix this.
I did:

ALTER TABLE Employees CHANGE UserPass UserPass varchar(60);