Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-13759

Problem with long image paths in clustered setups

    XMLWordPrintable

Details

    Description

      The ezdbfile schema restricts the length of paths to VARCHAR(255). Increasing this limit to TEXT will allow the images to be shown.

      Instructions to upgrade current installations:

      ALTER TABLE `ezdbfile` DROP INDEX `ezdbfile_name`;
      ALTER TABLE `ezdbfile` DROP INDEX `ezdbfile_expired_name`;
      ALTER TABLE `ezdbfile` CHANGE `name` `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
      ALTER TABLE `ezdbfile` ADD INDEX `ezdbfile_name` ( `name` ( 250 ) );
      ALTER TABLE `ezdbfile` ADD INDEX `ezdbfile_expired_name` ( `expired` , `name` ( 250 ) );
      

      Attachments

        Activity

          People

            oms Ole Marius Smestad
            oms Ole Marius Smestad
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: