Fixed. Duplicate of #1428, but this has better analysis.

This patch should fix this issue.  $userid was not being correctly set 
from the form field when $conf['user']['change'] == true

In passwd/config/backends.php:



$backends['sql'] = array (

     'name' => 'Horde Authentication',

     'preferred' => '',

     'password policy' => array(

         'minLength' => 3,

         'maxLength' => 8,

         'maxSpace' => 0,

         'minUpper' => 0,

         'minLower' => 1,

         'minNumeric' => 1,

         'minSymbols' => 0

     ),

     'driver' => 'sql',

     'params' => array(

         'phptype'    => 'mysql',

         'hostspec'   => 'localhost',

         'username'   => 'horde',

         'password'   => 'real_password',

         'encryption' => 'md5-hex',

         'database'   => 'horde',

         'table'      => 'horde_users',

         'user_col'   => 'user_uid',

         'pass_col'   => 'user_pass',

         'show_encryption' => false

     )

);



Log:



Feb 08 13:19:17 HORDE [debug] [passwd] SQL Query by 
Passwd_Driver_sql::_lookup(): SELECT user_pass FROM horde_users WHERE 
user_uid = NULL [on line 103 of 
"/home/www/html/horde/passwd/lib/Driver/sql.php"]



To clarify, the error I get is 'User not found' - the username is 
typed into the username field. ..again, if I select not to allow the 
username field to show, this works fine.

Please provide the configuration for your backend and the complete 
error message from the log (without the password).

I'm using sql backend for horde authentication.  When I try to change 
password using  the passwd module I get a  a DB Error: Syntax error.   
The logs show that the sql statement is using a 'null' value for 
user_id no matter what is typed into the username field.  If I change 
the config so that the username field is not visible it works fine.