Details
-
Bug
-
Status: Closed
-
Resolution: Fixed
-
6.2.X EE
-
7.0.x, 6.2.x
-
Committed
-
1
-
Regression Bug
Description
Replicate steps:
1) Build a master bundle
2) Started server and logged-in with admin user ([email protected])
3) Created a new user named "abc"
4) Assigned this user to Liferay site
5) Added document and media portlet to a page
6) Added 2 documents and 1 folder in DM portlet
7) Given update permission to site member on a document
8) Logged-in with user "abc"
9) Clicked on "Move" for that document
10) Clicked on select button you will see following error
Listening for transport dt_socket at address: 8000
08:34:29,811 ERROR [http-bio-8080-exec-3][JDBCExceptionReporter:82] Unknown column 'DLFileEntry.fileEntryId' in 'on clause'
08:34:29,814 ERROR [http-bio-8080-exec-3][IncludeTag:129] Current URL /web/guest/home?p_p_id=20&p_p_lifecycle=0&p_p_state=pop_up&p_p_mode=view&p_p_col_id=column-2&p_p_col_pos=1&p_p_col_count=2&_20_struts_action=%2Fdocument_library%2Fselect_folder&_20_folderId=0 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DLFileEntry.fileEntryId' in 'on clause'
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)