[Users] API bad SQL Statement (3.3.0-3.el6)

[Itamar Heim]

On 09/13/2013 02:23 PM, Hervé Leclerc wrote:
> Hello,
>
> I have this SQL error when i try to use the engine API qith this query
>
> https://myovirt/api/clusters?search=datacenter%3Dh2o

http://gerrit.ovirt.org/#/c/18061/
was repeorted by a foreman user as well.
ofer - should be in 3.3.0 or 3.3.0-1...

>
>
> Results
> <fault>
> <reason>Operation Failed</reason>
> <detail>statementcallback; bad sql grammar [select * from (select * from
> vds groups view where ( vds group id in (select vds groups storage
> domain.vds group id from  vds groups storage domain   left outer join
> storage pool with storage domain on vds groups storage domain.storage
> pool id=storage pool with storage domain.id <http://domain.id>    where
>   (  storage pool with storage domain.name <http://domain.name> like
> '%h2o%' or  storage pool with storage domain.description like '%h2o%' or
>   storage pool with storage domain.comment like '%h2o%' ) ))  order by
> name asc ) as t1 offset (1 -1) limit 100]; nested exception is
> org.postgresql.util.psqlexception: erreur: la colonne storage pool with
> storage domain.comment n'existe pas
>    position: 411
> </detail>
> </fault>
>
>
>
>
> /api
>
> <product_info><name>oVirt Engine</name><vendor>ovirt.org
> <http://ovirt.org></vendor><version major="3" minor="3" build="0"
> revision="0"/><full_version>3.3.0-3.el6</full_version></product_info><summary>
>
> Hervé Leclerc
> CTO
> Alter Way
> 1, rue royale
> 9 ème étage
> 92210 St Cloud
> +33 1 78152407
> +33 6 83979598
>
> <http://www.alterway.fr/signatures/url/1>
>
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>