Bug #4120

Error in query for getUsers('auth') Function

Details

Submitted	2005-04-11 19:00 UTC
From	benpjohnson at gmail dot com
Status	Bogus
Package	LiveUser_Admin
PHP Version	5.0.3
OS	Windows XP
Roadmaps	(Not assigned)

Comments

[2005-04-11 19:00 UTC] benpjohnson at gmail dot com

Description:
------------
version: 0.2.1

The getUsers() function produces a query error when working with the auth container

Reproduce code:
---------------
$user = $admin->getUsers('auth',array('handle' => $handle), true);

Expected result:
----------------
false or user information

Actual result:
--------------
DB Error: syntax error

SELECT
auth_user_id AS auth_user_id,
email AS handle,
passwd AS passwd
,last_login AS lastlogin,is_active AS is_active
FROM
login_users WHERE bb'b' [nativecode=1064 ** You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''b'' at line 7]