Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.6.4

Bug #8732 Login always fails without $options['db_fields'] = '*';
Submitted: 2006-09-19 09:27 UTC
From: tuupola Assigned: aashley
Status: Closed Package: Auth (version 1.3.2)
PHP Version: Irrelevant OS: Solaris 10
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 39 - 11 = ?

 
 [2006-09-19 09:27 UTC] tuupola (Mika Tuupola)
Description: ------------ Starting from version 1.3.1 login always fails if $options['db_fields'] = '*'; is not present. Earlier versions did not need that. Test script: --------------- Username: test Password: test First one is without $options['db_fields'] = '*'; and it used to work with Auth 1.3.0. Host is running 1.3.2. Thus login always fails. http://www.appelsiini.net/~tuupola/test/auth_132_a.php http://www.appelsiini.net/~tuupola/test/auth_132_a.phps http://www.appelsiini.net/~tuupola/test/auth_132_a.txt The one below is with $options['db_fields'] = '*'; Now login works again. http://www.appelsiini.net/~tuupola/test/auth_132_b.php http://www.appelsiini.net/~tuupola/test/auth_132_b.phps http://www.appelsiini.net/~tuupola/test/auth_132_b.txt Expected result: ---------------- Successfull login. Actual result: -------------- Login fails.

Comments

 [2006-09-21 01:52 UTC] aashley at php dot net (Adam Ashley)
Just confirming that your experience matches mine in that this behaviour only occurs when using an SQLite database correct? It appears to do with how sqlite returns field names: SELECT username FROM users WHERE username = 'test'; will return the following: Array ( username => 'test', ) SELECT "username" FROM "users" WHERE "username" = 'test'; will return the following: Array ( "username" => 'test', )
 [2006-09-21 02:04 UTC] aashley at php dot net (Adam Ashley)
Thank you for your bug report. This issue has been fixed in the latest released version of the package, which you can download at http://pear.php.net/get/Auth