error after login

[bahadori.embi]

hi,

after upgrade to v6.3.1

when client want to login this error showing :

 

Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0' for column 'pwresetexpiry' at row 1 (SQL: update `tblclients` set `lastlogin` = 20160712054856, `ip` = 5.120.103.168, `host` = 5.120.103.168, `updated_at` = 2016-07-12 05:49:01, `pwresetexpiry` = 0 where `id` = 2) (SQL: update `tblclients` set `lastlogin` = 20160712054856, `ip` = 5.120.103.168, `host` = 5.120.103.168, `updated_at` = 2016-07-12 05:49:01, `pwresetexpiry` = 0 where `id` = 2)' in /home/username/domains/domain.com/public_htmlclient/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #1 {main} thrown in /home/username/domains/domain.com/public_html/client/includes/classes/WHMCS/Terminus.php on line 0

 

how to resolve this ?

[twhiting9275]

Make sure your system is not running MySQL in strict mode. I've seen this happen when it is.

can you add users, is ecerything else working?

[bahadori.embi]

thank for your answer,

im running the following query

SET @@global.sql_mode= "";

and problem resolved

[ramakrishnach21]

thank for your answer,

im running the following query

SET @@global.sql_mode= "";

and problem resolved

 

Hi, Exact same problem. Can you let me know where should I add the above code? in .htacess file or php.ini

[twhiting9275]

That's a mysql configuration change , needs to be made in /etc/my.cnf

[safeer hotels]

Hi Good Morning,

 

Unfortunately, after i logedin in our hosting client area login, i received the following error

 

 

Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0' for column 'pwresetexpiry' at row 1 (SQL: update `tblclients` set `lastlogin` = 20170504075958, `updated_at` = 2017-05-04 07:59:58, `pwresetexpiry` = 0 where `id` = 1029) (SQL: update `tblclients` set `lastlogin` = 20170504075958, `updated_at` = 2017-05-04 07:59:58, `pwresetexpiry` = 0 where `id` = 1029)' in /home/goodealh/public_html/order/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #1 {main} thrown in /home/goodealh/public_html/order/includes/classes/WHMCS/Terminus.php on line 0

 

Please advise me, is this what type of error? and how to rectify.

 

thanks in advance.

[WHMCS John]

Hi,

This suggests a problem with the structure of the tblclients table in your database, specifically the tblclients.lastlogin field.

Changing the field type to datetime should correct this error.

 

You can make this edit using a tool such as phpmyadmin.

[safeer hotels]

Thanks for the reply

 

Actually iam one of the client, our mail and website are hosted with https://www.goodealhosting.cn/

 

Am trying to login with my credentials in https://www.goodealhosting.cn/, after that i receive this error

 

Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0' for column 'pwresetexpiry' at row 1 (SQL: update `tblclients` set `lastlogin` = 20170507044346, `updated_at` = 2017-05-07 04:43:46, `pwresetexpiry` = 0 where `id` = 1029) (SQL: update `tblclients` set `lastlogin` = 20170507044346, `updated_at` = 2017-05-07 04:43:46, `pwresetexpiry` = 0 where `id` = 1029)' in /home/goodealh/public_html/order/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #1 {main} thrown in /home/goodealh/public_html/order/includes/classes/WHMCS/Terminus.php on line 0

 

kindly clarify..

 

this problem in hosting company ?

 

Thanks in advance

[safeer hotels]

Dear John,

 

Thanks for your reply.

 

we don't have tblclients table in phpmyadmin, actually

 

We are one of the client in https://www.goodealhosting.cn/

 

i tried to login with our credentials in https://www.goodealhosting.cn/ in client area, then i receive the fatal error which i posted earlier.

 

is this error in our hosting company website?

 

Kindly clarify this

 

Thanks in Advance.