Quiz_tblUserQuizResponses Problem

  • It’s about 2 weeks that I have a problem with he database. In log file I find this error

    WordPress errore sul database You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 1 per la query Select * FROM qa_AI_Quiz_tblUserQuizResponses WHERE userAttemptID= fatta da require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/disto/single.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, qtl_quiz_draw->startQuiz, qtl_quiz_draw::drawQuizPage, qtl_quiz_draw::markTest, qtl_queries::getUserAttemptInfo

    I updated template and all other plugin
    How can I fix it?
    Is there a way to stop saving user response?

    Thanks

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Alex Furr

    (@alexfurr)

    Hi – sorry to hear about the problems you’ve been having.

    Is this happening when you try to take a quiz, or on another page?
    Are you able to send me a link to the page in question, many thanks.

    Best wishes,
    Alex

    Thread Starter giufalab

    (@giufalab)

    This happens in different time, usually when there was many visitors. It takes down the site and after several minutes works again.

    My website is https://www.quizammissione.it

    • This reply was modified 5 years, 6 months ago by giufalab.
    Thread Starter giufalab

    (@giufalab)

    It could be usefull disable user answers saving in the database (in AI_Quiz_tblUserQuiz Responses).
    This db table takes up too much space in few days with my daily users and I have to erase it manually.

    Thread Starter giufalab

    (@giufalab)

    any ideas?

    Plugin Author Alex Furr

    (@alexfurr)

    I’ve got a solution for you, but are comfortable to edit the code? I can send you the lines to comment out which would prevent any data being saved.
    I will also work on a fix that prevent all data being saved via an interface but won’t be soon.
    Best wishes,
    Alex

    Thread Starter giufalab

    (@giufalab)

    Yes, there are no problems.

    Thanks

    Plugin Author Alex Furr

    (@alexfurr)

    Hi,

    To stop *all* actions after a quiz has been submitted look in quizFrontEnd/draw.php
    Add the following at line 727 after the line $markedTest.= ‘</div>’;// end of exam div

    $readOnly=true;

    To simply stop the answers getting stored in the database you can comment out lines 730 to line 742 in the smae file – you will still receive emails etc.

    Best wishes,

    Alex

    Thread Starter giufalab

    (@giufalab)

    The line $markedTest.= ‘</div>’;// isn’t at 727 position.
    I found it previous. Is it right?

    // Get the grade boundary for this mark if it exists
				$boundaryFeedback = qtl_queries::getBoundaryFeedback($percentageScore, $quizID);
				$markedTest.=apply_filters('the_content', $boundaryFeedback);

				$markedTest.='</div>'; 

				$markedTest.= '</div>';// end of exam div
				$readOnly=true;

				if($readOnly==false)
				{

    What is written in the lines 730 to line 742?

    Thanks

    • This reply was modified 5 years, 6 months ago by giufalab.
    • This reply was modified 5 years, 6 months ago by giufalab.
Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Quiz_tblUserQuizResponses Problem’ is closed to new replies.