[SOLVED] MYSQL error when copying _cbsubs_promotions table

Hello,
I recently ran into trouble copying (via PHPadmin) the _cbsubs_promotions table to a cloned website/database on the same server (I do this to reconfigure/add/test plans and promotions on test site before copying tables to live site). When I use PHPadmin to copy the table, I now get the following error in PHPadmin:

#1067 - Invalid default value for 'start_date'

I am able to successfully export/import the table between databases, just a bit more cumbersome. Also not sure if I could do a full site restore if needed. I attached screen snips of the error and of the definitions for the start_date field in the Promotions table.

Site info:
Joomla: 3.9.14
CB: 2.4.3+2020.01.15.23.16.37.26e61d3e9
CBsubs: 4.3.1+build.2019.11.20.05.59.04.9f91da950
MYSQL: 5.7.29
PHP: 7.3.13

Try changing the start_date column default to None then back to 0000-00-00 00:00:00 and see if that fixes it. I don't see any issues in your screenshot but could be a trailing character after the time that maybe causing the issue.

Hello, thanks for the quick response. Unfortunately the cut/paste of 0000-00-00 00:00:00 did not work. After some research, I found the issue to be related to the NO_ZERO_DATE setting of the SQL mode in the MYSQL version 5.7 on my server. I was able to get rid of this setting and can now move/copy the table without error.