Database Error while upgrading to HESK 2.7.1

[farrukh]

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.

[Klemen]

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?

Code: Select all

ALTER TABLE `hesk_tickets` CHANGE `dt` `dt` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00'

[farrukh]

Hi Klemen,

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

Thankx and excellent support.

Farrukh.

[smegnl]

X2 worked for me too.

Another damn fine update!!