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

the " caracter with postgresql

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Medium Medium
    • None
    • extension/CJW Newsletter beta
    • None
    • Operating System:ubuntu64 9.10
      PHP Version: (please be specific, like '5.2.9')
      Database and version: postgresql 8.4
      Browser (and version): firefow 3.5.9

    Description

      SELECT c.contentobject_id FROM cjwnl_list c, ezcontentobject e
      WHERE e.id = c.contentobject_id
      AND e.current_version = c.contentobject_attribute_version
      AND ( c.siteaccess_array_string like "%;lyoncapitale_admin;%" )

                        • Erreur **********

      ERREUR: la colonne « %;lyoncapitale_admin;% » n'existe pas
      État SQL :42703
      Caractère : 290

      Steps to reproduce

      when "Send test newsletter"
      extendedattributefilter/cjwnewsletterlistfilter.php
      line 84 : $siteaccessSqlStringArray[] = "c.siteaccess_array_string like \"%;". $db->escapeString( $siteAccessName ) .";%\"";

      Attachments

        Activity

          People

            ls ls
            pdechanoz pdechanoz
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: