Your responses are not being saved in the database due to a technical issue

Hello @fatcho,

Thank you for providing more information on the problem you’re having, and I’m sorry you have to face?it. This appears to be an unusual issue, and please know that I have escalated it to my team. To help us investigate the problem, please provide us the error log file of the quiz you’re having trouble with, which will allow us to properly examine the faults.??

My team and I will do everything we can to help you in this scenario. We await your response.  

Warm regards,
QSM Support Team

I have the same problem. After submitting the answers to the quiz, I get the message: Your responses are not being saved in the database due to a technical issue.

Hello,

We want to express our gratitude for your patience as we looked into this issue.

Upon taking the quiz on your website, we didn’t encounter any errors. You can review the attached screen recording for your reference screencast . We suggest clearing your browser cache and providing a screen recording of the error you’re experiencing on your end. Additionally, enabling a debug log can help in diagnosing the issue further. You can find guidance on how to do this in the attached screenshot.https://snipboard.io/n6X7YT.jpg . Also, It would be greatly appreciated if you could provide us with a list of active plugins on your site.

Please give these steps a try and let us know how it goes.

Warm regards,
QSM Support Team

In my case the log shows: Error 0001 submission failed

The page I need help with: https://afpolska.pl/kuchnia-francuska/

Greetings @blindkl,

To assist you further in troubleshooting the issue you’re experiencing, we kindly request error log details.

To provide us with the necessary information, please follow these steps:
Navigate to QSM Logs.
Click on Error 001.
Scroll down the page.
Look for the bold letter “Error:”. Simply copy the error paragraph.

We await your response and are dedicated to resolving this matter for you.

Warm regards,
QSM Support Team

Error:Unknown column ‘page_url’ in ‘field list’ from INSERT INTO afl_mlw_results (quiz_id, quiz_name, quiz_system, point_score, correct_score, correct, total, name, business, email, phone, user, user_ip, time_taken, time_taken_real, quiz_results, deleted, unique_id, form_type, page_url, page_name) VALUES (6, ‘Kuchnia francuska’, 3, 3.000000, 50, 3, 6, ‘John’, ‘None’, ‘[email protected]’, ‘None’, 0, ‘152.58.94.227’, ’06:58:14 AM 05/10/2024′, ‘2024-05-10 06:58:14…

Hello @blindkl,

Thank you for sharing the details with us.

Upon reviewing your situation, it seems that your database user doesn’t have the required ALTER TABLE permission. As a result, the alter query cannot be executed successfully. You have two options to address this:

1. Grant the necessary permissions to your database user to allow ALTER TABLE operations.

2. Manually add the page_name and page_url columns to the afl_mlw_results table in your database.

Below is the SQL code to manually add the columns:

ALTER TABLE afl_mlw_results ADD page_name VARCHAR(255) NOT NULL;
ALTER TABLE afl_mlw_results ADD page_url VARCHAR(255) NOT NULL;

Please execute these SQL statements in your database management tool to create the page_name and page_url columns in the afl_mlw_results table.

We’re here to assist you further if you need any additional support.

Warm regards,
QSM Support Team

Thank you. Unfortunately I don’t know how to do it. I use phpmyadmin to manage my database.

Hi @blindkl ,

We’ve put together a detailed screen recording for you, which you can find at the link attached.

We hope this makes things easier for you.

Warm regards,

The QSM Support Team

https://progressive-kea-7efd0c.sites.expresstech.io/wp-content/uploads/2024/05/localhost-localhost-phpMyAdmin-5-2-0-1.mp4

Hi,

It works. Thank you a lot ??

Hello @blindkl,

I’m glad that we were able to help you. If you’re happy with the plugin and our customer support, we’d be grateful if you could take a minute to leave us your valuable review here: QSM Plugin Review

Thank you, and have a wonderful day!

Warm regards,

QSM Support Team

Hello,

Since we haven’t received any response from your end, I’ll be marking this ticket as resolved. However, please don’t hesitate to reach out to us if you have any further queries or require additional assistance. 

Thank you!

Hello @blindkl ,

We wanted to share some good news with you! We’ve just released QSM 9.0.2, which includes the fix for the issue you reported about responses not being saved in the database.

We kindly request you to update to this latest version and let us know if it resolves the problem for you. Your feedback means a lot to us and helps us improve our service.

Thank you sincerely for your patience and understanding throughout this process. If you have any questions or need further assistance, please don’t hesitate to reach out to us.

Warm regards,
Sadiya