[zanata-bugs] [Bug 970855] New: Source and Target search and Project-wide search&replace do not work at all
bugzilla at redhat.com
bugzilla at redhat.com
Wed Jun 5 06:10:17 UTC 2013
https://bugzilla.redhat.com/show_bug.cgi?id=970855
Bug ID: 970855
Summary: Source and Target search and Project-wide
search&replace do not work at all
Product: Zanata
Version: 2.2
Component: Component-UI, Usability, WebSite
Severity: unspecified
Priority: unspecified
Assignee: irooskov at redhat.com
Reporter: petr.vlcek at gmail.com
QA Contact: dchen at redhat.com
CC: zanata-bugs at redhat.com
Description of problem:
I receive only error message when trying to do any search with Source and
target search or Project wide search and replace.
Version-Release number of selected component (if applicable):
Installed from the bundle Zanata 2.2.2 Server (on JBoss AS 5.1.0) with MySQL
Community Server database, 5.5.30.
How reproducible:
Install the bundle on given database and try to search anything.
Steps to Reproduce:
1.
2.
3.
Actual results: Error message - Failed to load data from the server.
Error message logged in browser JS console:
Source and Target search:
(-:-) 2013-06-05 08:01:57,025 [ERROR] GetTransUnits failure
net.customware.gwt.dispatch.shared.ActionException: with-clause expressions did
not reference from-clause element to which the with-clause was associated
[SELECT distinct tf FROM org.zanata.model.HTextFlow tf LEFT JOIN tf.targets
tfts WITH index(tfts)=:locale WHERE (tf.obsolete=0 AND tf.document.id=:docId
AND ((lower(tf.content0) like :searchString or lower(tf.content1) like
:searchString or lower(tf.content2) like :searchString or lower(tf.content3)
like :searchString or lower(tf.content4) like :searchString or
lower(tf.content5) like :searchString) OR EXISTS ( FROM
org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale and
(lower(content0) like :searchString or lower(content1) like :searchString or
lower(content2) like :searchString or lower(content3) like :searchString or
lower(content4) like :searchString or lower(content5) like :searchString)))))
ORDER BY tf.pos]
net.customware.gwt.dispatch.shared.ActionException: with-clause expressions did
not reference from-clause element to which the with-clause was associated
[SELECT distinct tf FROM org.zanata.model.HTextFlow tf LEFT JOIN tf.targets
tfts WITH index(tfts)=:locale WHERE (tf.obsolete=0 AND tf.document.id=:docId
AND ((lower(tf.content0) like :searchString or lower(tf.content1) like
:searchString or lower(tf.content2) like :searchString or lower(tf.content3)
like :searchString or lower(tf.content4) like :searchString or
lower(tf.content5) like :searchString) OR EXISTS ( FROM
org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale and
(lower(content0) like :searchString or lower(content1) like :searchString or
lower(content2) like :searchString or lower(content3) like :searchString or
lower(content4) like :searchString or lower(content5) like :searchString)))))
ORDER BY tf.pos]
Project-wide search&replace:
2013-06-05 08:08:37,125 [ERROR] [SearchResultsPresenter] failed project-wide
search request: with-clause expressions did not reference from-clause element
to which the with-clause was associated [SELECT distinct tf FROM
org.zanata.model.HTextFlow tf LEFT JOIN tf.targets tfts WITH
index(tfts)=:locale WHERE (tf.obsolete=0 AND tf.document.id in (:documentIds)
AND ((lower(tf.content0) like :searchString or lower(tf.content1) like
:searchString or lower(tf.content2) like :searchString or lower(tf.content3)
like :searchString or lower(tf.content4) like :searchString or
lower(tf.content5) like :searchString) OR EXISTS ( FROM
org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale and
(lower(content0) like :searchString or lower(content1) like :searchString or
lower(content2) like :searchString or lower(content3) like :searchString or
lower(content4) like :searchString or lower(content5) like :searchString)))))
ORDER BY tf.pos]
Expected results: Any search results
--
You are receiving this mail because:
You are on the CC list for the bug.
Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=pYTGhz6MNL&a=cc_unsubscribe
More information about the zanata-bugs
mailing list