Results are not saved in database

Hi there,

As we aren’t experiencing this issue at our end so I request you to please make a video of the issue and share it with us. So that we can check it.

Regards,
Kriti

Here are the steps how to reproduce the problem:
1. Create a new quiz

2. Add a new page.

3. Create a new question:
3.a. question type: multiple choice
3.b. question text (984 chars):
“Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia, deserunt mollit.”
3.c. add 14 Responses (a.Response A, b.Response B,…., n.Response N)
3.d. mark one response as correct and assign it 1 point.

4. Press Save Question

5. Duplicate the question 124 times to have 125 questions.

6. Run the test. Respond to a single question (in order to quickly reproduce the problem) and press Submit.

7. The results are calculated and correctly shown after the test.

8. In admin, go to that quiz and try to see the results. The counter indicate there is a result entry, but when you want to see it there is nothing saved. The results are also missing from database. The option for quiz is to save the response in database (by default)

Hi there,

I reproduced the quiz by following the same steps mentioned by you in the above response. And the results were successfully recorded at the backend. I am also attaching a video with my response: https://drive.google.com/file/d/1A9HHgvmW0XYvgxrHunwOUE14HgXM0pWZ/view?usp=drivesdk

I request you to please check for plugin and theme conflict on your website. To do this, disable all the plugins at once and disable them one by one by checking the conflicting one. If this doesn’t resolve the issue then switch your website’s theme to a basic wordpress theme.

Please let me know whether this resolves the issue or not.

Regards,
Kriti

Hi,

The video link you sent is private so I cannot see it.
Anyway, I was able to find the problem by myself.
It was not about the theme nor other plugins. It is about the database table “results” which is “text” and after changing it to “LongText”, the results are correctly saved.
So if you have the same problem, just change the field type to longtext and it will solve the problem.

Hi,

I have shared the file with you. Now you can see it. Thanks for sharing the info if future users experience the same problem.

Hope the issue is resolved now.

Kind regards,
Kriti

Hi,

You could not reproduce the problem because you did not follow step 3c correctly.
You used short answers as:
A
B
C

I told you to use:
A. Response A
B. Response B
C. Response C

That would add more text characters so the limit would be reached.
In order to have “unlimited” questions and responses for your plugin, you need to change the type of the database table created by your plugin.
I hope you understand that and you will fix it so the others will not have the same problem.

Ok, let me do the same.