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
[email protected]
http://lists.ovirt.org/mailman/listinfo/users


_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users

Reply via email to