Database Errors on Clicking Submissions in Course Admin Page

[learner4life]

When I click on Submissions tab in the Course Admin (front-end) I get the following errors in my error logs. Can you let me know how to correct this?

• WordPress 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 ')' at line 1 for query SELECT count(*) FROM wp_postmeta as p LEFT JOIN wp_usermeta as u ON p.meta_key = u.user_id WHERE p.meta_value LIKE '0' AND u.meta_key = p.post_id AND u.meta_value < 1468475056 AND p.post_id IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, Vibe_CustomTypes_Permalinks->catch_vars, bp_get_template_part, bp_locate_template, load_template, require('/themes/wplms/course/single/home.php'), locate_template, load_template, require_once('/themes/wplms/course/single/admin.php'), locate_template, load_template, require_once('/themes/wplms/course/single/submissions.php'), bp_course_get_quiz_submission_count, referer: http://website.com/course/xyz/admin/
• WordPress 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 ') GROUP BY u.meta_key' at line 1 for query SELECT count(*) as count,u.meta_key as quiz_id FROM wp_postmeta as p LEFT JOIN wp_usermeta as u ON p.meta_key = u.user_id WHERE p.meta_value LIKE '0' AND u.meta_key = p.post_id AND u.meta_value < 1468475056 AND p.post_id IN () GROUP BY u.meta_key made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, Vibe_CustomTypes_Permalinks->catch_vars, bp_get_template_part, bp_locate_template, load_template, require('/themes/wplms/course/single/home.php'), locate_template, load_template, require_once('/themes/wplms/course/single/admin.php'), locate_template, load_template, require_once('/themes/wplms/course/single/submissions.php'), do_action('wplms_course_submission_quiz_tab_content'), call_user_func_array, BP_Course_Action->bp_course_get_course_quiz_submissions, referer: http://website.com/course/xyz/admin/

[Anshuman Sahu]

Yep this seems to be an issue in vibe course module plugin . thanks for reporting this . will be fixed in the next update of vibe course module plugin . Track here : https://trello.com/c/2lhlqewN/751-wordpress-database-error-in-error-log-when-there-is-no-quiz-in-course-and-user-opens-course-admin-submissions

[learner4life]

Thanks.. also note that it happens on stats as well WordPress 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 ')' at line 1 for query SELECT count(*) FROM wp_postmeta as p LEFT JOIN wp_usermeta as u ON p.meta_key = u.user_id WHERE p.meta_value LIKE '0' AND u.meta_key = p.post_id AND u.meta_value < 1468475805 AND p.post_id IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, Vibe_CustomTypes_Permalinks->catch_vars, bp_get_template_part, bp_locate_template, load_template, require('/themes/wplms/course/single/home.php'), locate_template, load_template, require_once('/themes/wplms/course/single/admin.php'), locate_template, load_template, require_once('/themes/wplms/course/single/submissions.php'), bp_course_get_quiz_submission_count, referer: http://website.com/course/xyz/admin/stats/ WordPress 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 ') GROUP BY u.meta_key' at line 1 for query SELECT count(*) as count,u.meta_key as quiz_id FROM wp_postmeta as p LEFT JOIN wp_usermeta as u ON p.meta_key = u.user_id WHERE p.meta_value LIKE '0' AND u.meta_key = p.post_id AND u.meta_value < 1468475805 AND p.post_id IN () GROUP BY u.meta_key made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, Vibe_CustomTypes_Permalinks->catch_vars, bp_get_template_part, bp_locate_template, load_template, require('/themes/wplms/course/single/home.php'), locate_template, load_template, require_once('/themes/wplms/course/single/admin.php'), locate_template, load_template, require_once('/themes/wplms/course/single/submissions.php'), do_action('wplms_course_submission_quiz_tab_content'), call_user_func_array, BP_Course_Action->bp_course_get_course_quiz_submissions, referer: http://website.com/course/xyz/admin/stats/

[Anshuman Sahu]

Well the origin of the error is same and  this had been added in the issue log will be fixed in the next update . Thanks again for pointing this .

[learner4life]

There was a Vibe Course Module update after your post but I believe it is not fixed in that one yet.

[Anshuman Sahu]

no these issue are still pending . Will be fixed in next update of vibe course module plugin ./  

[H.K. Latiyan]

This issue has been resolved in the latest update of wplms 2.2 So please update all your plugins and the wplms theme to the latest versions i.e. 2.2 and then check.

[learner4life]

Marking as fixed.

[Author]

Posts