Continuous Password Change Request After Upgrade - 4.12.4

[barry]

Hi Admin,

We upgraded from Cyclos 4.12.3 to 4.12.4 and we can't login as Cyclos keeps requesting password change.
You change and the request comes again.

This is affecting all users on the platform.

Kindly assist us.

Barry

[alexandre]

Hi,

Seems that you have an invalid setting for the password expiration.
Run this at you database to fix the problem:

update password_types set expires_after_amount = 1, expires_after_field = 'YEARS' where expires_after_amount = 0;

regards

[barry]

Hi Admin,

I tried changing password on the mobile app and I got the error below.

The main channel, however, does not give no error message.

Thanks,
Barry

[barry]

Hi Admin,

We have done that,see below:

'Database (not the real name)=# update password_types set expires_after_amount = 10, expires_after_field='YEARS' where id=1;
UPDATE 1'

Yet I am getting the same error.

Kindly assist us.

Barry

[barry]

Hi Admin,

The script worked!

Thank you so much!

Barry