Deleting events and importing events

[James Powell]

I’m importing events from an ical link with the events aggregator. There were some issues with how the data was being output so I decided to start again. I deleted all the events and moved them to the trash but when I come to re-import the data it insists they’re all still there and only updates rather than putting them back in.

What can I do to solve this?

[James Powell]

Anybody?

[Patricia]

Hey James,

Thank you for reaching out to us! Please accept our sincere apologies for the delayed response.

Can you please share with us in a private reply the ical link you are using to import your events? This way I can try to replicate the issue you are experiencing from here and help you to solve this problem.

Thanks!

Patricia

[James Powell]

This reply is private.

[Patricia]

This reply is private.

[James Powell]

Hi,

Thanks for the reply but I don’t see any of those options?

I’d previously been in and cleared out the database would this have impacted on this?

Would it be easier to just double check the database is clear – could you let me know exactly what files need to be deleted and I’ll remove the plugins and start again 🙂

[Patricia]

Hi James,

That is a strange behavior: if you deleted all of your events, they should have disappeared from trash (Ignored) as well (so in that case your initial problem would be solved at this point).

Regarding your question, you can remove your events directly from the database, but please, bear in mind that you’ll have to backup your database before you do this. Also, please understand that you are doing this at your own risk, we don’t usually encourage users to manipulate the database directly and can’t provide support for doing this. But we’ll happily provide guidance.

Events are a custom post type within WordPress, which means that they are stored in the posts table along with all other posts, pages and other custom post types. The way to differentiate them from other posts, is with the ‘post_type’ column. Events registered with The Events Calendar will have ‘tribe_events’ as their post type. So your goal here is to delete all entries from the posts table with the ‘tribe_events’ ‘post_type’. So here’s the SQL you can run directly from phpMyAdmin:

DELETE FROM wp_posts WHERE post_type = 'tribe_events'

Note: you may need to change wp_posts to customprefix_posts if your table prefix is different (as defined when you installed WordPress).

Again, we advise you to act with caution and backup first.

Hope this helps! Let us know if you need anything else in the mean time.

Regards,

Patricia

[James Powell]

Hi Patricia,

Still not working – I manually added some events in this afternoon as I still couldn’t resolve the issue.

I’ve just tried the SQL query and it’s not removed anything in either variation.

[Patricia]

Hi James,

I’m sorry to know that this query didn’t solve the issue you are experiencing.

Can you please access your Dashboard and head over to Events -> Settings -> Imports -> Event Update Authority and make sure that the selected option there is the first one “Overwrite my event with any changes from the original source”? Please note that after making any changes to these settings you have to press the “Save Changes” button in the end of the page. We have an article about EA import settings: it is a little bit outdated but might be helpful to better understand some of the available options:

Event Aggregator Import Settings

If the first “Overwrite event” option is selected and the issue persists, can you please send us a copy of your database in a private reply so I can import it to my local site and verify what is possibly causing the problem?

Thanks!

Patricia

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts