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

db cluster gateways: error storing image files when path contains apostrophe (urlalias_iri)

    XMLWordPrintable

Details

    Description

      When using URL transformation group urlalias_iri (site.ini, [URLTranslator]),
      and a content folder created with an apostrophe, cluster operations on files beneath that node fail with an SQL error.

      Steps to reproduce
      • Set TransformationGroup=urlalias_iri (and clear .ini caches).
      • Create a folder object: speakers'
      • inside this folder, create an image object, and publish.

      Result:
      SQL errors will be produced, such as:

      [ Sep 19 2012 20:02:09 ] [192.168.56.1] _endCacheGeneration( var/ezflow_site/storage/images/tests/speakers'/image/9741-1-ger-DE/image.png ):
      Failed to execute SQL for function:
      1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            joao.inacio-obsolete@ez.no Joao Inacio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 7 hours, 40 minutes
                1d 7h 40m