Data truncated for column 'overdue_email_sent' at row 1
Posted: Wed Apr 28, 2021 4:01 pm
Script URL:
Version of script: 3.2.2
Hosting company: own server
URL of phpinfo.php: https://justpaste.it/8d72m
URL of session_test.php: OK: PHP sessions work fine
What terms did you try when SEARCHING for a solution: Data truncated for column, Can't execute SQL
Write your message below:
I'm having this error when trying to modify the due date, if I set a due date when creating the ticket it works well.
Version of script: 3.2.2
Hosting company: own server
URL of phpinfo.php: https://justpaste.it/8d72m
URL of session_test.php: OK: PHP sessions work fine
What terms did you try when SEARCHING for a solution: Data truncated for column, Can't execute SQL
Write your message below:
I'm having this error when trying to modify the due date, if I set a due date when creating the ticket it works well.
Code: Select all
Error
Can't execute SQL: UPDATE `hesk_tickets` SET `due_date` = '2021-04-29', `overdue_email_sent`=0, `history`=CONCAT(`history`,'
2021-04-28 17:47:13 | due date updated to 2021-04-29 by John Smith(jsmith)
') WHERE `trackid`='HS2-REZ-48EQ' AND (`due_date` IS NULL OR `due_date` != '2021-04-29')
MySQL said:
Data truncated for column 'overdue_email_sent' at row 1
WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.