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