[Unknown column 'EventStartDate' in 'order clause'] when transferring events

[Matt]

The error:

WordPress database error: [Unknown column 'EventStartDate' in 'order clause']
SELECT DISTINCT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' ) WHERE 1=1 AND ( wp_postmeta.meta_key = '_EventStartDate' ) AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'archive' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'archive') GROUP BY wp_posts.ID ORDER BY EventStartDate DESC LIMIT 0, 1

We’re trying to take events from one site- a full export of content and import it into the new site.

Everything seems to have imported correctly with the exception of the events.

Any suggestions?

[Barry]

Hi Matt,

I’m sorry to hear you have hit up against some difficulties.

Just to clarify, are you using the “native”/official WordPress import/export tools for this task (if not, can you point me to the tool that you are using)?

Thanks!

[Matt]

Hey Barry,

We did a full database migration. The “new site” is just a new theme (Genesis).

So we made a duplicate of the database and loaded it into wordpress and then turned on the new template.

Haven’t tried the built in exporter or any other tools.

[Barry]

Thanks for clarifying!

So you’re seeing this error on the new site? When and where does it occur exactly?

[Matt]

Issue occurs on any events page. I noticed that no actual events were pulled in when the database was copied.

My current plan is to delete both plugins from the site along with their data in the hopes that will bring things back to a fresh state. Then if that works, I can just run a WP export on the events from one site to the other?

[Matt]

I started the above steps and had some unexpected results:

1. I deleted both regular and pro version (same versions) of the plugin and data for both.

2. Then I re-uploaded the plugins and activated them.

3. I went to the main Events section and ALL of the events are now visible. – Before there were 0. (There’s 2,093 events on this site.)

So it seems that the DB is not actually modified when deleting the calendar plugin.

Anyways, the same error is now back even though the events are accessible and visible in the admin now. Still, “WordPress database error: [Unknown column ‘EventStartDate’ in ‘order clause’]”.

[Barry]

Could you share your system information (for the new/destination site) and would it additionally be possible to be provided with HTTP authentication credentials?

[Matt]

This reply is private.

[Matt]

Could you help me identify the tables I need to remove?

[Barry]

Odd.

Certainly strange to hit this if the database – and plugin stack – is effectively a carbon copy of the original site.

I do see that you updated from 2.0.11 to 3.10: can you confirm if this update was performed on the original site – or did you do it post-migration?

Definitely let me know how you get on with the other steps you outlined in your last reply.

[Matt]

I’m seeing now that the events are stored along with the posts tables, so I may nuke all of that and then re-import posts/pages and events separately and see how that works.

The original site is running the same events version as the new site. The plugin stack is essentially the same (all plugins but events disabled makes no difference anyway).

[Barry]

Event data is indeed stored within the post and postmeta tables. I’m sorry I can’t offer much more guidance here – certainly if you find that there is no problem with a clean installation (ie, the same plugins etc but an empty database, in which you create some test entries) it would seem to point to a problem in the way the database was exported/imported.

[Matt]

Having problems again,

ALL reoccurring events are broken on the site. For example:

Main Events Page: http://fbca1.thrivenetmarketing.com/events/

The third event down, “Awaken Service” is a reoccurring event set for “August 16, 2015 @ 9:30 am – 10:30 am”.

The URL is inexplicably: http://fbca1.thrivenetmarketing.com/event/awaken-service-2/2014-02-02/

Which seems wrong given it’s a 2015 event in august not a 2014 event in February.

Based on that, I’m not at all surprised I’m getting a “This Event Has passed” error and all of the details are wrong and for the 2014 event.

Site is going live soon and this is a big big issue…

[Barry]

Hi Matt,

I’m sorry to hear that.

Unless I’m misunderstanding, this seems like a quite separate issue from that you originally posted about.

With that in mind, would you be able to open a fresh topic? One of the team will be only too happy to help as quickly as they can (it would also avoid you encountering any further delay since I’m actually “off duty” tomorrow) 🙂

Barry

[Matt]

I respectfully disagree. The past issues, dev logins and history are all relevant to ongoing issues with your plugin. For all I know they are entirely related.

If I make a new topic I’m going to copy/pasting information from above creating redundancy.

I’m having an another problem as well. Should I make a third ticket? I just don’t think that makes a ton of sense since these could all be related.

On the Weekly view – I can’t advance the week backward or forward and events that are not set to “Featured” aren’t showing up.

This is brutal.

[Author]

Posts