4 posts / 0 new
Last post
Olivier R.
Offline
Last seen: 5 days 21 hours ago
Joined: 06/19/2017
Error saving opigno_scorm_user_answer_results

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-refe...)

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
Offline
Last seen: 45 min 1 sec ago
Staff
Joined: 09/25/2013
Hi Olivier,

Hi Olivier,

Thanks for reporting this issue.

We will have a look and keep you updated.

nikolay
Offline
Last seen: 2 days 21 hours ago
Joined: 12/12/2018
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.
Offline
Last seen: 5 days 21 hours ago
Joined: 06/19/2017
Hi Nikolay

Thks for this patch