Bug 953195

Description of problem:
I have installed Zanata Server 2.2.2 on an Ubuntu 12.04.2 LTS and am trying to test it. I have uploaded some sample pot file to test the online translation interface. But as I click on one of the 3 possible state of a string, I receive an error notification and can't perform the filtering operation.

Version-Release number of selected component (if applicable):
Zanata Server 2.2.2

java version "1.6.0_27"
OpenJDK Runtime Environment (IcedTea6 1.12.3) (6b27-1.12.3-0ubuntu1~12.04.1)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)


How reproducible:
I have tried it on Windows 7 and the problem is reproducible.


Steps to Reproduce:
1. Create a project, upload sample pot file as a source document.
2. Enter the translation interface
3. Click on "Translated", "Need Review" or "Untranslated"
  
Actual results:
"Failed to load data from server" notification on the right sidebar.

Expected results:
The strings should be correctly filtered according to the filter option.

Additional info:
14:51:59,144 ERROR [SeamDispatch] Error dispatching action: org.hibernate.hql.ast.InvalidWithClauseException: with-clause expressions did not reference from-clause element to wh
ich 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  EXISTS ( FROM org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale AND state in (:contentStateList)))) ORDER BY tf.pos]

I've also noticed that once this exception is raised, I can't use other functionalities such as the arrows at the bottom to change pages (which then provoke the same notification error). Have I not tried to filter the strings, the arrows would have worked just fine.