Index: manage_user_update.php =================================================================== --- manage_user_update.php (revision 5530) +++ manage_user_update.php (working copy) @@ -56,7 +56,7 @@ # strip extra space from real name $t_realname = preg_replace('/\s+/', ' ', $f_realname); - + user_ensure_name_valid( $f_username ); user_ensure_realname_valid( $f_realname ); user_ensure_realname_unique( $f_username, $f_realname ); @@ -66,7 +66,7 @@ email_ensure_not_disposable( $f_email ); $c_email = $f_email; - $c_username = $t_username; + $c_username = $f_username; $c_realname = $f_realname; $c_protected = db_prepare_bool( $f_protected ); $c_enabled = db_prepare_bool( $f_enabled ); Index: core/database_api.php =================================================================== --- core/database_api.php (revision 5530) +++ core/database_api.php (working copy) @@ -445,11 +445,11 @@ * @param string $p_table a valid database table name * @return int last successful insert id */ - function db_insert_id($p_table = null) { + function db_insert_id($p_table = null, $p_field = "id") { global $g_db; if ( isset($p_table) && db_is_pgsql() ) { - $query = "SELECT currval('".$p_table."_id_seq')"; + $query = "SELECT currval('".$p_table."_".$p_field."_seq')"; $result = db_query_bound( $query ); return db_result($result); } @@ -713,7 +713,26 @@ * @todo Use/Behaviour of this function should be reviewed before 1.2.0 final */ function db_prepare_bool( $p_bool ) { - return (int)(bool)$p_bool; + $t_db_type = config_get_global( 'db_type' ); + + switch( $t_db_type ) { + case 'postgres': + case 'postgres64': + case 'postgres7': + case 'pgsql': + if( $p_bool ) + { + return 'true'; + } + else + { + return 'false'; + } + break; + default: + return (int)(bool)$p_bool; + break; + } } /** Index: core/email_queue_api.php =================================================================== --- core/email_queue_api.php (revision 5530) +++ core/email_queue_api.php (working copy) @@ -91,7 +91,7 @@ )"; db_query_bound( $query, Array( $c_email, $c_subject, $c_body, db_now(), $c_metadata ) ); - return db_insert_id( $t_email_table ); + return db_insert_id( $t_email_table, "email_id" ); } # -------------------- Index: core/user_api.php =================================================================== --- core/user_api.php (revision 5530) +++ core/user_api.php (working copy) @@ -460,7 +460,7 @@ # Users are added with protected set to FALSE in order to be able to update # preferences. Now set the real value of protected. if ( $c_protected ) { - user_set_field( $t_user_id, 'protected', 1 ); + user_set_field( $t_user_id, 'protected', $c_protected ); } # Send notification email