Web content search using keywords not working

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 6.0.6 GA, 6.1.0 CE RC1
• Fix Version/s: --Sprint 12/11, 6.1.0 CE RC1
• Component/s: WCM > Web Content Administration
• Labels: None
• Environment: Windows Xp Sp3, 2 GB DDR3 RAM, MySql 5.0
• Branch Version/s:
  6.0.x
• Backported to Branch:
  Committed
• Similar Issues: Show 4 results ; ;

  LPS-33822	Web Content - Fields that are Indexable by Keywords or Text are not searchable in the Search Portlet
  LPS-26510	Web Content Display and Web Content Search portlet search is not working
  LPS-1954	Web Content Search does not work properly
  LPS-7826	Add search by keyword - look-ahead typing - on core portlets like Search and Web Content Search

when we try to use com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.search() in web content templates(using velocity) or in plugin portlet. It gives error in console:

ERROR [JDBCExceptionReporter:234] Unknown column 'id' in 'order clause'

[nasir hussain]

The problem is in custom sql i.e journal.xml

com.liferay.portlet.journal.service.persistence.JournalArticleFinder.findByC_G_A_V_T_D_C_T_S_T_D_S_R

in this, you will find "ORDER BY id ASC" but in place of "id" there should be "id_" as in JournalArticle table "id" field doesn't exist.

[Corne]

This issue is a backlog candidate for the 100 PaperCuts program. Please consider participating! See http://liferay.com/community/100-papercuts

[Corne]

This issue is currently being addressed in Sprint 4 of the 100 PaperCuts program. Please see http://liferay.com/community/100-papercuts

[Corne]

changed the SQL Order

[Igor Spasic]

Thank you! Fixed in 6.x and 6.0.x.

[Paul Piao]

This issue has been resolved

I can not reproduce on Trunk Revision:79750.

If you are still experiencing an issue, please open another ticket or please visit our Community Message Boards.

Thanks.