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

          Issue Links

            Activity

              People

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