• Resolved npg1

    (@npg1)


    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?

    https://ww.wp.xz.cn/plugins/watu/

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database error when saving new quiz’ is closed to new replies.