Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
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.
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?