[Spacewalk-list] Errata search by CVE fails

[Pierre Casenove]

Hello,
I've done some more research.
The same exception occurs when you want to search errata by issue date
(without putting any keywords in the "Search For" field).
In fact, it fails when, on postgresql, any of the two queries defined in
file errata_handler.xml.
I think that the following part of the query requires an explicit cast:
 ps.id = #sessionId# and

How could I debug this?

Thanks,

Pierre


2013/1/23 Steve Meier <email at steve-meier.de>

> Dear all,
>
> I have just checked this on my local installation (Spacewalk 1.8 /
> Postgres / CentOS 5.9) and
> I get the same error. The CVE is properly assigned to a CESA but Advanced
> Search failes with
>
> Could not execute query 'CVE-2013-1083'.
>
> I hope somebody has an answer to this :-)
>
> Kind regards,
>   Steve
>
> Am 23.01.2013 um 21:02 schrieb Pierre Casenove:
>
> Hello list,
> I'm using spacewalk 1.8 on a rhel 5 server.
> I've been trying to search an errata by CVE.
> In the search field, I put the name of the CVE (for example CVE-2012-0611)
> and select "Search by CVE" but it fails with error "could not execute
> query".
> In the catalina.out file, I've got the following error:
> 2013-01-23 16:32:27,138 [TP-Processor8] WARN
>  com.redhat.rhn.frontend.action.errata.ErrataSearchAction - Performing
> errata search
> redstone.xmlrpc.XmlRpcFault: redstone.xmlrpc.XmlRpcFault:
> --- The error occurred in
> com/redhat/satellite/search/db/errata_handler.xml.
> --- The error occurred while applying a parameter map.
> --- Check the listErrataByCVE-InlineParameterMap.
> --- Check the statement (query failed).
> --- Cause: org.postgresql.util.PSQLException: ERROR: operator does not
> exist: numeric = character varying
>
> Is this a known issue?
>
> Thanks in advance,
>
> Pierre
>  _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130124/a7b8c273/attachment.htm>