[SOLVED] MYSQL error when copying _cbsubs_promotions table

2 months 2 weeks ago - 2 months 1 week ago #316371 by ospaorg
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.
CBsubs: 4.3.1+build.2019.
MYSQL: 5.7.29
PHP: 7.3.13

2 months 1 week ago #316378 by krileon
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.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
2 months 1 week ago #316406 by ospaorg
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.
The following user(s) said Thank You: krileon
Moderators: beatnantkrileon
Time to create page: 0.487 seconds

Facebook Twitter LinkedIn