PUBLIC - Liferay Portal Community Edition

Incorrect column reference messageFlag.messageId

Details

  • Branch Version/s:
    6.1.x
  • Backported to Branch:
    Committed
  • Similar Issues:
    Show 5 results 
  • Epic/Theme:
  • Business Value:
    5

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.

Issue Links

This issue relates:
LPS-25971 Upgrade to 6.1 throws SQLException: Invalid column name in v6_0_12_to_6_1_0.UpgradeMessageBoards (Oracle from 6.0.12 to 6.1.10) Major Closed
This issue is related to:
LPS-26229 Proper fix for incorrect column reference messageFlag.messageId Minor Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Drew Blessing added a comment -

Rasto,

Thank you for your report.

I can confirm that the strings you mention are still present in Liferay 6.1 GA1.

Show
Drew Blessing added a comment - Rasto, Thank you for your report. I can confirm that the strings you mention are still present in Liferay 6.1 GA1.
Hide
Permalink
Michael Saechang added a comment -

Updated ticket as per Drew's comment. Thank you for verifying.

Show
Michael Saechang added a comment - Updated ticket as per Drew's comment. Thank you for verifying.
Hide
Permalink
Igor Beslic added a comment - - 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

Show
Igor Beslic added a comment - - 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
Hide
Permalink
Igor Beslic added a comment -

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

Show
Igor Beslic added a comment - 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
Hide
Permalink
Michael Saechang added a comment -

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

Show
Michael Saechang added a comment - Committed on: 6.1.x GIT ID: 0a0c6653cc9a3c11de49dfd4f83ef2c1d9d3b5ac. 6.2.x GIT ID: b5a9cb0b63659db4b9131e6b0c73c7b76c190c8e.
Hide
Permalink
Brian Chan added a comment -

Not recommitting another fix to this ticket since it was already closed. See LPS-26229.

Show
Brian Chan added a comment - Not recommitting another fix to this ticket since it was already closed. See LPS-26229.
Hide
Permalink
Michael Saechang added a comment -

Closing as per Brian's comment.

Show
Michael Saechang added a comment - Closing as per Brian's comment.

People

Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.4#664-r167664) | Report a problem
Powered by a free Atlassian JIRA open source license for Liferay. Try JIRA - bug tracking software for your team.