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

Hello, I have this SQL error when i try to use the engine API qith this query https://myovirt/api/clusters?search=datacenter%3Dh2o

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(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users