SQL error on /admin/quiz/settings/quiz_form: 'aid' field doesn't have default value

We get this too: 'aid' field doesn't have default value. It prevents me saving admin/quiz/settings/quiz_form.

Related to:

• #1281456: Errors in saving Quiz form configuration options
• #922316: Error on saving admin/quiz/settings/quiz_form

Probably a dupe of of #922316: Error on saving admin/quiz/settings/quiz_form except the 'aid' field is complaining, not the 'nid' field.

We went from 3.x to 4.0 branch, then from 4.0 to 4.3... Did we miss a schema update?

Further to my last, I believe the call that causes the issue is drupal_write_record('quiz_user_settings', $node, $update); on in quiz.module, line 3950.

I updated the quiz_admin_node_form_submit() preparation function on line 324 of quiz.admin.inc and added a default value with this line of code: $form_state['values']['aid'] = '';

So the function should look like:

function quiz_admin_node_form_submit($form, &$form_state) {
  // We add the uid for the "default user"
  $form_state['values']['save_def_uid'] = variable_get('quiz_def_uid', NULL);
  $form_state['values']['nid'] = 0;
  $form_state['values']['vid'] = 0;
  $form_state['values']['aid'] = '';
  _quiz_save_user_settings($form_state['values']);
}

Works for me, I can now save that form.

Thanks