I changed my.ini from mysql
from
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to
sql-mode=
and restarted the service
then i deleted the old database and started an install with
/phptest/installscript
changed the admin pw
but can't login .
it says username or password incorrect
i created a new user, this works, it getting into mysql tables, but still
can't login with it .
login: tester
pw: tester .
username or password incorrect :-(
and if i set it to blank password, i can't login . login window appears
again, but no error .
Does somebody know whats wrong?
Von: Andreas Rainer [mailto:address@hidden
Gesendet: Samstag, 17. Februar 2007 23:44
An: 'address@hidden'
Betreff: Can't login to phptest ...
OS: Windows XP
Webserver: Sambar 6.4
Php 4.4.4
MySQL: 5.0.27
I copied the files to a directory called e:\intranet
->e:\intranet\phptest
installed mappings and edited config.inc.php
<?php
// database configuration variables
define('DB_HOST', 'localhost'); // hostname of database
define('DB_USERNAME', 'root'); // username of database
define('DB_PASSWORD', ''); // password of databsae
define('DEFAULT_DB', 'phptest'); // name of database to use
define('DB_TYPE', 'mysql'); // database type. Mysql is the only
supported db right now
define('DB_USE_PCONNECT', 0); // set this to 0 if your database
doesn't support persistent connections
// absolute path of your phptest installation
define('ABSOLUTE_PATH',
'https://cobragraz.gotdns.org/intranet/phptest/');
?>
created a database phptest and installed the tables with
/installscript/phptest.sql .
then i tried it .
login page appears, then as soon as i try login with
admin/123456
or
guest/guest
it says: Username or password incorrect
then i tried to register a new user
login: tester
Pw: tester
e-mail: address@hidden
and got:
There was an SQL error. The error message is:
Data too long for column 'password' at row 1
Please notify the site administrator <mailto:address@hidden> .
The SQL Query that failed is: INSERT INTO users (username, password, email,
real_name, date_joined, admin) VALUES ('tester', PASSWORD('tester'),
'address@hidden', 'tester', CURRENT_TIMESTAMP, 0)
whats wrong?
does somebody know the answer?
Other php Scripts like phpmyfaq or phpbb2 work with no problem . did i
forgot something?