-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
-
Fix Version/s: 6.1.30 EE GA3, --Sprint 11/12, 6.2.0 CE M2
-
Component/s: Environments, Environments > Databases
-
Labels:
-
Environment:Tomcat 7 + PostgreSQL 9. Portal 6.1.x GIT ID 52a37db4f36c1e018d87cbf2313d33c5c5ef196a.
Tomcat 7 + PostgreSQL 9. Portal 6.2.x GIT ID: f701cbcca68a6b144964128899927ed2ed8a6075.
-
Branch Version/s:6.1.x
-
Backported to Branch:Committed
-
Databases:PostgreSQL 9.0
-
Git Pull Request:
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);
- relates
-
LPE-7417 Errors when populating sample data when scheme minimal is set to false
-
- Closed
-