[04-Oct-2020 14:01:54 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 'as meta2
WHERE meta2.meta_key LIKE '' at line 2 for query
SELECT meta2.meta_value as currency
FROM as meta2
WHERE meta2.meta_key LIKE '_currency%'
GROUP BY meta2.meta_value
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, bp_template_redirect, do_action('bp_template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, bp_screens, do_action('bp_screens'), WP_Hook->do_action, WP_Hook->apply_filters, wplms_dashboard_template, bp_core_load_template, load_template, require_once('/themes/wplms/members/single/dashboard.php'), dynamic_sidebar, WP_Widget->display_callback, wplms_instructor_commission_stats->widget, wplms_instructor_commission_stats->get_currencies
Yes this is an issue and has been fixed in wplms dashboard plugin . Added another fix at your end please check now .
Can you recheck the fix. I believe this caused our site to break down and I had to restore a version from yesterday night.
Can you let me know what is the fix please so it can be applied on other sites too and repeated here. Please test this does not break the site though.
Yes I checked your error there was no error related to this .Site was working fine when I made this fix .
Currently there is another error which is causing this issue in your site related to db crash .
Please let me know what fix you made since I had to restore an older version and not sure if your fix is overwritten. Also need to replicate on other sites running wplms
This reply has been marked as private.