I have also found this. For me, this is the reason
PHP message: WordPress database error Unsupported collation when new collation is enabled: ‘utf8mb4_unicode_520_ci’ for query CREATE TABLE wp_tec_occurrences
This is caused during migrate, fails, and prevents migration.
mysql> CREATE TABLEwp_tec_events` (
-> event_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-> post_id BIGINT(20) UNSIGNED NOT NULL,
-> start_date DATETIME NOT NULL,
-> end_date DATETIME DEFAULT NULL,
-> timezone VARCHAR(30) NOT NULL DEFAULT 'UTC',
-> start_date_utc DATETIME NOT NULL,
-> end_date_utc DATETIME DEFAULT NULL,
-> duration MEDIUMINT(30) DEFAULT 7200,
-> updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-> hash varchar(40) NOT NULL,
-> PRIMARY KEY (event_id)
-> ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ERROR 1273 (HY000): Unsupported collation when new collation is enabled: 'utf8mb4_unicode_520_ci'`
Hmm, even after working around this my manually creating the tables, i also find the migration does not occur.
after some time of waiting, these errors arrive:
The event Don Test Event generated an error: [TECEventsCustom_TablesV1ModelsOccurrence implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)]. Please try again or check out our Troubleshooting tips.
it only occurs on 2 of my events.
Note that it is php8.0 (not php8.1 as ref on https://theeventscalendar.com/knowledgebase/k/migrating/#PHP-8-1-errors)
-
This reply was modified 1 year, 9 months ago by
donbowman.
Plugin Support
Abz
(@abzlevelup)
Hi @donbowman @artports, sorry to hear about this. We’re working on a couple of issues with the migration. https://theeventscalendar.com/known-issues/#dl_migration-errors2
You can still continue using the pre-6.0 feature and functionality, while our team is working on a fix. I am unable to provide an exact date or time estimate for when this bug will be fixed, but you’ll be notified when there are any updates.
If you do have other concerns or issues you need help with, please create another ticket, as it helps us track different issues.
Again, thank you for your patience. Hang in there.
Best,
Abz
________________________
Internal Bug Ticket Reference:
ECP-1318
Even with 0 events on my staging site the migration runs forever. Migration issues are not gone with 6.0.2 and it seems to me as nothing has changed to the better since 6.0.0.
-
This reply was modified 1 year, 8 months ago by
maexx.
Plugin Support
Abz
(@abzlevelup)
Hi @maexx, sorry to hear about this. Could you share errors/warnings on your end? Moreover, if you do not have existing events, it would be good if you could download directly the latest version. You’d also need to remove and properly uninstall the previous version.
Best,
Abz
If I get an error message, I’ll post it. Deleting the plugin with all itds data is not a real option, as I need to do the conversion also on my live site with events.
It’s likely that 6.0.0 or 6.0.1 created a mess with its failure to convert times with DE locale correctly. Further failure messages were: “start and end date can’t be the same”, but that’s what the plugin automatically creates, when leaving the end date open.
Might get to import the dates from the live site and try it on a fresh site. However, the plugin screwed up and is not stable since 6.0.0.
-
This reply was modified 1 year, 8 months ago by maexx.
Plugin Support
Abz
(@abzlevelup)
Hi @maexx, thanks for confirming. Could you try downgrading to pre-v6.0 and then retrying the migration to v6.0? Other users were able to resolve issues with a couple of tries. Additionally, try following KB if you haven’t already to maximize your chances of a successful migration: https://theeventscalendar.com/knowledgebase/k/migrating/.
Here’s an article to help you with downgrading the plugins: Accessing and Installing Older Plugin Versions.
To be safe, we’d recommend conducting these tests on a Staging Server. Also, please keep a working backup of your website.
Further failure messages were: “start and end date can’t be the same”, but that’s what the plugin automatically creates, when leaving the end date open.
I’d reach out to the team regarding this, error message. I’d get back to you whenever I hear from them.
Apologies for the inconvenience. Hang in there.
Best,
Abz
Plugin Support
Abz
(@abzlevelup)
Hi everyone, apologies for the delay here, I’m back now.
We just released The Events Calendar 6.0.4. We fixed quite a few errors in this release, and it may have solved this issue as well. Please update and let us know if that fixes the issue here.
To be safe, we’d recommend conducting tests and updates on a Staging Server and keep a working backup of your website.
Also, please clear any caching for both third-party plugins and server-side (if you have any). It would also be good to flush permalinks.
Best,
Abz
Hi Abz,
The migration still doesn’t work. The report says for each event: “…has generated an error: The migration was cancelled. Please try again.”
Regards
Plugin Support
Abz
(@abzlevelup)
Hi @artports, sorry to hear about this. We’re working on a bug ticket where the migration still stalls out and is being canceled.
We already created an internal bug ticket for this, and I have added your case to it. Thanks for the details, I will definitely pass it along to our devs.
…has generated an error: The migration was cancelled. Please try again.
I am unable to provide an exact date or time estimate for when this bug will be fixed, but you’ll be notified when there are any updates.
If you do have other concerns or issues you need help with, please create another ticket, as it helps us track different issues.
Again, thank you for your patience. Hang in there.
Best,
Abz
________________________
Internal Bug Ticket Reference:
TEC-4547
Hi @artports,
That error message is usually caused by a conflict with another plugin on your site. I’d recommend that you try deactivating other plugins (especially caching plugins) and try migration that way. We’ve also made some migration improvements in our latest release (The Events Calendar 6.0.5) so please update before you try again. Let me know how it goes!
Best,
Leah
Hi Leah,
Thanks for your advice. I’m not using a caching plugin but I deactivated all plugins, updated the events calendar plugin and activated the plugins afterwards. Now, everything seems to work. There were no error messages anymore.
Best, B.
