Jonathan

Update 2016-06-24: There’s a (partial?) resolution to this issue noted in a different thread at The Events Calendar support. That thread includes a code snippet (which you can add, for example, to your theme’s functions.php, on a temporary basis).

The code snippet appears to have resolved the issues on my site, though I’m still testing it and reports from others vary. A future Events Calendar version is promised addressing the issue more robustly.

Absolutely the same problem here. Bit of a nightmare for me, and I’m not sure how to go about resolving.

[update: There’s a report on this issue in The Events Calendar support forums, here. I’ll monitor that thread and post any resolution here, but the take-home is that it may not be Featured Video Plus that’s at fault; it could be The Events Calendar.]

[facepalm]

Same issue here. I’m an idiot. Thanks for the ‘fix’, Kevin – working smoothly now. ??

I hate to say this, MtDew, but there still seems to be a tiny goof in the SQL; my install throws an error unless I change LEFT JOIN tableposts to LEFT JOIN $tableposts. Then it works just fine; the AND -> WHERE substitution does exactly what it should. Dang, I should have spotted that. ??
Big thanks for the plugin, I’d never have got near on my own!

Yet another followup to my own post; in the distribution v1.11, comment_approved appears to be ignored in the SQL select, so comments in the moderation queue appear in the list (though the link goes to the entry, since the comment isn’t visible).
I couldn’t unpick the SQL to fix this, so added a kludge; the start of my foreach loop now reads:

foreach ($comments as $comment) {
$comment_approved = ($comment->comment_approved);
if (!$comment_approved) continue;
$comment_author = stripslashes($comment->comment_author);

That is, if comment_approved is 0, the current pass through the loop is jumped. This produces the expected result for me.

Aha! I think I’ve fixed it by blundering around. First, I tweaked the global line to:

global $wpdb, $tablecomments, $tableposts;

Then in the next line, add a $ before tablecomments LEFT JOIN. This seems to work for me.

I’ve installed the Recent Comments plugin, but it’s throwing a database error:

[You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LEFT JOIN tableposts ON .ID=.comment_post_ID AND post_status = ]
SELECT ID, comment_ID, comment_content, comment_author, post_title FROM LEFT JOIN tableposts ON .ID=.comment_post_ID AND post_status = ‘publish’ AND post_password =” AND comment_approved = ‘1’ ORDER BY comment_ID DESC LIMIT 5

Sorry, my SQL is somewhat rusty, and I don’t think I ever did get my head around LEFT JOIN. Anyone care to help?