Error when clicking password reset hyperlink

[pmurphy]

Error when clicking the password reset email link. Windows Server 2019, IIS, PHP, and PostgreSQL database. Any ideas would be appreciated. The application sees to work fine otherwise.

Regards,

Paul

 

An error occurred while accessing the database

Due to a problem with the database Revive Adserver couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Revive Adserver. Please report the following information to the creators of Revive Adserver. Also try to describe the actions that led to this error as clearly as possible.

Version:	Revive Adserver v5.4.1
PHP/DB:	PHP 8.1.1 / PostgreSQL 14.5.-
Page:	/www/admin/password-recovery.php
Error:	ERROR: operator does not exist: timestamp without time zone >= character varying LINE 5: ..." = '4280AD7D-EAD7016F-E4D750E4' ) AND ( updated >= IF(LENG... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Query:	SELECT *  FROM "rv_users"  INNER JOIN "rv_password_recovery"  ON "rv_password_recovery"."user_id"="rv_users"."user_id"    WHERE ( "rv_password_recovery"."recovery_id" = '4280AD7D-EAD7016F-********' )  AND ( updated >= IF(LENGTH(password) <= 32, '2022-09-29 17:57:36', '2022-10-06 13:57:36') )
$_POST:	Empty
$_GET:	Array (     [id] => 4280AD7D-EAD7016F-E4D750E4 )

 

[pmurphy]

Is this app dead? Is there any support available at all?

Paul

[pmurphy]

Any response at all would be appreciated. Thanks.

Paul

[Matt Tews]

I am having the same issues with 5.5.

[2ge]

I have the same issue with latest Revive Adserver v5.5.2

devs: please try to reset password - it doesnt work. (so I can not set up password for users in GUI, so I have to go to DB. And are you storing password as md5() with no salt ? Well, thats more than easy to hack in miliseconds. https://crackstation.net/