pheisholt

Hi, @navipane

No, the problem is not resolved.

My conclusion is that the problem is caused by a bug in the NextGEN Gallery plugin. I have reported it multiple times. So far Imagely/NextGEN has done absolutely nothing about it, and I’m not very optimistic.

The way Imagely/NextGen has implemented their comments quite simply breaks the system. They have not disputed that it actually is a bug. But that does not seem to bother them.

I have not found a work-around – other than to regularly adjust the number of comments shown in the BRC widget.

-paul-

Hi

Thanks – that brings us one step closer.

This SQL picks out the 5 most recent comments based on comment_date_gmt. And in my case it lists 5 comment IDs – two of which are NextGEN image comments.

As you probably already have guessed, I don’t know the inner workings of WordPress, but this SQL only seems to fetch the comment IDs. So I’m assuming that these IDs are passed on to another function in order to actually display the comments in the widget.

Do you know which function that is, and if so which SQL query it triggers? My guess is that that SQL query may explain why the NextGEN comments are ignored – although they are present in the ID list from the get_comments() function.

-paul-

Hi

Thanks for the response.

Unfortunately, the comment_type doesn’t seem to be the problem here. The comment_type field is blank for absolutely all comments, including the NextGEN comments.

I can send you credentials to a test site, if you’re interested in taking a look at it yourself.

-paul-

Hi

NextGEN Gallery’s lightbox includes an option to enable comments. It’s a regular comment field with a submit button. You can see an example here: NextGEN Gallery Lightbox with comment field

The comments are stored in the wp-comments database table alongside all other comments (post, page etc.). And that’s obviously where the problem begins.

In the wp_comments table there doesn’t seem to be anything to distinguish between comments from different post types or from different taxonomies. But by joining the wp-comments and the wp-posts tables, one can determine which is which.

This SQL statement will separate the NGG comments (post_type=photocrati-comments) from other comments (post_type=post | page |...)

SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID
, comment_author, comment_date_gmt, comment_approved, comment_type
, comment_author_url, post_type, SUBSTRING(comment_content,1,30) AS com_excerpt 
FROM wp_comments 
LEFT OUTER JOIN wp_posts ON (wp_comments.comment_post_ID = wp_posts.ID) 
WHERE comment_approved = "1" AND comment_type = "" AND post_password = "" 
ORDER BY comment_date_gmt DESC LIMIT 10;

Hope this may be of some help.

I can send you screen shots, if you provide an email address or some other way to convey them to you.

Thanks for the response.

I’ve been in touch with Imagely and suggested that they consider creating a separate widget that will display the NGG image comments.

However, I still don’t understand the difference between these two types of comments – especially since they appear jointly in WP Control Panel | Comments. So it appears that WP is able to identify the NGG comments and list them alongside regular post comments.