Error saving opigno_scorm_user_answer_results

Olivier R.
Forums
Hi, We have errors during insert into "opigno_scorm_user_answer_results" table. The interaction_id field is a varchar(32). In the scorm specification the cmi.interactions.n.id is a long_identifier_type (SPM: 4000) as a unique label for the interaction (https://scorm.com/scorm-explained/technical-scorm/run-time/run-time-ref…) SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'interaction_id' at row 1: INSERT INTO @opigno_scorm_user_answer_results (interaction_id, question_id, question_vid, answer_id, answer_vid, interaction_type, description, correct_responses_pattern, response, result, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10); Array ( [:db_insert_placeholder_0] => Scene3_Slide17_FreeFormPickOne_0_0 [:db_insert_placeholder_1] => 361 [:db_insert_placeholder_2] => 377 [:db_insert_placeholder_3] => 42636 [:db_insert_placeholder_4] => 42636 [:db_insert_placeholder_5] => choice [:db_insert_placeholder_6] => QUE PROPOSEZ-VOUS ? [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => R5_1 [:db_insert_placeholder_9] => incorrect [:db_insert_placeholder_10] => 0 ) Opigno 2.6 Olivier
axel

Hi Olivier,

Hi Olivier,

Thanks for reporting this issue.

We will have a look and keep you updated.

nikolay

Hi Olivier,

To fix this issue you need to apply this patch in the module "Opigno Scorm" (probably it should be *profiles/modules/opigno/opigno_scorm* (if you installed Opigno from archive) or *modules/contrib/opigno_scorm* (if you installed Opigno with Composer)) and then run updates for the database: https://drive.google.com/open?id=1F0i6uzyBEdERO1kcI6qq1sIK1ZaSyliC
Olivier R.

Hi Nikolay

Thks for this patch