PHPJunkyard support forum

Posted: **Sun May 01, 2016 2:03 pm**

Script URL: Hesk
Version of script: 2.6.7
Hosting company: Local Testing Environment WAMP Server (Apache : 2.4.17 MySQL : 5.7.9 PHP : 5.6.16 PHP : 7)
What terms did you try when SEARCHING for a solution: SQL Error, Fresh Install, invalid default

Write your message below:

During a fresh installation of Hesk I receive the following error message after "continuing to step 4" during the installation process.

Code: Select all

Error:

Can't execute SQL: ...

MySQL said:
Invalid default value for 'dt'

WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

Posted: **Sun May 01, 2016 3:02 pm**

Try uploading this file to your "install" folder and see if it works then:
http://www.phpjunkyard.com/extras/hesk2 ... o_date.zip

Posted: **Sun May 01, 2016 9:14 pm**

That did the trick! What was the issue?

Posted: **Mon May 02, 2016 7:46 am**

You are running MySQL in strict mode (with "no zero dates"), so it doesn't accept "0000-00-00" as the default date.

Posted: **Mon May 02, 2016 3:01 pm**

AH I didn't even think about MySQL being strict. I appreciate the quick response. Great product so far!

PHPJunkyard support forum

HESK Script Error - Fresh Installation

HESK Script Error - Fresh Installation

Re: HESK Script Error - Fresh Installation

Re: HESK Script Error - Fresh Installation

Re: HESK Script Error - Fresh Installation

Re: HESK Script Error - Fresh Installation