HD Quiz

Need to send invoices?
Check out my new WordPress plugin HDInvoice
Limited time launch sale

Hi Dylan, I have an issue with HD Quiz Results – Light. …

Published: April 16, 2020
Support status: closed

Hi Dylan,

I have an issue with HD Quiz Results – Light. I’ve seen that I have only the latest 2 days results displayed. There is any method how to read/search in the database the previous results? I have some backups from previous days so I could try to find that results even if the previous results are deleted from the current database.

Thank you,


This thread has been imported from harmonicdesign.ca/hd-quiz/

thread author: Florin

Hi Florin,
I recommend downloading the database backup, then using your favourite text editor (Sublime Text is super light weight and fast), do a search for hdq_quiz_results_l. You should then see the results as a JSON formatted string. Something like this:

        "quizID": 1,
        "score": [8,10],
        "PassPercentage": "70",
16 April 2020 — 13:55 support admin - Dylan

Hi and thank you Dylan, I’ve found everything!

Strange, all results are still there in the current database, but only the last 2 days are displayed in the dashboard.


17 April 2020 — 02:41 thread author - Florin

Hmmm… perhaps there is a “special” character in your data that is breaking the JSON string. Also, the page will only show the most recent 500 results to stop the page from being stupidly long. Do you by chance have over 500 entries in the last two days?

If it’s OK with you, could you please post the JSON string to https://pastebin.com/

I can take a look and see if there is an errant character breaking the string. If there is, I can clean it for you and update the plugin to stop it from breaking again in the future

19 April 2020 — 19:10 support admin - Dylan

Aha! That’s the answer, I do have way more than 500 entries 🙂 (there are some school tests for pupils in pandemic time).

Thank you very much Dylan, I am able to manage this now, knowing where to get the results.


20 April 2020 — 05:38 thread author - Florin

If you are enjoying HD Quiz please leave a review here on the official WordPress.org page. HD Quiz is developed by me, just some dude, and is supported and available for free. It may seem dumb, but truly nothing makes me happier than knowing that people are using and loving HD Quiz and my hard work.

This thread has either been marked as complete or has been automatically closed due to inactivity.