Questions not showing in {{answers-table}}

  • I get the email after a quiz is submitted, but the Questions column is blank. I have all the answers, but it’s hard when half of them are yes and half no. I don’t remember what order my questions are in. Help?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Bob

    (@prasunsen)

    We can’t reproduce such problem here. The Questions column contains the questions as it should.

    Thread Starter mtsalikis

    (@mtsalikis)

    I tried it again this morning, and it’s still not doing it. Here is the link to the image of the email I got this morning.

    https://unitedmortgage.com/teamdiez/wp-content/uploads/2019/11/screenshot.png

    This is how I have it coded in the Final output section: {{result-title}} {{result-text}} {{answers-table}}

    Should I have it a different way?

    Plugin Author Bob

    (@prasunsen)

    Your variables look correct. Unfortunately I cannot reproduce and can’t think of any reason why the questions wouldn’t show for you.

    @mtsalikis

    I had the same issue. What I found to solve was going into the file for models/quiz.php

    I edited line 245-246

    $answers = $wpdb->get_results($wpdb->prepare("SELECT tUA.*, tC.choice as choice, tC.is_correct as choice_correct,
			>tQ.question as question, tQ.qtype as qtype

    to:

    $answers = $wpdb->get_results($wpdb->prepare("SELECT tUA.*, tC.choice as choice, tC.is_correct as choice_correct,
			tQ.title as question, tQ.qtype as qtype

    FROM:
    tQ.question as question
    TO:
    tQ.title as question
    I found in my SQL table that ‘question’ was empty and my questions were in ‘title’. So when the join happened the actual question didn’t get merged.

    • This reply was modified 5 years, 3 months ago by samFox.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Questions not showing in {{answers-table}}’ is closed to new replies.