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)

    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
      

        Issue Links

          Activity

          Hide
          Yannick Roger (Inactive) added a comment -

          .

          Show
          Yannick Roger (Inactive) added a comment - .
          Hide
          Joao Pingo (Inactive) added a comment -

          All Test's Passed
          QA Approved

          Show
          Joao Pingo (Inactive) added a comment - All Test's Passed QA Approved
          Hide
          Pedro Resende (Inactive) added a comment -

          Tested and approved by Q.A.

          Show
          Pedro Resende (Inactive) added a comment - Tested and approved by Q.A.

            People

            • Assignee:
              Unassigned
              Reporter:
              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