Re: Oracle Problem Reports
I have got a serious problem now.
After activate the search module in the menu, I tried to
search the forum messages. Somewhere in the code, the tiki
issues the following query to the database (the query as reformatted):
SELECT c."title" AS name, SUBSTR(c."data", 1, 240) AS data, c."hits" AS hits, c."commentDate" AS lastModif, f."name"||': '||"title" AS pageName, f."forumId" AS id1, c."threadId" AS id2 MATCH(c."title",c."data") AGAINST ('Espanha') AS relevance FROM "tiki_comments" c, "tiki_forums" f WHERE c."objectType" = 'forum' AND f."forumId" = c."object" AND MATCH(c."title",c."data") AGAINST ('Espanha') ORDER BY relevance desc, c."hits"
Unfortunatly, this query does not work into Oracle because of MATCH..AGAINST operator.
There are alternatives using Oracle Text to replicate the funcion, but probably the
feature will have to be rewrite.
I am wondering the easyest way to rewrite the stuff using Oracle Text.