WordPress database error You have an error in your SQL syntax

  • Resolved dnsss

    (@dnsss)


    1 year, 5 months ago

    Hi,

    I saw the following message in the error log.

    WP 6.6.2
    PHP8.2
    MySQL8.0.36

    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 'system, randomness_order, loggedin_user_contact, show_score, send_user_email, se' at line 1 for query SELECT quiz_name, quiz_system AS system, randomness_order, loggedin_user_contact, show_score, send_user_email, send_admin_email, contact_info_location, user_name, user_comp, user_email, user_phone, comment_section, question_from_total, total_user_tries, certificate_template, pagination, timer_limit, question_numbering, theme_selected, last_activity, require_log_in, limit_total_entries, disable_answer_onselect, ajax_show_correct, quiz_views, quiz_taken\n\t\t\tFROM wp_mlw_quizzes\n\t\t\tWHERE deleted = 0 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, QSM_Tracking->track_check, QSM_Tracking->load_data,
Viewing 6 replies - 1 through 6 (of 6 total)
  • dhanush22

    (@dhanush22)

    1 year, 5 months ago

    Hi @dnsss ,

    I hope this message finds you well.

    Thank you for sharing the exact log details regarding the issue you’re facing. This information is highly appreciated, as it helps us better understand the problem.

    In the meantime, could you please confirm if you are using the latest version of the Quiz and Survey Master (QSM) plugin? If not, I recommend updating to the latest version, as it may resolve the issue.

    Regarding the WordPress database error, we are currently discussing this matter with our development team. Once we identify the root cause and implement a fix, we will update you promptly. Should we require any additional details from your end, we will reach out to you.

    Thank you for your patience and cooperation. Please let me know if there is anything else I can assist you with in the meantime.

    Best regards,
    Dhanush

    Thread Starter dnsss

    (@dnsss)

    1 year, 5 months ago

    Hi,

    I am using this version of the plugin.

    Quiz And Survey Master : 9.2.2
    QSM – Export Results : 1.8.0

    • This reply was modified 1 year, 5 months ago by dnsss.
    dhanush22

    (@dhanush22)

    1 year, 5 months ago

    Hi @dnsss ,

    Thank you for your prompt response and for providing the requested details. We sincerely appreciate your assistance.

    The issue has been escalated to our development team for further investigation. We will keep you updated on their progress and inform you if any additional details are required.

    Thank you for your time, cooperation, and support. Please don’t hesitate to reach out if you have any questions in the meantime.

    Best regards,
    Dhanush

    Thread Starter dnsss

    (@dnsss)

    1 year, 5 months ago

    Hi,

    I got the same error message after updating a plugin.

    QSM 9.2.3

    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 'system, randomness_order, loggedin_user_contact, show_score, send_user_email, se' at line 1 for query SELECT quiz_name, quiz_system AS system, randomness_order, loggedin_user_contact, show_score, send_user_email, send_admin_email, contact_info_location, user_name, user_comp, user_email, user_phone, comment_section, question_from_total, total_user_tries, certificate_template, pagination, timer_limit, question_numbering, theme_selected, last_activity, require_log_in, limit_total_entries, disable_answer_onselect, ajax_show_correct, quiz_views, quiz_taken\n\t\t\tFROM wp_mlw_quizzes\n\t\t\tWHERE deleted = 0 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, QSM_Tracking->track_check, QSM_Tracking->load_data, referer: https://path/to
    dhanush22

    (@dhanush22)

    1 year, 5 months ago

    Hi @dnsss ,

    I hope this email finds you well. Apologies for the delay in getting back to you.

    Thank you for updating the plugin to its latest version and for informing us about the error message you’re still encountering post-update.

    Currently, our team is actively investigating this issue. We are committed to resolving it promptly and will provide you with an update as soon as we have a solution.

    We sincerely appreciate your cooperation and patience in this matter.

    If you have any additional details or questions in the meantime, please don’t hesitate to reach out.

    Warm regards,
    Dhanush

    dhanush22

    (@dhanush22)

    1 year, 2 months ago

    Hi @dnsss ,

    I hope you’re doing well. My apologies for the delayed response.

    I wanted to inform you that we have launched the latest version of the QSM plugin, 10.0.2. I assume you may have already updated it, but if not, please ensure you upgrade to the latest version.

    This update resolves the SQM syntax error and introduces several new enhancements to improve functionality.

    If you encounter any issues or require assistance, please feel free to create a support ticket, and I will be happy to assist you further.

    Thank you for your valuable time and cooperation—I truly appreciate it.

    Best regards,
    Dhanush

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘WordPress database error You have an error in your SQL syntax’ is closed to new replies.