Support Tickets - MySQL Error: Invalid default value for 'backtime'

MySQL Error: Invalid default value for 'backtime'

CMS 06.03.2017 2682 Support Status: Closed Solution: Yes charmlander


Hi,
I am on VPS with Ubuntu 16.04.When I try to install CMS, it returns with "MySQL Error: Invalid default value for 'backtime' error.Script was working fine with 14.04.What can be the problem or is there a fix for that?
Thanks.


MySQL server version 5.7.17


Replies (2)

  • avatar Jerome

    Thank you for opening a support ticket.

    Please note that your license does not have access to support.

    In your case please check the default value behaviour for MySQL 5.7, you will need to remove from the sql mode:

    NO_ZERO_DATE

    In case you need further support, please purchase support access here: https://jakweb.ch/shop/i/1/support-access

    Thank you very much.

    06.03.2017 0
  • avatar charmlander

    Ok I got it.

    Thanks.

    06.03.2017 0