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: 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
Thanks for reporting this issue.
We will have a look and keep you updated.
In reply to Hi Olivier, by nikolay