Password changing on record update

I have created user log in pages with SA. Most of it seems to be working fine. I have a problem with the update user page and the password field (MD5 encrypted). Each time I make any changes to any of the fields the password field gets updated and changed automatically. The password field is displayed as the standard black dots for password fields. Once the password is changed the user can not log in and the log in.

I have searched but can not find an answer or a solution. Please can you let me know what the problem may be?

I have the links to the pages below:

http://www.hackneyhydroponics.co.uk/admin/users_insert.php
http://www.hackneyhydroponics.co.uk/admin/users_results.php
http://www.hackneyhydroponics.co.uk/admin/users_update.php?UserID=5
http://www.hackneyhydroponics.co.uk/admin/users_detail.php?UserID=5

Many thanks in advance

What version of Data Bridge are you using? Make sure you are using the latest update 1.1.4

if you have a previous version installed, make sure to uninstall it from the extension manager before installing a new one.

Once you have version 1.1.4 installed, you should try recreating the pages.

Hi Jason, I have downloaded and installed WA 1.1.4. I un-installed the older version and restarted my PC before installing it. I have re-generated the user pages. Upload all the new pages and uploaded the entire webassist folder. I am still have the same problem. the MD5 encrypted password field changes each time I do and update.

Thanks

send a copy of the update page please.

Hi Jason, Please find attached all the user pages created.

Thanks

I see these are pages created by the Data Assist wizard, not the security assist wizard.

On the update page, make the following changes:

Edit the server validations behavior, remove the Required validation for the password and edit the EL validation for the password to allow blank entry

then edit the update record server behavior, for the password column, change the binding code froM

<?php echo ((isset($_POST["UserPassword"]))?WA_MD5Encryption($_POST["UserPassword"]):""); ?>

to:

<?php echo ((($_POST["UserPassword"] != ""))?WA_MD5Encryption($_POST["UserPassword"]):$row_WADAusers["UserPassword"]); ?>

remove the spry validation for the password field:

var UserPassword_Spry = new Spry.Widget.ValidationPassword("UserPassword_Spry", { minChars:6, isRequired:true , validateOn:["blur"]});

edit the password form element and remove the initial value.

this way, the password will only get updated if a new one is entered.