Helpdezk 1.1.8 error while manual installation on MYSQL 5.7
prbt2016 opened this issue · 8 comments
Describe the bug
I was in the process of manual installation of Helpdezk 1.1.8 on Centos 6.9 with PHP 7.0, MYSQL 5.7, Apache 2.2.
However on the final step of installation i.e Step 7 i get the following error i.e :
mysql error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'dtend' at row 1
INSERT INTO bbd_tbmessage VALUES("1","1","1","Email sending issue .","The email service (SMTP) has problems when sending emails. But receiving emails (POP / IMAP) is working normally.Our infrastructure team is working to resolve the issue as quickly as possible.","2016-02-25 19:48:56","2019-12-26 19:48:00","0000-00-00 00:00:00","N","3","0");
To Reproduce
Steps to reproduce the behavior:
- Enter the required db details , administrator account details
- On step 7 the above error is thrown.
Expected behavior
Database tables should be loaded properly and installation should be successful.
Screenshots
What could be causing the issue on MYSQL 5.7?. Script installation is successful on MYSQL 5.6 and the above error isn't thrown.
Could you please check and replicate the above issue on MYSQL 5.7 and fix this?.
Also what is the maximum MYSQL requirement that Helpdezk supports?
Hi.
Thank you very much for reporting this issue.
I am downloading mysql 5.7, to reproduce the problem and try a solution.
As soon as it's resolved, I'll let you know here.
Best Regards
Hi.
First of all, I wish you a happy new year.
About the problem:
- Helpdezk has no restrictions on the versions of mysql / mariadb;
- With regard to version 5.7. *, this stackoverflow article Error in MySQL when setting default value for DATE or DATETIME reports that the problem occurs in this version because sql_mode is set to STRICT_TRANS_TABLES. It also presents several ways to solve.
Please let us know here if the issue has been resolved and, again, thank you for helping us by reporting this issue.
Regards
Hello @albandes ,
Thanks for your reply. Also wish you a very happy new year.
However, I don't have permissions to make the above modifications which you mentioned regarding 'STRICT_TRANS_TABLES' to the MYSQL server.
Is there any way by which you could handle the above issue by making modification in code itself, without needing to make 'STRICT_TRANS_TABLES' change to MYSQL server?.
It would be also really very helpful to other users as well, who are trying to install the script on MYSQL 5.7 and might face the same issue.
Getting the above mentioned issue in the latest version 1.1.9 as well on MYSQL 5.7.
Could you please check and let me know the same?.
Regards.
Hello @albandes ,
Any update regarding the above query I posted?. Kindly let me know.
Hello @prbt2016 .
If we corrected the MySQL problem, we would have to change several lines in the code and, most importantly, we would have to make changes to a Mysql´s table.
This would have a huge impact on hundreds of users.
So, we can use a workaround:
- We changed the database creation script so that you can perform installations without errors;
- After installing, you cannot use the "warning program", or use and always set an end date.
Hello @albandes ,
Thanks for looking into the issue and information regarding workaround.
Surely that would be great if you implement that workaround, so that installation works fine on MYSQL 5.7 and users using MYSQL 5.7 having 'STRICT_TRANS_TABLES' settings enabled won't have an issue while manually installing the script.
Kindly let me know when you push the fix for the same.