Blogs portlet blank after publishing a draft blog

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP SP1
• Fix Version/s: 7.0.0 DXP FP8, 7.0.0 DXP SP2, 7.0.3 CE GA4, Master
• Component/s: Blogs, Environments > Databases, ~ [Archived] Collaboration
• Labels:
  • QA-AUTOMATION
  • liferay-digital-enterprise-70-sp2
  • liferay-fixpack-de-8-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 5
• Databases:
  SQL Server 2008, SQL Server 2008 R2, SQL Server 2012
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/42722

This bug is not specific to SQL Server and it can be reproduced with any database.

This was reproduced on SQL Server 2012, SQL Server 2008, and SQL Server 2008 R2

Steps:

1. Setup Liferay 7.0.x EE + SQL Server 2012
2. Add a Blogs entry
3. Add another Blogs entry as a Draft
4. Add the Blogs portlet
5. Go to the Not Published tab, edit the Draft Blog Entry and publish it
6. Assert the portlet is now blank and the user can't see any of the content (see gif)