Site member is unable to move the document in document and Media portlet

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE
• Fix Version/s: 6.2.X EE, 7.0.0 DXP FP11, 7.0.0 DXP SP2, 7.0.3 CE GA4, Master
• Component/s: Documents & Media, Documents & Media > Administration
• Labels:
  • 62-ee-sp19
  • QA-F
  • liferay-digital-enterprise-70-sp2
  • liferay-fixpack-de-11-7010
  • liferay-fixpack-portal-143-6210
• Branch Version/s:
  7.0.x, 6.2.x
• Backported to Branch:
  Committed
• Story Points: 1
• Git Pull Request: https://github.com/sergiogonzalez/liferay-portal/pull/3675
• Bug Type: Regression Bug

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)