java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

New commits: commit 66ca926bea3e7f48e6b40532648df0cbe58999b2 Author: Milan Zazrivec mzazrivec@redhat.com Date: Mon Dec 23 13:55:20 2013 +0100

Remove extraneous character from query

This is to fix: ... java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml index bf964c3..8e3af2b 100644 --- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml +++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml @@ -487,7 +487,7 @@ SELECT DISTINCT E.id, E.advisory_name AS advisory, and S.user_id = :user_id and S.label = 'channels_for_errata' and E.id not in (select errata_id from rhnChannelErrata where channel_id = :custom_cid) - and E.id not in (select original_id from rhnChannelErrata CE, rhnErrataCloned EC where CE.errata_id = EC.id and CE.channel_id = :custom_cid); + and E.id not in (select original_id from rhnChannelErrata CE, rhnErrataCloned EC where CE.errata_id = EC.id and CE.channel_id = :custom_cid) </query> </mode>