Templating Problems yet again

[Rob]

Thanks Jason. Paul is jumping back into this today; we’re committed to doing our best towards getting this resolved.

[moderntribe]

Try using ‘orderby’ instead of ‘order_by’. This solved the problem for me. Let me know if it works for you!

[Jason]

no dice,

i changed “order_by” to “orderby” and get the same resulting SQL query


SELECT SQL_CALC_FOUND_ROWS wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = '_EventStartDate') LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration') LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate') WHERE 1=1 AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') ORDER BY wp_posts.menu_order ASC LIMIT 0, 10

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = '_EventStartDate') LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration') LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate') WHERE 1=1 AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') ORDER BY wp_posts.menu_order ASC LIMIT 0, 10


[moderntribe]

http://pastebin.com/2DKQy3Mq

That’s my current code. Could you post yours and I’ll double-check that they’re identical? Interestingly, my environment is defaulting to post_date not menu_order like yours is (and orderby => ‘title’ fixed that at my end). I just want to make sure I’m working verbatim from your current code so I can recreate your problem “correctly.” 😉

[Jason]

Paul,

I fixed it using the global $wpdb class. However i can’t understand why the plugin isn’t working with my template. Perhaps it’s looking for something in a template file that doesn’t exist in my template, but does in the WP2011 template?

At any rate, here is the pastebin of the working file

http://pastebin.com/7wB7jY6c

If you find a way to achieve the same results using wp_query, let me know.

I’ve also included a zip of my entire WP install, so you can test in the same environment.

zip file : http://www.filesonic.com/file/EOOaXke

email me at [email protected] for the password

[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