PHPJunkyard support forum

Script URL:
Version of script: 2.7.1
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

I am upgrading HESK from veriosn 2.6.8 to 2.7.1 and getting following error:

Error:

Can't execute SQL: ALTER TABLE `hesk_tickets` CHANGE `closedby` `closedby` MEDIUMINT(8) NULL DEFAULT NULL
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.

I have tried to copy source files and repeated the installation process again but stuck at same error.

Help is required here.

Farrukh.

Can you try manually executing this SQL code (for example in phpMyAdmin or via SSH) and see if that fixes your issue and you can run the update then?

Hi Klemen,

This is perfect. The issue solved. Upgrade went smooth after manually executing the SQL.

Thankx and excellent support.

Farrukh.

X2 worked for me too.

Another damn fine update!!