Events don’t migrate | WordPress.org
Skip to content
Forums
Skip to content
Forums
Plugin:
The Events Calendar
Events don’t migrate
Resolved
artports
(@artports)
3 years, 6 months ago
Hello,
I cannot upgrade the events, the events cannot be migrated.
The report only says that the migration has been cancelled.
I’m using:
WordPress 6.0.2, Theme Envy Blog.
Server running PHP version: 8.0.20.
The Events Calender 6.0.1.1
The page I need help with:
to see the link]
Viewing 12 replies - 1 through 12 (of 12 total)
donbowman
(@donbowman)
3 years, 6 months ago
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 TABLE
wp_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'`
donbowman
(@donbowman)
3 years, 6 months ago
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
This reply was modified 3 years, 6 months ago by
donbowman
Plugin Support
WilloftheD
(@abzlevelup)
3 years, 6 months ago
Hi
@donbowman
@artports
, sorry to hear about this. We’re working on a couple of issues with the migration.
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
maexx
(@maexx)
3 years, 6 months ago
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 3 years, 6 months ago by
maexx
Plugin Support
WilloftheD
(@abzlevelup)
3 years, 6 months ago
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
maexx
(@maexx)
3 years, 6 months ago
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 3 years, 6 months ago by
maexx
Plugin Support
WilloftheD
(@abzlevelup)
3 years, 6 months ago
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:
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
WilloftheD
(@abzlevelup)
3 years, 5 months ago
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
Thread Starter
artports
(@artports)
3 years, 5 months ago
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
WilloftheD
(@abzlevelup)
3 years, 5 months ago
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
Plugin Contributor
leahkoerper
(@leahkoerper)
3 years, 4 months ago
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
Thread Starter
artports
(@artports)
3 years, 4 months ago
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.
Viewing 12 replies - 1 through 12 (of 12 total)
The topic ‘Events don’t migrate’ is closed to new replies.
The Events Calendar
Frequently Asked Questions
Support Threads
Active Topics
Unresolved Topics
Reviews
Tags
migrate
migration
15 replies
5 participants
Last reply from:
artports
Last activity:
3 years, 4 months ago
Status: resolved