I installed all files as directed by readme.html. I inserted the correct info into the database. When I go to login.html and enter admin as the username and admin as the password I get the page "NOT AUTHORIZED". Any ideas as to why this could be happening?
Jon Slack - 2007-11-28 16:46:19 - In reply to message 1 from thatsme
It's because the script doesn't correctly add the default user. The errors are in the INSERT INTO line in the setup script. There are two errors as far as I can see:
1. The table (myuser) requires date in the 'lastLog' field. This is not provided by the script (an empty string is used).
2. The setup script does not encrypt the default 'admin' password, but the script checking login details assumes it is.
To fix this, I ran a temp.php script:
$pword = "admin";
$encrypted = md5($pword);
$sql = "UPDATE myuser SET userPass = '" . $encrypted . "' WHERE userName = 'admin'";
$db->query($sql); // As you can see, I use JV's ez_mysql class.
To sort the date, I replaced the '' in the setup script for the INSERT line with NOW().