Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-28978

PostgreSQL 9 - Errors when populating sample data when scheme minimal is set to false

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
    • Labels:
    • Environment:
      Tomcat 7 + PostgreSQL 9. Portal 6.1.x GIT ID 52a37db4f36c1e018d87cbf2313d33c5c5ef196a.
      Tomcat 7 + PostgreSQL 9. Portal 6.2.x GIT ID: f701cbcca68a6b144964128899927ed2ed8a6075.

      Description

      When you start up Liferay (set schema.run.minimal=false in the portal-ext.properties) using PostgreSQL 9, you get type cast errors in the console.

      18:07:49,378 INFO  [pool-2-thread-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
      18:07:51,684 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
        Hint: You will need to rewrite or cast the expression.
        Position: 381: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (93, 88, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 2, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Joe Bloggs', '', '', '', 0, 0, 0, 0, 0);
      
      18:07:51,706 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
        Hint: You will need to rewrite or cast the expression.
        Position: 382: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (99, 96, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 94, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Test LAX 1', '', '', '', 0, 0, 0, 0, 0);
      
      18:07:51,727 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
        Hint: You will need to rewrite or cast the expression.
        Position: 385: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (105, 102, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 100, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Test LAX 2', '', '', '', 0, 0, 0, 0, 0);
      
      18:07:51,747 WARN  [pool-2-thread-1][BaseDB:428] ERROR: column "visible" is of type boolean but expression is of type integer
        Hint: You will need to rewrite or cast the expression.
        Position: 385: insert into AssetEntry (entryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, classUuid, classTypeId, visible, startDate, endDate, publishDate, expirationDate, mimeType, title, description, summary, url, layoutUuid, height, width, priority, viewCount) VALUES (111, 108, 1, 2, 'Joe Blogs', current_timestamp, current_timestamp, 13, 106, '', 0, 0, NULL, NULL, NULL, NULL, '', 'Test LAX 3', '', '', '', 0, 0, 0, 0, 0);

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years, 2 weeks, 4 days ago

                  Packages

                  Version Package
                  6.1.30 EE GA3
                  --Sprint 11/12
                  6.2.0 CE M2