Issue Details (XML | Word | Printable)

Key: MDL-15272
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Eloy Lafuente (stronk7)
Reporter: Regina Cain
Votes: 0
Watchers: 2
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

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

Created: 17/Jun/08 04:02 AM   Updated: 16/Jan/09 05:35 AM
Return to search
Component/s: Installation
Affects Version/s: 1.9.1
Fix Version/s: 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
Participants: Eloy Lafuente (stronk7), Petr Skoda and Regina Cain
Security Level: None
Affected Branches: MOODLE_19_STABLE


 Description  « Hide
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.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Regina Cain added a comment - 17/Jun/08 06:12 AM
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?

Petr Skoda added a comment - 16/Jan/09 05:34 AM
Eloy, did you succeeded in reproducing this problem? I was not able to...

Petr Skoda added a comment - 16/Jan/09 05:35 AM
lowering priority, I did not see any similar reports here, looks like a server specific problem, sorry