Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error Logged in debug.log #230

Open
sharmashivanand opened this issue Oct 8, 2022 · 0 comments
Open

Error Logged in debug.log #230

sharmashivanand opened this issue Oct 8, 2022 · 0 comments

Comments

@sharmashivanand
Copy link

sharmashivanand commented Oct 8, 2022

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
...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant