Multiple error in console

Information in Debug log [14-Sep-2020 17:30:31 UTC] WordPress database error Unknown column 'date' in 'order clause' for query SELECT count(*) as count FROM wp_09e86fc6c9_posts as posts LEFT JOIN wp_09e86fc6c9_postmeta as meta on posts.id = meta.post_id LEFT JOIN wp_09e86fc6c9_postmeta as meta2 on posts.id = meta2.post_id WHERE meta.meta_key LIKE 'payout_1' AND meta2.meta_key LIKE 'currency_1' AND YEAR(posts.post_date_gmt) = YEAR(CURRENT_TIMESTAMP) ORDER BY date ASC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Wplms_Commissions_API->get_instructor_payouts

You may have replied for some other query here. The problem I have reported was fixed with the following method. We are however worried that the change would be overwritten when we update the plugins from WPLMS so please implement the fix at your end. The commissions page console error for wolmscommissions.js is still present but database error is now fixed The error occurs due to an incorrect query in the function get_instructor_payouts in the file vibe-course-module/includes/api/class-api-commissions.php around line 521. $count = $wpdb->get_results( " SELECT count(*) as count FROM {$wpdb->posts} as posts LEFT JOIN {$wpdb->postmeta} as meta on posts.id = meta.post_id LEFT JOIN {$wpdb->postmeta} as meta2 on posts.id = meta2.post_id WHERE meta.meta_key LIKE 'payout_".$user_id."' AND meta2.meta_key LIKE 'currency_".$user_id."' ".$and_where." ORDER BY date ASC LIMIT ".$offset.", ".$per_page,ARRAY_A); Changing the query to the following will fix the issue $count = $wpdb->get_results( " SELECT count(*) as count FROM {$wpdb->posts} as posts LEFT JOIN {$wpdb->postmeta} as meta on posts.id = meta.post_id LEFT JOIN {$wpdb->postmeta} as meta2 on posts.id = meta2.post_id WHERE meta.meta_key LIKE 'payout_".$user_id."' AND meta2.meta_key LIKE 'currency_".$user_id."' ".$and_where." ORDER BY posts.post_date_gmt ASC LIMIT ".$offset.", ".$per_page,ARRAY_A);

Thank you for the explanation Alex. Much appreciated. However, we still see the error on Commissions page when you login as tutor. Will this be fixed with your next update too?

Hi Alex we have made that update but still there is error in commission.js wplms_commissions.js?ver=3.9.9.4:5 Uncaught (in promise) SyntaxError: Unexpected end of JSON input at wplms_commissions.js?ver=3.9.9.4:5 Also shows: Uncaught SyntaxError: Unexpected token '=' leading to the line 433 below window.instructor_commission_data.=[];