HESK Script Error - Fresh Installation

[benoneal89]

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.

[Klemen]

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

[benoneal89]

That did the trick! What was the issue?

[Klemen]

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

[benoneal89]

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