Actions
bug #9634
closedUpdate AgentBase and DescriptiveDataSet titleCache length where needed
Start date:
Due date:
% Done:
100%
Estimated time:
Severity:
normal
Found in Version:
Description
In some databases the AgentBase titleCache has only length 255, not 800. Also the DescriptiveDataSet titleCache has usually only 255, not 800. This needs to be updated. On production AgentBase and DescriptiveDataSet and both it's AUD tables have already been fixed.
ALTER TABLE `AgentBase` CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedtitlecache`; ALTER TABLE `AgentBase_AUD` CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedtitlecache`;
ALTER TABLE `DescriptiveDataSet` CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedTitleCache`; ALTER TABLE `DescriptiveDataSet_AUD` CHANGE COLUMN `titleCache` `titleCache` VARCHAR(800) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER `protectedTitleCache`;
The above is only for MySQL. Maybe it is enough to udpate MySQL.
Statement to find open issues on MySQL:
SELECT * FROM COLUMNS c WHERE c.COLUMN_NAME = 'titleCache' AND c.CHARACTER_MAXIMUM_LENGTH <> 800 ORDER BY c.TABLE_SCHEMA, c.TABLE_NAME
Actions