[Konrad Nierwinski]

This reply is private.

[Konrad Nierwinski]

This reply is private.

[Konrad Nierwinski]

Hi, after debug the plugin: “The Events Calendar: Community Events v4.5.4” we found the source of the problem, and it’s a logic comparison in the code located at: “…/the-events-calendar-community-events/tribe-community-events.php” line 42:

$classes_exist = class_exists( 'Tribe__Events__Main' ) && class_exists( 'Tribe__Events__Community__Main' );

This happen because PHP 5.3 and 5.4 manage in different ways the comparison for functions, we add a temporary patch:

if (version_compare(phpversion(), '5.4', '<')) {

	print "[Tribe Community Events] Warning: PHP version lower than  5.4" . PHP_EOL;

	$classes_exist_events = class_exists( 'Tribe__Events__Main' );
	$classes_exist_events_community = class_exists( 'Tribe__Events__Community__Main' );

	$classes_exist = $classes_exist_events && $classes_exist_events_community;

} else {

	$classes_exist = class_exists( 'Tribe__Events__Main' ) && class_exists( 'Tribe__Events__Community__Main' );

}

And we wait for a official release containing the check will be released to avoid problems on future updates.

– – –

After debug the plugin: The Events Calendar v4.5.10.1 we found the source of the problem and it’s a bad implementation for SQL queries, original problematic query made by plugin:

SELECT  DISTINCT greaterpocono_posts.*, 
        MIN(greaterpocono_postmeta.meta_value) as EventStartDate, 
        MIN(tribe_event_end_date.meta_value) as EventEndDate 
FROM greaterpocono_posts  
LEFT JOIN greaterpocono_term_relationships ON (greaterpocono_posts.ID = greaterpocono_term_relationships.object_id) 
LEFT JOIN greaterpocono_postmeta as tribe_event_end_date ON ( greaterpocono_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' )  
WHERE 1=1  
AND (greaterpocono_term_relationships.term_taxonomy_id IN (25)) 
AND greaterpocono_posts.post_type = 'tribe_events' 
AND (greaterpocono_posts.post_status = 'publish' OR greaterpocono_posts.post_status = 'expired' 
        OR greaterpocono_posts.post_status = 'tribe-ea-success' 
        OR greaterpocono_posts.post_status = 'tribe-ea-failed' 
        OR greaterpocono_posts.post_status = 'tribe-ea-schedule' 
        OR greaterpocono_posts.post_status = 'tribe-ea-pending' 
        OR greaterpocono_posts.post_status = 'tribe-ea-draft' 
        OR greaterpocono_posts.post_status = 'new' 
        OR greaterpocono_posts.post_status = 'interviewed' 
        OR greaterpocono_posts.post_status = 'offer' 
        OR greaterpocono_posts.post_status = 'hired' 
        OR greaterpocono_posts.post_status = 'archived' 
        OR greaterpocono_posts.post_status = 'private') 
GROUP BY greaterpocono_posts.ID 
ORDER BY EventStartDate DESC, greaterpocono_posts.post_date DESC 
LIMIT 0, 1

Please pay attention to these lines:

Problematic Line: MIN(greaterpocono_postmeta.meta_value) as EventStartDate,
Source of Problem: LEFT JOIN greaterpocono_postmeta as tribe_event_end_date ON ( greaterpocono_posts.ID = tribe_event_end_date.post_id 

The propper way in which this SQL query run should be this:

SELECT  DISTINCT greaterpocono_posts.*, 
        MIN(tribe_event_end_date.meta_value) as EventStartDate, 
        MIN(tribe_event_end_date.meta_value) as EventEndDate 
FROM greaterpocono_posts  
LEFT JOIN greaterpocono_term_relationships ON (greaterpocono_posts.ID = greaterpocono_term_relationships.object_id) 
LEFT JOIN greaterpocono_postmeta as tribe_event_end_date ON ( greaterpocono_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDate' )  
WHERE 1=1  
AND (greaterpocono_term_relationships.term_taxonomy_id IN (25)) 
AND greaterpocono_posts.post_type = 'tribe_events' 
AND (greaterpocono_posts.post_status = 'publish' OR greaterpocono_posts.post_status = 'expired' 
        OR greaterpocono_posts.post_status = 'tribe-ea-success' 
        OR greaterpocono_posts.post_status = 'tribe-ea-failed' 
        OR greaterpocono_posts.post_status = 'tribe-ea-schedule' 
        OR greaterpocono_posts.post_status = 'tribe-ea-pending' 
        OR greaterpocono_posts.post_status = 'tribe-ea-draft' 
        OR greaterpocono_posts.post_status = 'new' 
        OR greaterpocono_posts.post_status = 'interviewed' 
        OR greaterpocono_posts.post_status = 'offer' 
        OR greaterpocono_posts.post_status = 'hired' 
        OR greaterpocono_posts.post_status = 'archived' 
        OR greaterpocono_posts.post_status = 'private') 
GROUP BY greaterpocono_posts.ID 
ORDER BY EventStartDate DESC, greaterpocono_posts.post_date DESC 
LIMIT 0, 1 

Changing “greaterpocono_postmeta” by “tribe_event_end_date” where “greaterpocono_” is our WordPress Prefix set in configs (FYI)

As the previous plugin we wait an official update fixing this problem hence we can avoid as much as possible made custom fixes to overcome this error.

– – –

Thanks.

[Konrad Nierwinski]

Thanks for the clearly response this is was I looking for the default category.

Also I hope you implement the user notification for the next updates of the plugin.

[Konrad Nierwinski]

Hi have passed 4 days since I put my last question, please I need an answer.

[Konrad Nierwinski]

Can you please explain here in this post, how or where add the jquery

jQuery(“#tribe_events_cat-6”).prop(‘checked’, true);

and please don’t send me to another post to investigate where add it.

[Konrad Nierwinski]

My issue was resolved, thanks.

[Konrad Nierwinski]

I just found a solution thanks.

• This reply was modified 8 years, 9 months ago by Konrad Nierwinski.

[Konrad Nierwinski]

Please there’s a faster way to get support like a chat or phone call this is a very slow process and I need support to get a faster solution to my problem.

• This reply was modified 8 years, 9 months ago by Konrad Nierwinski.

[Konrad Nierwinski]

Hi of course here are a link from the event
http://dev.creative-works.us:11059/w/Greater-Pocono-Chamber/event/event-test-01

and the screenshot from the event backend
http://dev.creative-works.us:11059/errors/event-ticket-dont-show.jpg

please if you need anything else please let me know.

[Author]

Posts