Details

      Description

      1. install liferay 6.2 version
      2. log in as admin
      3. create a structure in web content management with a date
      4. In a page, add the Asset publisher portlet
      5. Click on Configuration link of the Asset publisher portlet
      6. In asset type, select "Web Content Article"
      7. Web Content Article Subtype, select the structure created earlier at step 3
      8. In ordering and grouping, select the date of the structure for the Order by
      9. Go to Subscriptions tab
      10. Check Enable RSS Subscription
      11. Choose "RSS 2.0" for the Format and let the default values for the other parameters
      12. Click on Save
      13. In the Asset publisher portlet, click on the RSS link

      expected result: RSS XML is correctly generated

      actual result: the generated RSS XML is empty, also there is an error message in the log:

      14:35:42,323 ERROR [http-bio-8080-exec-8][JDBCExceptionReporter:82] user lacks privilege or object not found: ASSETENTRY.DDM
      

      on master the error message is this:

      09:52:41,642 ERROR [http-bio-8080-exec-2][JDBCExceptionReporter:234] user lacks privilege or object not found: ASSETENTRY.DDM__20570__DATE
      

      Branch:
      Reproduced on 6.2.x @ 6465ef0f0882cbff4c1ec5a91aa5111e7d609124

      Master
      On master this issue has been fixed by LPS-54528, which depends on LPS-56711, and on LPS-60132. In BPR-2075 it was decided to not backport previous API changes which are also in use for the solution at master.

      If you change the Order by a general field like Publish Date, the RSS XML is correctly generated:

      <rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
      <channel>
      <title>Asset Publisher</title>
      <link>
      http://localhost:8080/web/guest/home/-/asset_publisher/DbO0Rt5nsK4y/rss
      </link>
      <description>Asset Publisher</description>
      <pubDate>Wed, 18 Mar 2015 09:53:30 GMT</pubDate>
      <dc:date>2015-03-18T09:53:30Z</dc:date>
      </channel>
      </rss>
      

      Details:
      RssAction:

      String rss = exportToRSS(
      	portletRequest, portletResponse, rssName, null, format, version,
      	rssDisplayStyle, assetLinkBehavior,
      	getAssetEntries(portletRequest, portletPreferences));

      The getAssetEntries call tries to query the asset entries ordering by the field coming from the structure

      SQLQueryImpl(SELECT {AssetEntry.*} FROM (SELECT DISTINCT AssetEntry.entryId FROM AssetEntry WHERE  (visible = ?) AND ( AssetEntry.classTypeId = 20455) 
      AND (AssetEntry.publishDate IS NULL OR AssetEntry.publishDate < ?) AND (AssetEntry.expirationDate IS NULL OR AssetEntry.expirationDate > ?) AND (AssetEntry.groupId = ?) 
      AND (AssetEntry.classNameId = ?)) TEMP_TABLE INNER JOIN AssetEntry AssetEntry ON TEMP_TABLE.entryId = AssetEntry.entryId ORDER BY AssetEntry.ddm/20455/Radio2727 ASC, 
      AssetEntry.title ASC)

        Attachments

        1. Fixed.PNG
          Fixed.PNG
          152 kB
        2. Reproduced.PNG
          Reproduced.PNG
          118 kB

          Issue Links

            Activity

              People

              Assignee:
              harry.chai Harry Chai
              Reporter:
              zsolt.olah Zsolt Oláh (Inactive)
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 11 weeks, 1 day ago

                  Packages

                  Version Package
                  6.2.X EE