raymond8505

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Forum: Plugins
    In reply to: [The Events Calendar] [tribe_mini_calendar] not working since update
    Thread Starter raymond8505

    (@raymond8505)

    6 years, 2 months ago

    Ive switched to the Twenty Nineteen theme and disabled all plugins but The Events Calendar. It appears that nowhere in The Events Calendar plugin directory is there an add_shortcode() call for the tag tribe_mini_calendar. The plugin WP Bakery Page Builder was, for some reason, not outputting anything for an unhooked shortcode tag, so now that it’s disabled the short code appears on the page raw, it doesn’t work.

    I have the Pro plugin as well and noticed it does register this shortcode, but enabling it does not fix the issue. This is a friend’s site so I’m not sure what his account status with you in regards to the Pro plugin is. Would that interfere with the registering of the shortcode?

    Forum: Plugins
    In reply to: [WP Instagram Widget] shortcode?
    Thread Starter raymond8505

    (@raymond8505)

    9 years, 8 months ago

    oh awesome, TIL about that plugin, thanks!

    Forum: Plugins
    In reply to: [The Events Calendar] No past events cant be viewed in list view
    Thread Starter raymond8505

    (@raymond8505)

    12 years, 4 months ago

    so, uh, updating to 3.3 of the plugin seems to have resolved that issue

    Forum: Plugins
    In reply to: [The Events Calendar] No past events cant be viewed in list view
    Thread Starter raymond8505

    (@raymond8505)

    12 years, 4 months ago

    version 3.0 of the plugin

    It’s a site I inherited responsibility for, so I’m not sure of the history, but it was already 3.0 when I got it

    I haven’t tried disabling the plugins, but the fact that the query generated returns 0 results when run in the console directly on the database suggests that won’t help

    The site is using WP Super Cache, but I have the cache disabled.

    I did some poking and prodding since I posted the question and narrowed it down to the fact that the “previous events” logic takes time of day into account and month view does not. When I removed that part of the query and ran it in the console against the database I got the expected events. Here’s the modified SQL

    SELECT
		SQL_CALC_FOUND_ROWS DISTINCT wp_posts.post_title,
		wp_postmeta.meta_value as EventStartDate,
		tribe_event_duration.meta_value as EventDuration,
		DATE_ADD(CAST(wp_postmeta.meta_value AS DATETIME), INTERVAL tribe_event_duration.meta_value SECOND) as EventEndDate
	FROM
		wp_posts
	INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
	LEFT JOIN wp_postmeta as tribe_event_duration ON ( wp_posts.ID = tribe_event_duration.post_id AND tribe_event_duration.meta_key = '_EventDuration' )
	WHERE 1=1
	AND wp_posts.post_type = 'tribe_events'
	AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')
	AND (wp_postmeta.meta_key = '_EventStartDate' )
	AND CAST(wp_postmeta.meta_value AS DATETIME) < '2013-12-14' ORDER BY DATE(wp_postmeta.meta_value) DESC, TIME(wp_postmeta.meta_value) DESC LIMIT 0, 10;

    So that leads me to believe it’s an issue with MySQL’s time math functionality. The issue exists both on the production server (v 5.5.35-log) and my local dev install (v 5.5.27)

Viewing 4 replies - 1 through 4 (of 4 total)