Upgrade to Events Calendar Pro to 3.5.x problems

[roosites]

Hello. When I updated to the latest version, I could no longer access my dashboard. Also I now have hundreds if not thousands of duplicates. I reverted back to the old version but still have dupes. Also when you click on an event you get a 404 error.
Question: Is there a way to remove dupes, whether through the interface or by SQL? Also can you tell me how to resolve my 404 error?

Thanks

[Barry]

I’m sorry you had such a rough ride. We did just release an update for PRO that includes some fixes – so please do ensure you are running 3.5.1 here before trying anything else.

Also I now have hundreds if not thousands of duplicates. I reverted back to the old version but still have dupes.

That’s going to be frustrating, for sure. If they are literally the same you could probably craft a piece of SQL to help with this, along the lines outlined in one of the comments here (which gives the general form):

DELETE from table1
USING table1, table1 as vtable
WHERE (NOT table1.ID=vtable.ID)
AND (table1.field_name=vtable.field_name)

Beyond that or if you don’t feel comfortable doing so I’d recommend doing this manually (remember you can adjust the number of events that display per page and leverage bulk actions) or rolling back to your backup if you made one.

Also can you tell me how to resolve my 404 error?

We’d need to know more about why they are occurring. The first thing to try though (after updating to our latest builds) is visiting the Permalinks Settings screen – you don’t need to change anything, just visiting this should refresh the list of rules used to guide requests.

[roosites]

Thanks, but when I went to upgrade, I ended up with the original problem and can’t get back to the dashboard. I uninstalled everything and decided to start from scratch. I went to install the 2 plugins, but event calendar won’t activate. Please advise.

[roosites]

I did finally get it installed. It took a few tries as it kept timing out. I assumed my old events would be gone, but alas they are still there. I didn’t want to delete 38,000 entries, so I ran the following SQL which deletes all old entries in case anyone else runs into this:

DELETE FROM YOUR-USERNAME_wrdp1.wp_posts WHERE (CONVERT(ID USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_author USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_date USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_date_gmt USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_content USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_title USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_excerpt USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_status USING utf8) LIKE ‘tribe_events’ OR CONVERT(comment_status USING utf8) LIKE ‘tribe_events’ OR CONVERT(ping_status USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_password USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_name USING utf8) LIKE ‘tribe_events’ OR CONVERT(to_ping USING utf8) LIKE ‘tribe_events’ OR CONVERT(pinged USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_modified USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_modified_gmt USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_content_filtered USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_parent USING utf8) LIKE ‘tribe_events’ OR CONVERT(guid USING utf8) LIKE ‘tribe_events’ OR CONVERT(menu_order USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_type USING utf8) LIKE ‘tribe_events’ OR CONVERT(post_mime_type USING utf8) LIKE ‘tribe_events’ OR CONVERT(comment_count USING utf8) LIKE ‘tribe_events’)

[Barry]

I’m sorry we missed your reply – but glad you seem to have got things working (and thanks for sharing the code).

At this point, since the thread’s not seen much activity for the last couple of weeks, I’ll go ahead and close it. Of course if you still need help with this or any other issue please don’t hesitate to create a new thread (or threads) and one of the team will be only too happy to help. Thanks!

[Author]

Posts