Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Incorrect column reference messageFlag.messageId

Description

In file http://svn.liferay.com/browse/~br=trunk/portal/trunk/portal-impl/src/com/liferay/portal/upgrade/v6_1_0/UpgradeMessageBoards.java?r=87507 line 114 there is column name with table name prefix :
long messageId = rs.getLong("messageFlag.messageId");
the same on line 223:
long threadId = rs.getLong("messageFlag.threadId");

it throws exception org.postgresql.util.PSQLException: The column name messageFlag.threadId was not found in this ResultSet.

Solution : remove "messageFlag." from column name.

Environment

PostgreSQL

Activity

Show:

Michael Saechang March 22, 2012 at 2:16 PM

Closing as per Brian's comment.

Brian Chan March 22, 2012 at 8:15 AM

Not recommitting another fix to this ticket since it was already closed. See https://liferay.atlassian.net/browse/LPS-26229#icft=LPS-26229.

Michael Saechang February 13, 2012 at 12:29 PM

Committed on:
6.1.x GIT ID: 0a0c6653cc9a3c11de49dfd4f83ef2c1d9d3b5ac.
6.2.x GIT ID: b5a9cb0b63659db4b9131e6b0c73c7b76c190c8e.

Igor Beslic February 9, 2012 at 12:19 PM

Reopening - messageflag.threadid
aused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name messageFlag.threadId was not found in this ResultSet.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: The column name messageFlag.threadId was not found in this ResultSet.
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:225)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:71)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
... 27 more
Caused by: org.postgresql.util.PSQLException: The column name messageFlag.threadId was not found in this ResultSet.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2411)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getLong(NewProxyResultSet.java:2625)
at com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards.updateThread(UpgradeMessageBoards.java:223)
at com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards.doUpgrade(UpgradeMessageBoards.java:63)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
... 30 more

Igor Beslic February 9, 2012 at 10:43 AM
Edited

Tested at current git repo https://github.com/liferay/liferay-portal

Postgre 8 at windows XP - can't reproduce
MySql5 at Windows 7 - can't reproduce

postgre 8 - Test was performed by runing 6.1.0 CE GA1 against 6.0.6 database

mysql 5 - Test was perform via JUnit test

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Labels

Branch Version/s

6.1.x

Backported to Branch

Committed

Epic/Theme

Fix Priority

5

Git Pull Request

Fix versions

Affects versions

Priority

Zendesk Support

Created October 18, 2011 at 11:04 AM
Updated June 24, 2023 at 3:45 PM
Resolved March 22, 2012 at 8:12 AM