themeum/tutor

Error Logged in debug.log

Opened this issue · 0 comments

Handling a site for a client with WooCommerce installed alongside Tutor Pro. The following error repeatedly occurs.

[07-Oct-2022 02:21:35 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND course_id = 1767 AND result_for != 'final'' at line 4 for query SELECT wp_tutor_gradebooks_results .*, grade_config FROM wp_tutor_gradebooks_results LEFT JOIN wp_tutor_gradebooks ON wp_tutor_gradebooks_results.gradebook_id = wp_tutor_gradebooks.gradebook_id WHERE user_id = AND course_id = 1767 AND result_for != 'final' made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('woocommerce_scheduled_subscription_payment'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Subscriptions_Manager::prepare_renewal, WC_Subscriptions_Manager::process_renewal, WC_Subscription->update_status, WC_Order->save, WC_Subscription->status_transition, do_action('woocommerce_subscription_status_updated'), WP_Hook->do_action, WP_Hook->apply_filters, TUTOR_WCS\WCSubscriptions->update_enrollment_status, TUTOR\Utils->update_enrollments, TUTOR\Utils->delete_course_progress, do_action('delete_tutor_course_progress'), WP_Hook->do_action, WP_Hook->apply_filters, TUTOR_GB\GradeBook->gradebook_generate, get_generated_gradebook

The closest I can dig this is to /var/www/html/wp-content/plugins/tutor-pro/includes/functions.php: line 24 apparently user_id being 0, it's using an empty value in the SQL? (Not an SQL expert).

Active Plugins (amongst others)
...
tutor,active,none,2.0.10
tutor-lms-certificate-builder,active,none,1.0.0
tutor-lms-elementor-addons,active,none,2.0.5
tutor-pro,active,available,2.0.9
woocommerce,active,none,6.9.4
woocommerce-services,active,none,1.26.3
woocommerce-gateway-stripe,active,none,6.8.0
woocommerce-subscriptions,active,none,4.5.1
...