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().