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!
Hi
Hi
What version of MySQL are you using ?
In reply to Hi by axel
Hi MySQL 5.5.57-38.9
Hi,
Hi,
MySQL 5.7.7 or above is required.
We advise to upgrade your MySQL to this version, this will fix the issue.
Thank you!