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

Hervé Leclerc herve.leclerc at alterway.fr
Fri Sep 13 11:23:41 UTC 2013


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    where  (  storage pool with
storage 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</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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130913/7142a3f8/attachment-0001.html>


More information about the Users mailing list