Moodle

1071: Specified key was too long; max key length is 767 bytes

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.9.1
  • Fix Version/s: None
  • Component/s: Installation
  • Labels:
    None
  • Environment:
    Windows Server Standard 2008 Version 6.0 Build 6001, service Pack 1 64 bit
    IIS 7.0.6000.16386
    MySQL ver 8.42 Distrib 6.0.4 alpha windows 64
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_19_STABLE

Description

Getting error 1071: Specified key was too long; max key length is 767 bytes for the following tables:
mdl_conf_nam_uix on mdl_config (name)
mdl_capa_nam_uix on mdl_capabilities(name)
mdl_rolecapa_rolconcam_uix on mdl_role_capabilities (roleid, contextid, capability)
mdl_gradoutc_cousho_uix on mdl_grade_outcomes (courseid, shortname)
mdl_tag_nam_uix on mdl_tag
mdl_taginst_iteitetab_uix on mdl_tag_instance (itemtype, itemid, tagid)
mdl_gradsett_counam_uix on mdl_grade_settings (courseid, name)
mdl_webdlock_dok_uix on mdl_webdav_locks (token)
Main databases not set up successfully

mdl_scorscoetrac_usescosco_uix on mdl_scorm_scoes_track (userid, scormid, scoid, attempt, element)
scorm tables could not be set up successfully

Will not let me continue. Have tried changing the mysql default to utf8 still same error. Tried changing default as well as moodle database to latin1 still same error. Did clean installs with each change. Cannot move forward from here. Have attached create unique index errors.

Activity

Hide
Regina Cain added a comment -

I went in and changed the field lengths to 85 for the varchar fields that correspond with the error in the xml files that create those tables, and the install went smoothly after that. Is there any reason that they need to be 255 char long and utf8? Will this cause me problems later on?

Show
Regina Cain added a comment - I went in and changed the field lengths to 85 for the varchar fields that correspond with the error in the xml files that create those tables, and the install went smoothly after that. Is there any reason that they need to be 255 char long and utf8? Will this cause me problems later on?
Hide
Petr Škoda (skodak) added a comment -

Eloy, did you succeeded in reproducing this problem? I was not able to...

Show
Petr Škoda (skodak) added a comment - Eloy, did you succeeded in reproducing this problem? I was not able to...
Hide
Petr Škoda (skodak) added a comment -

lowering priority, I did not see any similar reports here, looks like a server specific problem, sorry

Show
Petr Škoda (skodak) added a comment - lowering priority, I did not see any similar reports here, looks like a server specific problem, sorry
Hide
Michael de Raadt added a comment -

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

Show
Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6
Hide
Michael de Raadt added a comment -

I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Show
Michael de Raadt added a comment - I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Dates

  • Created:
    Updated:
    Resolved: