This topic is locked

Error when reseting password - PostgreSQL

7/27/2017 3:08:05 PM
PHPRunner General questions
M
marcelorribas author

Hi,

I´m starting a new project using PostgreSQL. Everything is ok, but when I try to reset password by the "Send the Reset password link" I get the error:
======================================================

0.

connections\Connection.php:661

trigger_error

  1. ERROR: invalid input syntax for type timestamp: "" LINE 1: ...t.JnYIKJLthbowW', "reset_token3"='', "reset_date"=''where"re... ^;

    ======================================================

    1.Â

    connections\Connection.php:661

    Connection->triggerError

    1. ERROR: invalid input syntax for type timestamp: "" LINE 1: ...t.JnYIKJLthbowW', "reset_token3"='', "reset_date"=''where"re... ^;

    ======================================================

    2.Â

    connections\PostgreConnection.php:97

    PostgreConnection->query

    1. update "public"."tusr" set "pwd"='$2y$10$C74TEgfgxqazt1hPnUkVoOGZjFhs7mMeyNTFaHt.JnYIKJLthbowW', "reset_token3"='', "reset_date"=''where"reset_token3"='jasx8t2q47f8xzbyjbqp';

    ======================================================

    3.Â

    connections\PostgreConnection.php:110

    PostgreConnection->exec

    1. update "public"."tusr" set "pwd"='$2y$10$C74TEgfgxqazt1hPnUkVoOGZjFhs7mMeyNTFaHt.JnYIKJLthbowW', "reset_token3"='', "reset_date"=''where"reset_token3"='jasx8t2q47f8xzbyjbqp';

    =======================================================

    4.Â

    classes\changepwdpage.php:233

    ChangePasswordPage->changePassword

    N/A

    ========================================================

    5.Â

    classes\changepwdpage.php:298

    ChangePasswordPage->process

    N/A

    ========================================================

    6.Â

    changepwd.php:184

    Global scope N/A