can’t create quiz
-
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.
-
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.
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`Is this a WP network installation?
as in multi site?. nope.
Then could you try to reactivate the plugin and see if this causes any errors
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 TABLE
60vf6m_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 TABLE60vf6m_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 TABLE60vf6m_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 TABLE60vf6m_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 TABLE60vf6m_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 TABLE60vf6m_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 FROM60vf6m_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 TABLE60vf6m_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 FROM60vf6m_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 TABLE60vf6m_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 FROM60vf6m_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 TABLE60vf6m_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 FROM60vf6m_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 TABLE60vf6m_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 FROM60vf6m_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 TABLE60vf6m_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`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.
@prasunsen thats great. installed update and seems to to be working. thanks!
- The topic ‘can’t create quiz’ is closed to new replies.