pmurphy Posted October 6, 2022 Report Share Posted October 6, 2022 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 databaseDue 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 ) Quote Link to comment Share on other sites More sharing options...
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.