Jump to content

pmurphy

Approved members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

 Content Type 

Posts posted by pmurphy

  3. Error when clicking password reset hyperlink

    in For Developers

    Posted

    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

    )

     

×
×
  • Create New...