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

MySQL Error: Invalid default value for 'backtime'

CMS 06.03.2017 2509 Support Status: Closed Solution: Yes charmlander

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?

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:


    In case you need further support, please purchase support access here:

    Thank you very much.

    06.03.2017 0
  • avatar charmlander

    Ok I got it.


    06.03.2017 0