CMS Made Simple Core


[#8208] cms_index_module_templates_by_module_name_template_name too long in utf8

Created By: Not public (Joppybt)
Date Submitted: Fri Aug 03 07:06:16 -0400 2012

Assigned To: Robert Campbell (calguy1000)
Version: 1.11
CMSMS Version: 1.11
Severity: Minor
Resolution: Accepted
State: Open
cms_index_module_templates_by_module_name_template_name too long in utf8
Detailed Description:
I am trying to convert my old database to utf8 but mysql refuses because the
index cms_index_module_templates_by_module_name_template_name becomes more than
1000 bytes.
#1071 - Specified key was too long; max key length is 1000 bytes

The database was originally created with CMSMS 1.4 (or even older, don't
remember). It has over the years always been upgraded step by step to the latest
version 1.11 now.

In version 1.4b1 in the table module_template the fields module_name and
template_name are defined as VARCHAR (200) (see the 1.4b1
In version 1.5b1 the length in schema.php is reduced to C(160) for both fields.
This is probably done because of the index becoming too long in utf8, see also
New databases work fine in utf8.

However: as far as I can tell, there has never been an upgrade step that reduces
the size of the fields. Therefore in my database the fields are still 200
characters causing the index to become too long.

Solution: an upgrade step should reduce the length of the two fields.


Date: 2012-09-07 15:23
Posted By: Tapio Löytty (Stikki)

Can be fixed with new installs, but not with upgrades.


Updated: 2012-09-07 15:23
resolution_id: 5 => 6
assigned_to_id: 100 => 106

Updated: 2012-08-10 09:49
version_id: 29232 => 29719
resolution_id: => 5
cmsms_version_id: 29232 => 29719