Adjustments
Adjustments in Helpdezk core
-
The pipeTableExists function was previously used, however in some versions of mysql case sensitive problems were reported in the function names. Then, we replace it with a query.
-
Version 5.7. * of mysql sets the sql_mode parameter to STRICT_TRANS_TABLES by default. This makes it impossible to use a datetime value of '000-00-00 00:00:00'
Strict mode affects whether the server permits '0000-00-00' as a valid date: If strict mode is not enabled, '0000-00-00' is permitted and inserts produce in the warning. If strict mode is enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well. For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.
To solve the problem, just remove the STRICT_TRANS_TABLES from the sql_mode parameter. However, some users do not have access to mysql.ini, or permission to set in real time, so we created a workaround, changing the example record in the bbd_tbmessage table.