I have installed the module and have created a question, checked the settings and then y try to take the test.

At the moment the question is showed to me, i get the following errors:

user warning:
Unknown column 'answer.original_filename' in 'field list' 
query: SELECT answer.original_filename, answer.filepath FROM quiz_assignment_user_answers answer WHERE question_nid = 75 AND question_vid = 154 AND result_id = 4 
in /home/gpsexp01/domains/gps-expert.nl/public_html/zelfstudie/sites/all/modules/quiz/question_types/quiz_assignment/quiz_assignment.classes.inc on line 253.

user warning: 
Unknown column 'answer.original_filename' in 'field list'
query: SELECT answer.original_filename, answer.filepath FROM quiz_assignment_user_answers answer WHERE question_nid = 75 AND question_vid = 154 AND result_id = 4 
in /home/gpsexp01/domains/gps-expert.nl/public_html/zelfstudie/sites/all/modules/quiz/question_types/quiz_assignment/quiz_assignment.classes.inc on line 253.

Looking into the code and the installation of the module, there is no mentioning of the column original_filename in the install module, and the column is missing in my sql table.

Continuing with uploading a file, gives an successful upload tot the file system, but the following error:

user warning: Unknown column 'answer.original_filename' in 'field list' 
query: SELECT answer.original_filename, answer.filepath FROM quiz_assignment_user_answers answer WHERE question_nid = 75 AND question_vid = 154 AND result_id = 4
in /home/gpsexp01/domains/gps-expert.nl/public_html/zelfstudie/sites/all/modules/quiz/question_types/quiz_assignment/quiz_assignment.classes.inc on line 570.

user warning: Unknown column 'original_filename' in 'field list' 
query: INSERT INTO quiz_assignment_user_answers (question_nid, question_vid, result_id, original_filename, filepath) VALUES (75, 154, 4, 'Retourrit.GPX', 'sites/default/files/quiz_assignment/nid75_vid154/751544_50812189706e8.gpx')
in /home/gpsexp01/domains/gps-expert.nl/public_html/zelfstudie/sites/all/modules/quiz/question_types/quiz_assignment/quiz_assignment.classes.inc on line 546.

Comments

anompi’s picture

Creation of the missing column solved my problem for my site.

     'original_filename' => array(
        'type' => 'text',
        'not null' => TRUE,
      ),