User Can't add blog despite having add blog entry permission

• Type: Regression Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: 7.1.X, Master
• Fix Version/s: 7.1.X, Master
• Component/s: Application Security > Permissions
• Labels:
  • 7.1-blocker
  • QA-AUTOMATION
  • QA-FP
• Fix Priority: 4
• Last Working Version:
  7.1.10 DXP FP3
• QA Test Name:
  • LocalFile.WorkflowMyWorkflowTasks#ReviewerApproveResubmitTaskByActionsUser
  • LocalFile.WorkflowUsecase#ViewWorkflowSubmissionsFromDifferentUsers
• QA Test Score: 8

Steps to reproduce:

1. Add a regular role and have following permission
   1. Blogs: Access in Site Administration
   2. Blogs > Blog Entries: Add Entry
   3. Site Settings > Site: View Site Administration Menu
2. Add a user called test1
3. Assgin the role to test1
4. Sign in test1
5. Go to blog content

Actual Result:
The add blog button doesn't display despite the test1 user has the permission.And following error throws.

2018-11-07 02:42:25.103 ERROR [http-nio-8080-exec-2][IncludeTag:128] Current URL /group/guest/~/control_panel/manage?p_p_id=com_liferay_blogs_web_portlet_BlogsAdminPortlet&p_p_lifecycle=0&p_p_state=maximized&p_v_l_s_g_id=20126 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY  ORDER BY limit 20' at line 1
        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.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
        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)

Expect Result:
The add blog button displays.