No events listed in events

[Krister]

Hi

I am in the process of migrating my page between wordpress instances.
After importing the content, all my events have disappeared in the wp_admin list.
Still shows the number of events, but list none.

Debug bar gives this error:

SELECT DISTINCT wp_posts.*, tribe_event_start_date.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts 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’ ) LEFT JOIN wp_postmeta AS tribe_event_start_date ON wp_posts.ID = tribe_event_start_date.post_id AND tribe_event_start_date.meta_key = ‘_EventStartDate’ WHERE 1=1 AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY EventStartDate DESC,tribe_event_start_date.meta_value DESC, tribe_event_end_date.meta_value DESC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY
[Microsoft][SQL Server Native Client 11.0][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. Code – 169

Regards
Krister

[Nico]

Howdy Krister,

Welcome to our support forums and thanks for reaching out to us. I’ll try to help you here!

In the error description I see that you are running WordPress with Microsoft SQL Server? I’m not sure if that’s possible at all!

Also, How did you migrate the events to the new site?

Please let me know about this,
Best,
Nico

[Krister]

Hi thank you for taking the time to give me an answer. I’m using project Nami to get wordpress running on Azure SQL. So that is working. I can see both venues and organizers.

The import was done through WordPress Importer first. Then i tried WP CSV Export for The Events Calendar when i didnt see the events in the list. After that I installed the Debug Bar and saw the error message.

Do you know how the queries are built? Its all working fine except that double order by query.

Regards
Krister

[Nico]

Hey Krister,

Thanks for following up! That’s a setup I’ve never heard of, congrats for setting that up!

Regarding the Query error, I don’t recall hearing reports of it in the past so I guess the best will be to troubleshoot this: Can you please follow the steps described in our Testing for conflicts guide? This way we can see if this is a problem in our plugin or a conflict with the theme or other installed plugins.

Also, Do you have a staging or local site, with regular MySQL config? Can you try the same there?

Please let me know about your findings,
Have a great weekend,
Nico

[Krister]

Hi Nico

I’ve tried the Testing for conflicts guide. Still doesnt work when on default theme and no other plugins running.

My current live site is running MySQL and the plugin seems to work there. So im suspecting that this is an issue with running on SQL server.

Regards
Krister

[Nico]

Hey Krister,

Thanks for following up! As you say this might be a problem with the SQL Server setup indeed. Unfortunately we cannot support this type of non-traditional setup 🙁

Maybe posting in the .org forums can lead to some user with a similar setup to give you some advice on this?

Please let me know if there’s anything else I can do for you,
Best,
Nico

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts