Database error when saving new quiz
-
Hi, I am trying to create a new quiz but get a database error when I save it:
WordPress database error: [Column count doesn’t match value count at row 1]
INSERT INTO b4ud_watu_master (name, description, final_screen, added_on, randomize, single_page, show_answers, require_login, notify_admin, randomize_answers) VALUES ('Quiz test', '', '<p>Congratulations - you have completed %%QUIZ_NAME%%.</p>\n\n\r\n<p>You scored %%POINTS%% points out of %%MAX-POINTS%% points total.</p>\r\n\r\n<p>Your performance have been rated as <b>%%RATING%%</b>.</p>\r\n\r\n<p>Your obtained grade is <b>%%GRADE-TITLE%%</b></p><p>%%GRADE-DESCRIPTION%%</p>', NOW(), 0, 1, 1, 0, 0)This seems to be an error in the SQL statement the plugin uses as there are 10 columns referenced in the insert but only 9 values provided.
The quiz is actually saving and it appears on the site, but it does not appear under Tools->Watu Exams so I am unable to edit or delete it after it has been created.
Any idea what is going wrong?
The topic ‘Database error when saving new quiz’ is closed to new replies.