Events Calendar Pro still Breaking Cornerstone

[OctoCog]

This is a continuation of this post. I fixed the 502 Bad Gateway Error as @marc_a requested.

You should now be able to login without issue.

The Events Calendar Pro is still making it so that Cornerstone will not save.

[prakash_s]

Hello @OctoCog,

Thanks for writing to us.

I tried to access the site dashboard, but it is not working at the moment. Please let us know when it is accessible so we can check it.

Thanks

[OctoCog]

@prakash_s I updated the site. You should be able to get in without a 502 Bad Gateway error. Once you are logged in, Activate the Events Calendar Pro and The Events Calendar: Filter Bar plugins.

[Ismael]

Hello @OctoCog,

Thank you for the update.

When we enabled the plugin and tried to save the page, we encountered this response, which seems to be generated by Cloudflare, your CDN provider:

Bad gateway Error code 502
The web server reported a bad gateway error.
Cloudflare Ray ID: 8fb25xxxxxxxdc6 • Your IP: xx.xx.xx.xxx • Performance & security by Cloudflare

Have you tried testing this with the CDN disabled? Do you see any errors in the log after this occurs? Please enable debugging and error logs so we can review the errors:

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );

We’ll check the site again once debug mode is enabled.

Best regards,
Ismael

[OctoCog]

@Ismael I was not able to shut off the CDN. I enabled the error log as you requested.

[ruenel]

Hey @OctoCog,

I have checked the error log and I am seeing this:

• See the secure note below

You may need to contact the creators of the Events Calendar Pro plugin to let them know about this. They may also have a patch update to roll out.

By the way, the Teachers homepage is loading just fine on my browser. I cannot replicate any issues.

• See the secure note below

Thanks.

[OctoCog]

@ruenel I will bring up this error with the Events Calendar Pro plugin.

The issue I found on the Teachers page was not opening it. It was saving it. When the Events Calendar Pro and The Events Calendar: Filter Bar plugin is active, I cannot save pages in Cornerstone.

Would you be able to look at this and see the JSON error?

[Ismael]

Thank you for the update.

When attempting to save a page, the following error occurs related to the “wp_tec_occurrences” table, which doesn’t exist in the database. This table seems to be used for event occurrences.

WordPress database error Table 'wp_xxxxxx.wp_tec_occurrences' doesn't exist for query SELECT * FROM `wp_tec_occurrences` WHERE (`occurrence_id` IN (4446586283840764)) LIMIT 1000 OFFSET 0 /* From [xxxxxx.wpenginepowered.com/] in [/nas/content/live/xxxxxx/wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/Models/Builder.php:1055] */ made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/pro/framework/legacy/templates/template-blank-4.php'), x_get_view, x_render_view, include('/themes/pro/framework/views/integrity/template-blank-4.php')

Please keep in touch with the plugin developers for additional info. What do you mean by “JSON error”?

[OctoCog]

Hi @Ismael, That’s interesting because the wp_tec_occurances table does exist and is populated. When I say JSON error. I’m referring to when I save a page in Cornerstone, I get this red error below:

“Failed to save. The response is not a valid JSON response.”

I’ll bring up this database error with The Events Calendar.

[Ismael]

Thank you for the clarification. It’s supposed to return a JSON, but instead, it returns the 502 gateway error that we mentioned above , which is why it’s not saving correctly. This is likely due to the database error. Please stay in touch with the plugin developers for additional assistance.

[OctoCog]

@Ismael Okay, got it. They are looking into it now. I’ll report back when they’ve let me know what is going on.

[marc_a]

Hey @OctoCog,

That’s great and let us know how it goes.

Thank you.

[OctoCog]

@marc_a I was able to fix the 502 error on saving issue by Migrating Events and then Reversing the Migration.

For anyone who is curious these are the steps I followed:

Migrating Events
Here are the steps to revert and do the migration:

1. Update to the latest versions of The Events Calendar and Events Calendar Pro.
2. Remove any un-needed draft events and empty the Trash.
3. Activate only our plugins and use the 2020 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 again.
8. Then go and Reverse the Migration

[marc_a]

Hey @OctoCog,

We’re glad you can find a solution to your issue.

Cheers!