This article provides step by step instruction on how to recover YouTube ShowCase Professional WordPress plugin video comments not getting displayed on the frontend but shows up on the backend video editor page.
To be able to follow the instructions, you must have access to your WordPress database using phpMyAdmin or a similar tool.
It is always a good practice to backup your database before you run any code on your database. You can always go back if you make a mistake.
SELECT a.* FROM `wp_comments` a JOIN wp_posts b WHERE a.comment_post_id=b.id AND b.post_type="emd_video"
If your WordPress database table prefix is different than "wp_", replace all instances of "wp_" on the code above with the correct prefix before running the query.
Please check out the attached image for visual instructions.
In case, the query at Step #4 does not display your missing comments, you have a more complex issue. Please contact our support for assistance.