MySQL Errors

[AffordableDomainsCanada]

I recently purchased a new dedicated server in which I manage, I am new to this and trying my best to manage this server myself, I installed WHMCS and I keep getting these errors. Any ideas why ?

 

Fatal  error: Uncaught exception 'Illuminate\Database\QueryException' with  message 'SQLSTATE[HY000]: General error: 1364 Field 'description'  doesn't have a default value (SQL: insert into tblproducts (type, gid, name, paytype, showdomainoptions, order, updated_at, created_at) values (hostingaccount, 11, vfd, free, 1, 4, 2016-07-07 22:20:36, 2016-07-07 22:20:36)) (SQL: insert into tblproducts (type, gid, name, paytype, showdomainoptions, order, updated_at, created_at)  values (hostingaccount, 11, vfd, free, 1, 4, 2016-07-07 22:20:36,  2016-07-07 22:20:36))' in  /home/jafforda/public_html/includes/classes/WHMCS/Terminus.php:0 Stack  trace: #0 [internal function]:  WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException))  #1 {main} thrown in  /home/jafforda/public_html/includes/classes/WHMCS/Terminus.php on line 0

 

I have had a few other errors just like this around my site since the server move.. ive just been disabling the modules until I get these fixed.

[brian!]

is mysql strict mode enabled ? if so, disable it.

[twhiting9275]

Yeah, this is likely to be an indication of MySQL strict mode being on, as Brian mentioned

 

Here's a quick guide to disabling this, though I would strongly recommend having your server admin do this. Playing with things you don't know can screw up your system.

Edited July 9, 2016 by twhiting9275