Error Code 0001 when creating new quiz (solved)

  • Resolved randam

    (@randam)


    4 years, 8 months ago

    When installing Quiz and Survey Master, I got Error Code 0001. When inspecting my WordPress database, I noticed that the table wp_mlw_quizzes was not created.

    I checked the code for the CREATE TABLE query and found that the reason the table wasn’t created, is that the query has a reserved word in it.

    Replacing system with system in the query and then running it, solved the problem.

    Not sure why this is a problem in my specific case. I guess it depends on the MySQL version. Mine is 8.0.19.

    Hopefully this helps someone else. Also would be good if the plugin maintainers patch this in the next release.

    Cheers and thanks for the awesome plugin!

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

  • I’m having the same issue. Could your provide more specifics or a step by step in where you made this change? THanks!

    Thread Starter randam

    (@randam)

    In the plugin’s files, look for the following php file:

    php/classes/class-qsm-install.php

    Here at line 945 there is a multiline CREATE TABLE statement. At line 963 it says system INT NOT NULL,.

    Make sure that system is enclosed in quotation marks (the same ones used to make code blocks on this website).

    Then deactivate and reactivate the plugin again.

    Hope this helps.

    • This reply was modified 4 years, 8 months ago by randam.

    Hi @randam,

    Thank you for looking into the code. I will forward your response to the development team.

    Kind regards,
    Kriti

    Hi! I have tried Randam’s solution but it didn’t work. Any ideas?

    Hi @streammediaevent,

    We have planned to fix this issue in the 7.0 version of the plugin update. And we will release the update soon.

    Regards,
    Kriti

    Hi, Kriti. I have the same problem and the @randam solution didn’t work. I have a premium bundle. Please I need a solution right now I can not wait to the new release

    Thank you

    Hi all,

    Please try and use the beta version of the QSM 7.0 https://quizandsurveymaster.com/quiz_master_next.zip. We have fixed this error in the beta version and we will officially release the version soon.

    Please let us know if you face any problem.

    Kind regards,
    Kriti

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error Code 0001 when creating new quiz (solved)’ is closed to new replies.