Author: jabial

Description:
Patch

I created this report because I can't commit to the svn. I trust one of the developpers to do it after testing, but it works for me.

Problem : When you create the table from scrach, the script contains truncation.

maintenance/tables.sql lines 728-729:

• oi_archive_name truncated to 14 to avoid key length overflow INDEX oi_name_archive_name (oi_name,oi_archive_name(14))

But when you try to upgrade, the script doesn't so it stops, leaving the database in an unusable state.

maintenance/archives/patch-oi_metadata.sql line 11:

ADD INDEX oi_name_archive_name (oi_name,oi_archive_name),

Solution : Replace maintenance/archives/patch-oi_metadata.sql line 11 by:

ADD INDEX oi_name_archive_name (oi_name,oi_archive_name(14)),

Version: 1.11.x
Severity: normal

Attached: