Jump to content

Error when clicking password reset hyperlink


Recommended Posts

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.




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.


Revive Adserver v5.4.1


PHP 8.1.1 / PostgreSQL 14.5.-




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.



 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') )  






    [id] => 4280AD7D-EAD7016F-E4D750E4



Link to comment
Share on other sites

  • 3 weeks later...
  • 3 weeks later...
  • 11 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...