• Resolved jimmyphua

    (@jimmyphua)


    i’ve installed the plugin, but somehow am unable to create a quiz. input of title and saving the quiz only brought me back to to the same ‘Add/Edit Chained Quiz’ page. am on wp Version 5.7.2.

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

    (@prasunsen)

    You’ll need to enable debugging and see if there are any errors:

    https://wpforms.com/developers/how-to-enable-debugging-in-wordpress/

    If you find an error let us know what is it.

    Thread Starter jimmyphua

    (@jimmyphua)

    Thanks for your reply .the log as below. Hope you can help.

    `[12-Jul-2021 09:30:51 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_quizzes’ doesn’t exist for query SELECT tQ.*, COUNT(tC.id) as submissions
    FROM 60vf6m_chained_quizzes tQ LEFT JOIN 60vf6m_chained_completed tC ON tC.quiz_id = tQ.id AND tC.not_empty=1
    GROUP BY tQ.id ORDER BY tQ.id DESC made by do_action(‘toplevel_page_chained_quizzes’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuizQuizzes::manage, ChainedQuizQuizzes::list_quizzes
    [12-Jul-2021 09:30:58 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_quizzes’ doesn’t exist for query INSERT INTO 60vf6m_chained_quizzes SET
    title=’test’, output=’Congratulations, you completed the quiz!\r\n<h2>{{result-title}}</h2>\r\n{{result-text}}\r\n\r\nYou achieved {{points}} points from {{questions}} questions.’, email_admin=0, email_user=0, require_login=0, times_to_take=0,
    save_source_url=0, set_email_output=0, email_output=”, admin_email=’my email’, email_required=0 made by do_action(‘toplevel_page_chained_quizzes’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuizQuizzes::manage, ChainedQuizQuizzes::add_quiz, ChainedQuizQuiz->add`

    Plugin Author Bob

    (@prasunsen)

    Is this a WP network installation?

    Thread Starter jimmyphua

    (@jimmyphua)

    as in multi site?. nope.

    Plugin Author Bob

    (@prasunsen)

    Then could you try to reactivate the plugin and see if this causes any errors

    Thread Starter jimmyphua

    (@jimmyphua)

    The error in the debug.log as below.

    [12-Jul-2021 10:52:32 UTC] WordPress database error Unknown character set: 'utf8mb4' for query CREATE TABLE60vf6m_chained_quizzes` (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL DEFAULT ”,
    output TEXT
    ) DEFAULT CHARSET=utf8mb4; made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install
    [12-Jul-2021 10:52:32 UTC] WordPress database error Unknown character set: ‘utf8mb4’ for query CREATE TABLE 60vf6m_chained_questions (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    quiz_id INT UNSIGNED NOT NULL DEFAULT 0,
    title VARCHAR(255) NOT NULL DEFAULT ”,
    question TEXT,
    qtype VARCHAR(20) NOT NULL DEFAULT ”,
    rank INT UNSIGNED NOT NULL DEFAULT 0
    ) DEFAULT CHARSET=utf8mb4; made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install
    [12-Jul-2021 10:52:32 UTC] WordPress database error Unknown character set: ‘utf8mb4’ for query CREATE TABLE 60vf6m_chained_choices (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    quiz_id INT UNSIGNED NOT NULL DEFAULT 0,
    question_id INT UNSIGNED NOT NULL DEFAULT 0,
    choice TEXT,
    points DECIMAL(8,2) NOT NULL DEFAULT ‘0.00’,
    is_correct TINYINT UNSIGNED NOT NULL DEFAULT 0,
    goto VARCHAR(100) NOT NULL DEFAULT ‘next’
    ) DEFAULT CHARSET=utf8mb4; made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install
    [12-Jul-2021 10:52:32 UTC] WordPress database error Unknown character set: ‘utf8mb4’ for query CREATE TABLE 60vf6m_chained_results (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    quiz_id INT UNSIGNED NOT NULL DEFAULT 0,
    points_bottom DECIMAL(8,2) NOT NULL DEFAULT ‘0.00’,
    points_top DECIMAL(8,2) NOT NULL DEFAULT ‘0.00’,
    title VARCHAR(255) NOT NULL DEFAULT ”,
    description TEXT
    ) DEFAULT CHARSET=utf8mb4; made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install
    [12-Jul-2021 10:52:32 UTC] WordPress database error Unknown character set: ‘utf8mb4’ for query CREATE TABLE 60vf6m_chained_completed (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    quiz_id INT UNSIGNED NOT NULL DEFAULT 0,
    points DECIMAL(8,2) NOT NULL DEFAULT ‘0.00’,
    result_id INT UNSIGNED NOT NULL DEFAULT 0,
    datetime DATETIME,
    ip VARCHAR(30) NOT NULL DEFAULT ”,
    user_id INT UNSIGNED NOT NULL DEFAULT 0,
    snapshot TEXT
    ) DEFAULT CHARSET=utf8mb4; made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install
    [12-Jul-2021 10:52:32 UTC] WordPress database error Unknown character set: ‘utf8mb4’ for query CREATE TABLE 60vf6m_chained_user_answers (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    quiz_id INT UNSIGNED NOT NULL DEFAULT 0,
    completion_id INT UNSIGNED NOT NULL DEFAULT 0,
    question_id INT UNSIGNED NOT NULL DEFAULT 0,
    answer TEXT,
    points DECIMAL(8,2) NOT NULL DEFAULT ‘0.00’
    ) DEFAULT CHARSET=utf8mb4; made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_questions’ doesn’t exist for query SHOW COLUMNS FROM 60vf6m_chained_questions made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_questions’ doesn’t exist for query ALTER TABLE 60vf6m_chained_questions ADD autocontinue TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD sort_order INT UNSIGNED NOT NULL DEFAULT 0, ADD accept_comments TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD accept_comments_label VARCHAR(255) NOT NULL DEFAULT ” made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_results’ doesn’t exist for query SHOW COLUMNS FROM 60vf6m_chained_results made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_results’ doesn’t exist for query ALTER TABLE 60vf6m_chained_results ADD redirect_url VARCHAR(255) NOT NULL DEFAULT ” made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_user_answers’ doesn’t exist for query SHOW COLUMNS FROM 60vf6m_chained_user_answers made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_user_answers’ doesn’t exist for query ALTER TABLE 60vf6m_chained_user_answers ADD comments TEXT, ADD is_correct TINYINT UNSIGNED NOT NULL DEFAULT 0 made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_quizzes’ doesn’t exist for query SHOW COLUMNS FROM 60vf6m_chained_quizzes made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_quizzes’ doesn’t exist for query ALTER TABLE 60vf6m_chained_quizzes ADD email_admin TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD email_user TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD require_login TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD times_to_take INT UNSIGNED NOT NULL DEFAULT 0, ADD save_source_url TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD set_email_output TINYINT UNSIGNED NOT NULL DEFAULT 0, ADD email_output TEXT, ADD admin_email VARCHAR(255) NOT NULL DEFAULT ”, ADD email_required TINYINT UNSIGNED NOT NULL DEFAULT 0 made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_completed’ doesn’t exist for query SHOW COLUMNS FROM 60vf6m_chained_completed made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields
    [12-Jul-2021 10:52:32 UTC] WordPress database error Table ‘wp_wqh9x.60vf6m_chained_completed’ doesn’t exist for query ALTER TABLE 60vf6m_chained_completed ADD not_empty TINYINT NOT NULL DEFAULT 0, ADD source_url VARCHAR(255) NOT NULL DEFAULT ”, ADD email VARCHAR(255) NOT NULL DEFAULT ” made by activate_plugin, do_action(‘activate_chained-quiz/chained-quiz.php’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuiz::install, chainedquiz_add_db_fields`

    Plugin Author Bob

    (@prasunsen)

    OK, thanks. Version 1.2.5.1 should appear in your dashboard in few minutes. Apply the update, reactivate the plugin and the problems should be solved.

    Thread Starter jimmyphua

    (@jimmyphua)

    @prasunsen thats great. installed update and seems to to be working. thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘can’t create quiz’ is closed to new replies.