Missing event tables – script does not work

Resolved Boris
(@ispacecrusader)

12 months ago

I have a website and just installed TEC, as I have on numerous websites in the past.
For some reason, the TEC tables are not created. I keep seeing this in system info:
Missing Event Table Data | Missing Occurrences Table Data
I tried running the script mentioned here:
https://theeventscalendar.com/knowledgebase/how-to-troubleshoot-if-the-calendar-is-showing-empty-with-published-events-on-it/
And now when I check I see:
wp_tec_events is there
wp_tec_occurrences is there
But the rest is missing.
And the result is my single events all result in 404’s.
I’ve tried disabling/re-enabling, uninstalling and reinstalling. Nothing works.
How can I get these tables created?

Viewing 4 replies - 1 through 4 (of 4 total)

Thread Starter Boris
(@ispacecrusader)

11 months, 4 weeks ago

Managed to resolve it by uninstalling, re-installing and deleting all existing events. A newly created event now does work.
Plugin Support Darian
(@d0153)

11 months, 4 weeks ago
Hi @ispacecrusader

Thanks for your response. I’m glad to hear that you have found a workaround for this.

Based on your initial message, it looks like you haven’t yet migrated your events to the new Events Data System. This migration is required in order to use the latest versions of our plugins properly.

If you haven’t completed the migration yet, please follow these steps to get started:
1. Update to the latest versions of The Events Calendar and Events Calendar Pro (if you have one).
2. Remove any un-needed draft events and empty the Trash.
3. Activate only our plugins and use the 2021 theme.
4. Make sure server-side caching is disabled temporarily while you’re migrating your events.
5. Install and activate the Code Snippets plugin.
6. Add this snippet and run it once (be sure it does not stay activated).
7. Go to Events > Settings > Upgrades and go through the migration process.
Please test the migration on your staging site first before applying to your live site to avoid unnecessary downtime.

Let me know how it goes.
Thread Starter Boris
(@ispacecrusader)

11 months, 4 weeks ago

Hi @d0153
thanks for your help. No, it was a fresh installation of TEC. I have uninstalled and re-installed multiple times, and tried various scripts from your documentation as well as suggestions from ChatGPT.
At first, the extra tables would just not install, even with numerous attempts. Later on, the tables were installed, but the issue remained.
At that point, the problem was probably resolved already, but I never thought to create a new event, as I expected the existing ones to start behaving normally after the fixes. They would not.

Also, the manual migration option was not present in the settings.

Plugin Support Darian
(@d0153)

11 months, 4 weeks ago

Hi @ispacecrusader

Unfortunately, if you’ve previously installed an older version of The Events Calendar plugin, the migration process will still be required. The only exception is if you’re working with a completely fresh WordPress installation—in that case, migration isn’t necessary.

The steps I shared above include a snippet to revert the migration. If you haven’t run that snippet yet, the Upgrade tab under Events > Settings won’t appear.

Please follow each step I outlined earlier carefully and let me know if that helps.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Missing event tables – script does not work’ is closed to new replies.