I have suceessfuly install a invo sample application in my computer. But sadly It DOES NOT runs properly as the Use model can not find any data although there is really a in my MySQL database.
As a debug way,I record all sql statement executed in MySQL.
/usr/local/mysql/bin/mysqld, Version: 5.5.28-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
130414 9:05:33 1 Connect [email protected] on invo
1 Prepare SELECT IF(COUNT()>0, 1 , 0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='users'
1 Execute SELECT IF(COUNT()>0, 1 , 0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='users'
1 Close stmt
1 Prepare DESCRIBE users
1 Execute DESCRIBE users
1 Close stmt
1 Prepare SELECT users.id, users.username, users.password, users.name, users.email, users.created_at, users.active FROM users WHERE users.email = '[email protected]' AND users.password = 'c0bd96dc7ea4ec56741a4e07f6ce98012814d853' AND users.active = 'Y' LIMIT 1
1 Execute SELECT users.id, users.username, users.password, users.name, users.email, users.created_at, users.active FROM users WHERE users.email = '[email protected]' AND users.password = 'c0bd96dc7ea4ec56741a4e07f6ce98012814d853' AND users.active = 'Y' LIMIT 1
1 Close stmt
1 Prepare SELECT users.id, users.username, users.password, users.name, users.email, users.created_at, users.active FROM users WHERE users.username = '[email protected]' AND users.password = 'c0bd96dc7ea4ec56741a4e07f6ce98012814d853' AND users.active = 'Y' LIMIT 1
1 Execute SELECT users.id, users.username, users.password, users.name, users.email, users.created_at, users.active FROM users WHERE users.username = '[email protected]' AND users.password = 'c0bd96dc7ea4ec56741a4e07f6ce98012814d853' AND users.active = 'Y' LIMIT 1
1 Close stmt
1 Quit
130414 9:06:17 2 Connect [email protected] on
2 Query select @@version_comment limit 1
/usr/local/mysql/bin/mysqld, Version: 5.5.28-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
130414 9:05:33 1 Connect [email protected] on invo
1 Prepare SELECT IF(COUNT()>0, 1 , 0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='users'
1 Execute SELECT IF(COUNT()>0, 1 , 0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='users'
1 Close stmt
============================================
When I visut the https://www.invo.com/session/index(my virtual host) and click the Login button,there is always a banner with "Wrong email/password"..
I find the following statement always return false. $user = Users::findFirst("email='$email' AND password='$password' AND active='Y'");
What is the matter? Is there anyone can help me?? Thank you!!
