Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.3
    • Fix Version/s: 2.5
    • Component/s: DQL
    • Security Level: All
    • Labels:

      Description

      Hi.
      First sorry for my bad english.
      In
      SELECT u.id FROM CmsUser u WHERE :groupId MEMBER OF u.groups
      DQL we can't use Array of groupId like

        Issue Links

          Activity

          Hide
          Daniel Sippel added a comment - - edited

          +1

          Simple solution could be this: use SQL IN(value) always instead of the equality sign..

          Current situation:
          500 Internal Server Error - DBALException
          1 linked Exception: PDOException »

          An exception occurred while executing 'SELECT w0_.id AS id0, w0_.userId AS userId1, w0_.profileName AS profileName2, w0_.url AS url3, w0_.companyName AS companyName4, w0_.firstName AS firstName5, w0_.lastName AS lastName6, w0_.street AS street7, w0_.houseNo AS houseNo8, w0_.postcode AS postcode9, w0_.city AS city10, w0_.phoneNo AS phoneNo11, w0_.faxNo AS faxNo12, w0_.email AS email13, w0_.websiteUrl AS websiteUrl14, w0_.description AS description15, w0_.created AS created16, w0_.updated AS updated17, w0_.offersFurther AS offersFurther18, w0_.companyLogoImageFileExtension AS companyLogoImageFileExtension19, w0_.location AS location20 FROM profile w0_ WHERE 1 = 1 AND (GLength(LineString(w0_.location, GeomFromText(?)))*100 < 30) AND EXISTS (SELECT 1 FROM profile_attribute_mapping p1_ INNER JOIN profile_attribute w2_ ON p1_.profileattribute_id = w2_.id WHERE p1_.profile_id = w0_.id AND w2_.id = ?, ?)' with params [{}, 1, 2]:
          
          SQLSTATE[42000]: Syntax error or access violation: 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 ' 2)' at line 1
          
          Show
          Daniel Sippel added a comment - - edited +1 Simple solution could be this: use SQL IN(value) always instead of the equality sign.. Current situation: 500 Internal Server Error - DBALException 1 linked Exception: PDOException » An exception occurred while executing 'SELECT w0_.id AS id0, w0_.userId AS userId1, w0_.profileName AS profileName2, w0_.url AS url3, w0_.companyName AS companyName4, w0_.firstName AS firstName5, w0_.lastName AS lastName6, w0_.street AS street7, w0_.houseNo AS houseNo8, w0_.postcode AS postcode9, w0_.city AS city10, w0_.phoneNo AS phoneNo11, w0_.faxNo AS faxNo12, w0_.email AS email13, w0_.websiteUrl AS websiteUrl14, w0_.description AS description15, w0_.created AS created16, w0_.updated AS updated17, w0_.offersFurther AS offersFurther18, w0_.companyLogoImageFileExtension AS companyLogoImageFileExtension19, w0_.location AS location20 FROM profile w0_ WHERE 1 = 1 AND (GLength(LineString(w0_.location, GeomFromText(?)))*100 < 30) AND EXISTS (SELECT 1 FROM profile_attribute_mapping p1_ INNER JOIN profile_attribute w2_ ON p1_.profileattribute_id = w2_.id WHERE p1_.profile_id = w0_.id AND w2_.id = ?, ?)' with params [{}, 1, 2]: SQLSTATE[42000]: Syntax error or access violation: 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 ' 2)' at line 1
          Hide
          Daniel Sippel added a comment -

          pull request https://github.com/doctrine/doctrine2/pull/1080

          Solution: use SQL IN(value) always instead of the equality sign

          Show
          Daniel Sippel added a comment - pull request https://github.com/doctrine/doctrine2/pull/1080 Solution: use SQL IN(value) always instead of the equality sign
          Hide
          Doctrine Bot added a comment -

          A related Github Pull-Request [GH-1080] was closed:
          https://github.com/doctrine/doctrine2/pull/1080

          Show
          Doctrine Bot added a comment - A related Github Pull-Request [GH-1080] was closed: https://github.com/doctrine/doctrine2/pull/1080
          Show
          Marco Pivetta added a comment - Handled in DDC-3210 , see https://github.com/doctrine/doctrine2/commit/ae0ee724252b8aaf41be9b397d3db3375767095d

            People

            • Assignee:
              Marco Pivetta
              Reporter:
              vahid sohrabloo
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: