Quizzes not imported from database-Huge, huge bug!!

  • Resolved dadrian50

    (@dadrian50)


    1 year, 4 months ago

    After the recent update, the QSM->Quizzes ^ Surveys page no longer contains any quizzes.
    All quizzes are in the database but none are loaded in the interface.
    I cannot reproduce exactly because I have already created many new quizzes and I am afraid that they will disappear from the interface again. But I can post two photos.
    None of the quizzes from 8 to 63 are loaded in the admin page, but they exist in the database. The quizzes in the admin page are the new ones, from 63 to 84. It is interesting that the questions can be imported from the quizzes existing in the database but which do not appear in the admin interface.
    I think that your plugin keeps somewhere, outside the database, a list of existing quizzes, which is totally wrong. Otherwise, I don’t understand why a quiz import function from the database cannot import those quizzes.
    This is a huge bug and it makes me not to make any updates in the future.

    https://drive.google.com/file/d/1e0xbBKOz8OeE_rtSgp0fZvUVdVuDqf5u/view?usp=drive_link

    https://drive.google.com/file/d/1sB3gQ3JjC33zmDiiMvZuveSTkHDBDYUw/view?usp=drive_link

    • This topic was modified 1 year, 4 months ago by dadrian50.
Viewing 7 replies - 1 through 7 (of 7 total)
  • dhanush22

    (@dhanush22)

    1 year, 4 months ago

    Hi @dadrian50 ,

    I hope this email finds you well. I apologize for the delay in responding and any inconvenience caused by the recent updates.

    Regarding your query about the quizzes and surveys section in the admin area:

    1. Could you confirm if you are unable to view the complete list of quizzes in this section? Specifically, are quizzes numbered from 8 to 63 missing from the admin view?
    2. If so, I will check this functionality on our demo site, where we have created several quizzes, to verify and replicate the issue.
    3. If older quizzes are not visible in the admin section, we can provide steps to resolve the issue and ensure they appear correctly.

    It appears this issue arose after updating to the latest version. Such behavior might result from conflicts with plugins or themes. I recommend temporarily disabling plugins one by one to identify any conflicts. Similarly, switching to a default theme might help determine whether the issue is theme-related.

    If you require further clarification or have other concerns that need to be addressed, please feel free to reach out. I appreciate your patience and cooperation as we work toward a resolution.

    Thank you for your understanding and support.

    Best regards,
    Dhanush

    Thread Starter dadrian50

    (@dadrian50)

    1 year, 4 months ago

    yes, happens after the last update. Was no conflict before. I am afraid to test it again. I worked a lot to create my quizzes again.

    The problem is that two of them was imported, 8 and 26, the rest of them was not imported. I think the problem is more serious, because, after the update, all databases was also replaced with an empty ones. I always make backups of databases and after I replace them, was imported only two quizzes. I think you have to put some import/export plugin for free, even a very simple one, or the problems will affect a lot of people who doesn’t have knowledge about databases or they simply don’t have acces to them.

    Now I have quizzes Nr: 8, 26 and from 63 to 97.

    i cleaned up the dabase and now is all ok, so, I am not doing any test soon.

    By the way, the mess in the database is criminal. I am sure you know this things if you have some quizzes for tests. Just delete some quizzes and/or questions from them and look up in the database. But who know a little SQL and phpmyadmin can make a clean database.

    Thread Starter dadrian50

    (@dadrian50)

    1 year, 4 months ago

    Okay, here’s how it goes.
    My site is hosted by me through cloudflare. I recently installed another instance of wordpress on an M2 ssd, but I kept the old instance as well. I did well. I will keep that instance for tests.
    First thing noticed:
    When I switched to the new installation, there were 27 quizzes on the old site. I also imported the new databases there, which contain the 40 quizzes described previously, but still did not import them into the admin interface. They exist, you can import the questions from them, but in the admin interface it still shows me only the 27 old ones. And I disabled all other plugins. I don’t see any field, in any of the tables, that stores the site address. And, if that were the case, the 27 would be imported on the old site, but the 27 would not be imported on the new site. So the names of the 27 quizzes certainly exist somewhere outside the database. Absolutely all the 40 records in the database have exactly the same structure, they do not differ at all, so there is no logic why he kept only the 27. It is clear that he did not import them from the database. And onother proof is that when i made the transfer on a new instance, all 27 quizzes was perfectly ok. But the transfer was made with files from wp-content and databases, not only the databases and reinstall the plugin.
    If you say you have a tool to adjust this, that would be great. Otherwise, I don’t risk making any updates. It would be pure suicide to lose again 40 quizzes and have to remake them from the beginning. Especially correlated with the other problems: the questions are no longer in the same order, the import is erroneous etc.

    https://drive.google.com/file/d/1qUqwRn3mFzRKIcKEKWN0_W6o8I9s9LVs/view?usp=drive_link

    https://drive.google.com/file/d/13jV_7nv9__1iGOq2bLTuemkhrFdtkRnX/view?usp=drive_link

    • This reply was modified 1 year, 4 months ago by dadrian50.
    • This reply was modified 1 year, 4 months ago by dadrian50.
    dhanush22

    (@dhanush22)

    1 year, 4 months ago

    Hi @dadrian50 ,

    I hope this message finds you well. Apologies for the delayed response, and thank you for providing detailed information about the issue you’re experiencing, along with the screenshots.

    From your explanation and the provided screenshots, I understand that you are encountering an issue with the latest version of the QSM plugin. Specifically, when importing a new database containing 40 quizzes, not all quizzes are visible in the admin interface; it only displays 27 old quizzes. Additionally, the imported quizzes are not appearing as expected.

    To better understand and resolve this issue, could you please confirm if you are still experiencing the problem after importing the database with 40 quizzes? If possible, we kindly request a screencast of the exact issue, demonstrating the steps you’ve taken during the database import process and showing the discrepancies in the admin interface. This will help us identify the root cause more effectively.

    We appreciate your feedback and commitment to improving your experience with the plugin. Your input is invaluable to our development team as we work toward addressing such concerns in future updates.

    As a temporary measure, we understand that you are currently using a downgraded version of the QSM plugin to avoid further complications. While this is a practical workaround, sharing the requested screencast will greatly assist in ensuring a permanent resolution.

    Thank you for your time and cooperation. Please don’t hesitate to reach out if you have further questions or need additional support.

    Best regards,
    Dhanush

    Thread Starter dadrian50

    (@dadrian50)

    1 year, 4 months ago

    I will write you all steps:

    I upgraded to the last version. All databases was replaced with new once, which os not normal. Then I replace all databases with my backups databases. Then, in the admin panel appear only 3 quizzes. I recreate quizzes until I made up 27 of them. Then I move the site on M2ssd but I keeped the old sire also. I continued to create quizzes on the new site until I made up 40 quizzes.

    then after your messege, I decided to test on the old site. So, the old site have had 27 quizzes and a database with 27 quizzes. I replaced all databases with the tables from the new site. All of them. Practically, the old site should suppose to look exactly like the new one. But, surprize, the old site show still only 27 quizzes even if the tables contain all 40 and all questions like the new site.

    idowndraged version. I say that, in the future, I will not update because I am afraid to not loose again all 40 quizzes.

    But I can’t explain why, after upgrade, all informations in the tables was vanished. Was a real shock. Was like complete uninstalling, erasind all tables, and install from scratch. This was not normal. And I don’t know why this problem was not reported by others. This is very strange.

    I can’t reproduce the problem because the databases are the same, all tables are the same on both site. But one site, the old one, shows 27 quizzes and the main site shows 40.

    Ok, you says that you can guide me to properly import all quizzes that are existing in the database, to appear in the interface. So, you că write all steps here and i can test it. Is the perfect time, the tables contain 40 quizzes and in admin QSM I have only 27. If it works and if I succed to have all 40 again, I will know that I will upgrade future with no trouble.

    Thank you.

    Thread Starter dadrian50

    (@dadrian50)

    1 year, 3 months ago

    I think I managed to find where the problem is.
    Let’s see an example. Let’s say that quiz 104 is visible in the admin interface but 105 is not visible (it is not imported)
    …/admin.php?page=mlw_quiz_options&quiz_id=104
    If I replace, manually, 104 with 105 in the link, the quiz opens for editing, but it does not have any link to “settings”, which is kept in the table “wp..post” and “wp.._postmeta”, as in this example: …post.php?post=3100&action=edit. If I press “settings” on the ghost quiz, opened by manually entering the id, no editing interface opens. So be careful how and when you change the permalinks in wordpress. The solution is to import the backup of the wp.._post and wp.._postmeta tables in addition to those related to the plugin …_mlw…

    dhanush22

    (@dhanush22)

    1 year, 3 months ago

    Hi @dadrian50 ,

    I hope this email finds you well.

    I truly appreciate the effort you’ve put into identifying the root cause of the issue and exploring potential solutions. Your proactive approach is commendable.

    To ensure better understanding and to replicate the issue accurately on our end, would it be possible for you to share a screencast or video demonstration? Specifically, it would be helpful to see the steps for manually replacing or importing the quiz. This will help us avoid similar challenges in future updates and streamline the resolution process.

    Thank you once again for your cooperation and support.

    Please let me know if there’s anything else you need from my side.

    Best regards,
    Dhanush

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

The topic ‘Quizzes not imported from database-Huge, huge bug!!’ is closed to new replies.