Database Errors

[learner4life]

Hi Guys, I am getting the following database errors in my error logs after updating. Can you please take a look and let me know how to fix them?

[learner4life]

• 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 'WHERE AND comment_parent IN (7054) ORDER BY comment_date_gmt ASC, comment_ID A' at line 1 for query WHERE AND comment_parent IN (7054) ORDER BY comment_date_gmt ASC, comment_ID ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/single-wplms-assignment.php'), comments_template, WP_Comment_Query->__construct, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->fill_descendants, referer: http://neostencil.com/unit/pavankumarias_30096_20160619/?id=30096
• 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 n0e0o7_postmeta as p LEFT JOIN n0e0o7_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 < 1466507801 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://neostencil.com/course/pavankumarias_30096/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 n0e0o7_postmeta as p LEFT JOIN n0e0o7_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 < 1466507801 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://neostencil.com/course/pavankumarias_30096/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 'WHERE AND comment_parent IN (7054) ORDER BY comment_date_gmt ASC, comment_ID A' at line 1 for query WHERE AND comment_parent IN (7054) ORDER BY comment_date_gmt ASC, comment_ID ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/single-wplms-assignment.php'), comments_template, WP_Comment_Query->__construct, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->fill_descendants, referer: http://neostencil.com/wp-admin/edit-comments.php
• WordPress database error Unknown column 'n0e0o7_postmeta.meta_value' in 'order clause' for query SELECT SQL_CALC_FOUND_ROWS n0e0o7_posts.ID FROM n0e0o7_posts WHERE 1=1 AND 0 GROUP BY n0e0o7_posts.ID ORDER BY n0e0o7_postmeta.meta_value+0 DESC, n0e0o7_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[learner4life]

More errors: Illegal string offset 'custom_css' in /var/www/html/wp-content/plugins/vibe-customtypes/metaboxes/library/vibe-editor.php

[Anshuman Sahu]

Unable to replicate the issue at my end .Can you please try repairing your database and also check if the wplms theme and all plugins are updated to the latest .

[learner4life]

Repaired the database and checked that all plugins are updated. Issue still persists. You can replicate the errors by going to assignment page and clicking on any assignment. You get various errors depending on how you interact with it. Such as the first error right upon opening the assignment. Others upon uploading and submitting the assignment.

[learner4life]

Similarly, if you go to any course review and edit the comment you get the following errors. PHP Warning: call_user_func_array() expects parameter 1 to be a valid callback, class 'WC_Meta_Box_Order_Reviews' not found in /var/www/html/wp-includes/plugin.php on line 235, referer: http://neostencil.com/wp-admin/comment.php?action=editcomment&c=7030 Note for any of the issues above you may or may not see something noticeable on the screen but all the errors are there and logged into my apache error logs file.

[Anshuman Sahu]

Okay i was only replicate one error when i am viewing the assignment as admin . [23-Jun-2016 11:40:19 UTC] 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 'WHERE  AND comment_parent IN (591,593)  ORDER BY comment_date_gmt ASC, comment_I' at line 1 for query   WHERE  AND comment_parent IN (591,593)  ORDER BY comment_date_gmt ASC, comment_ID ASC made by require('D:\xampp\htdocs\modern2\wp-blog-header.php'), require_once('D:\xampp\htdocs\modern2\wp-includes\template-loader.php'), include('D:\xampp\htdocs\modern2\wp-content\themes\wplms_modern\single-wplms-assignment.php'), comments_template, WP_Comment_Query->__construct, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query->fill_descendants I searched about this and found this to be related to the wordpress comments caching itself . Please refer this link : https://core.trac.wordpress.org/ticket/36487

[Author]

Posts