[Jason]

I went through the update process again, everything is up and running with 2.0.9 with some minor code changes that I had to make.

Has there been a shortcode introduced yet, so I can integrate my events list with WPTouch Pro (as of yet, WPTouch doesn’t support custom post types, so i have to manually embed the events in a page somehow)

[Jason]

Just updated the pro plugin to 2.0.9 and as you mentioned, all my settings were dropped, which dropped my custom fields (that’s how I was linking to my online ticketing software). I’m going to restore to 2.0.3 from backups. If it’s not broke, don’t fix it. Is there a way to disable automatically checking for updates?

[Jason]

List of Plugins

Analytics360 – 1.3.0
Category Posts Widget – 3.3
Contact Form 7 – 3.3.1
Contact Form to DB Extension – 2.4.2
Duplicate Post – 2.4.1
eShop for WordPress – 6.2.17
Maintenance Mode – 5.4
NextGen Gallery – 1.9.6
PODS CMS – 2.0.4.1
User Role Editor – 3.8.1
WPtouch Pro – 2.7.2

[Jason]

Barry,

I am the developer. Back when we first launched this site around February/March we had problems with older versions of ECP, so much so that I gave up with support and dug into the plugin and re-wrote the code so that it did what I expected it to ( advertising vs. delivered product was not congruent ).

With all due respect, when you have 350 clients, it’s not cost effective to keep a development area for each client. When we pay for a plugin, we expect it to work and i’m quite capable of troubleshooting most issues.

99% of my plugins auto-update, so I was not aware that my ECP was out of date. I’ve downloaded the 2.0.9 ECP update, when i upload, do i just overwrite whats in the event-calendar-pro.2.0.3 folder, or do i upload the folder named “event-calendar-pro”, then go through the deactivation/activation process? Will i lose any data? ( i have a backup ). The different named folders are throwing me off.

[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

[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


[Jason]

Paul,

If you look at the bottom of the page (http://www.barnumfestival.com.php5-19.dfw1-2.websitetestlink.com/events/) you’ll see the events are coming out in a list.

But if you look at the query $args at the top of the page, you’ll notice that they should be ordered by title in ASC order.

They’re not ordered correctly.

the SQL in the 2nd var_dump shows wp_query is ignoring the query args for a SQL statement set in your tribe-query-class.php

[Jason]

just wondering if there has been any update on this, i have to give an internal review of the finished project by tomorrow @ 3pm!!

[Jason]

Jonah,

The first var_dump is the $args array being passed to wp_query. The 2nd var_dump is the actual wp_query object after args are passed, showing that the SQL query being run by wp_query is completely different and not affected by the wp_query arguments passed to it. Not sure what TEC plugin is doing behind the scenes to modify wp_query, but i’m not using any of the TEC template tags to generate the loop, i’m using strictly wordpress functions and somehow TEC is still interfering.

The loop.php code that is dumping the debug info is posted to pastebin above.

[Jason]

I just got the project deadline on this from my Project Manager and I need a resolution or a refund by Friday, Jan 20 @ 3:00 EST. I have to deliver this to the client on Jan 23rd.

[Jason]

Still can’t seem to overcome templating issues on list.php page after changing to a custom loop using wp_query.

http://www.barnumfestival.com.php5-19.dfw1-2.websitetestlink.com/events/ (should show events in alphabetical order)

http://www.barnumfestival.com.php5-19.dfw1-2.websitetestlink.com/events/upcoming (should show events in chronological order automatically leaving expired/past events off the list)

Code of list.php here : http://pastebin.com/5S3G5FMN

The query $args are being dumped into wp_query fine, but for some reason wp_query is executing a totally unrelated SQL query. Not sure what you guys are doing in the background.

[Jason]

this works, thanks!

[Jason]

no dice here,

updated page output: http://www.barnumfestival.com.php5-19.dfw1-2.websitetestlink.com/events/

updated code : http://pastebin.com/JrZpsJdx

[Jason]

this was fixed along with the css issue i had when i changed my template to use singletons and declared $post as global. You can close this issue out. Thanks again!

[Jason]

@Jonah

I Figured it out. I looked at your included templates and realized that you’re using the singleton method of querying the post type and declaring $post as a global var. Still puzzling why using the wp loop would give me different results. Oh well.

[Author]

Posts