Uploaded image for project: 'ZZZ: PUBLIC - Old Liferay Portal (Use Liferay Portal Standard Edition)'
  1. ZZZ: PUBLIC - Old Liferay Portal (Use Liferay Portal Standard Edition)
  2. LEP-1803

(Postgres) SQL Error: "operator does not exist: character varying = boolean" on logon attempt

Details

    • Bug
    • Status: In Review
    • Critical
    • Resolution: Unresolved
    • 4.2.0
    • 4.3.5, 5.1.0
    • None
    • None
    • Tomcat 5.5, Postgresql 8.2, jdbc4 drivers (for 8.2)

    Description

      i just finished my first installation, but a strange error is happens, if i try to login in the base sample application shipped with the download:

      ERROR: operator does not exist: character varying = boolean at character 188
      HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
      STATEMENT: ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN LayoutSet ON (LayoutSet.groupId = Group_.groupId) INNER JOIN Users_Groups ON (Users_Groups.userId = $1) WHERE (LayoutSet.privateLayout = $2) AND (LayoutSet.pageCount != 0) AND (Users_Groups.groupId = Group_.groupId) AND (Group_.companyId = $3) AND (Group_.className IS NULL OR Group_.className = '') AND (Group_.classPK IS NULL OR Group_.classPK = '') AND (lower(Group_.name) LIKE $4 OR $5 IS NULL) AND (lower(Group_.description) LIKE $6 OR $7 IS NULL) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_Orgs ON (Groups_Orgs.groupId = Group_.groupId) INNER JOIN Users_Orgs ON (Users_Orgs.organizationId = Groups_Orgs.organizationId) INNER JOIN LayoutSet ON (LayoutSet.groupId = Group_.groupId) WHERE (Users_Orgs.userId = $8) AND (LayoutSet.privateLayout = $9) AND (LayoutSet.pageCount != 0) AND (Group_.companyId = $10) AND (Group_.className IS NULL OR Group_.className = '') AND (Group_.classPK IS NULL OR Group_.classPK = '') AND (lower(Group_.name) LIKE $11 OR $12 IS NULL) AND (lower(Group_.description) LIKE $13 OR $14 IS NULL) ) UNION ( SELECT Group_.groupId AS groupId, Group_.name AS groupName FROM Group_ INNER JOIN Groups_UserGroups ON (Groups_UserGroups.groupId = Group_.groupId) INNER JOIN Users_UserGroups ON (Users_UserGroups.userGroupId = Groups_UserGroups.userGroupId) INNER JOIN LayoutSet ON (LayoutSet.groupId = Group_.groupId) WHERE (Users_UserGroups.userId = $15) AND (LayoutSet.privateLayout = $16) AND (LayoutSet.pageCount != 0) AND (Group_.companyId = $17) AND (Group_.className IS NULL OR Group_.className = '') AND (Group_.classPK IS NULL OR Group_.classPK = '') AND (lower(Group_.name) LIKE $18 OR $19 IS NULL) AND (lower(Group_.description) LIKE $20 OR $21 IS NULL) ) ORDER BY groupName ASC

      Attachments

        Activity

          People

            support-lep@liferay.com SE Support
            vsx@gmx.net Moritz Kunze (Inactive)
            Votes:
            5 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Packages

                Version Package
                4.3.5
                5.1.0