Update failed: opigno_scorm_update_8003

cuman
Forums
Hello I have such error: Module Update ID Type Description opigno_scorm 8003 hook_update_n Update required activities field. Set default value to NULL. Do you wish to run the specified pending updates? (yes/no) [yes]: > y > [notice] Update started: opigno_scorm_update_8003 > [error] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.: ALTER TABLE {opigno_scorm_user_answer_results} CHANGE interaction_id interaction_id VARCHAR(255) DEFAULT NULL; Array > ( > ) > > [error] Update failed: opigno_scorm_update_8003 [error] Update aborted by: opigno_scorm_update_8003 [error] Finished performing updates. Can you please help? Thank you!
axel

Hi

Hi

What version of MySQL are you using ?

cuman

Hi MySQL 5.5.57-38.9

Hi MySQL 5.5.57-38.9
axel

Hi,

Hi,

MySQL 5.7.7 or above is required.

We advise to upgrade your MySQL to this version, this will fix the issue.

 

cuman

Thank you!

Thank you!