6.0.0-beta1
9/24/25

[#1334] Unable to reset user passwords using user administration
Summary Unable to reset user passwords using user administration
Queue Horde Base
Queue Version HEAD
Type Bug
State Resolved
Priority 1. Low
Owners eraserhd (at)
Requester mrubinsk (at) horde (dot) org
Created 02/08/2005 (7533 days ago)
Due
Updated 02/28/2005 (7513 days ago)
Assigned 02/27/2005 (7514 days ago)
Resolved 02/28/2005 (7513 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
02/28/2005 02:19:35 PM Jan Schneider Comment #5
State ⇒ Resolved
Reply to this comment
Looks good, committed.
02/27/2005 05:16:56 PM mike (at) theupstairsroom (dot) com Comment #4
New Attachment: Auth_sql[1].patch Download
Reply to this comment
Ok.  How about this patch?  If no password expiration is setup, then 
$tuple was something like this:



Array([user_uid] => 'username' [user_pass] => 'password' [] => )



So,  Horde_SQL::updateValues() was returning a " = NULL "  for that 
third element, causing the SQL error.



Now check for existence of 'soft_expiration_field' before setting the 
$tuple element to Null.



(Also added the __FILE__ and __LINE__ params to the log call)
02/27/2005 03:50:32 AM Chuck Hagenbuch Comment #3
State ⇒ Feedback
Reply to this comment
Your patch makes it impossible to change an existing expiration date 
to "no expiration". I've added code to log any errors in that 
function, and I've made some changes to Horde_SQL::updateValues() that 
might fix things for you - let me know what you see now.
02/12/2005 03:51:14 AM Michael Rubinsky Comment #2
New Attachment: Auth_sql.patch Download
Reply to this comment
I believe this patch will take care of the issue.   When the backend 
is not using password expiration, I don't see any reason why we would 
have to set  these values to null instead of just leaving them unset.   
I'm not very familiar with the Auth code though, so please correct me 
if I'm wrong...
02/08/2005 06:13:34 PM Jan Schneider Assigned to eraserhd
State ⇒ Assigned
 
02/08/2005 06:06:33 PM Michael Rubinsky Comment #1
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Unable to reset user passwords using user administration
Queue ⇒ Horde Base
Reply to this comment
Resetting / changing passwords fails under user administration with a 
DB Error: Syntax error.   I'm using mysql for authentication.  I can't 
find any log messages in the log that are coming from the 
attempt...This works fine in the FRAMEWORK_3 branch for me though.

Saved Queries