java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml | 4
++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit ee0c0efe3ff17563bb3dbb257b56bd4cda1bd3ce
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Nov 29 16:29:34 2013 +0100
fixed typo
addressing
ERROR: syntax error at or near "$2" at character 188
STATEMENT: INSERT INTO rhnServerNeededCache (server_id, errata_id, package_id,
channel_id)
( SELECT DISTINCT
S.id as server_id,
$1 as errata_id,
P.id as package_id
$2 as channel_id
FROM
rhnPackage P,
...
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
index 6174660..86e408c 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/ErrataCache_queries.xml
@@ -103,7 +103,7 @@ DELETE FROM rhnOrgErrataCacheQueue WHERE org_id = :org_id
INSERT INTO rhnServerNeededCache (server_id, package_id, channel_id)
( SELECT DISTINCT
S.id as server_id,
- P.id as package_id
+ P.id as package_id,
:channel_id as channel_id
FROM
rhnPackage P,
@@ -140,7 +140,7 @@ DELETE FROM rhnOrgErrataCacheQueue WHERE org_id = :org_id
( SELECT DISTINCT
S.id as server_id,
:errata_id as errata_id,
- P.id as package_id
+ P.id as package_id,
:channel_id as channel_id
FROM
rhnPackage P,
Show replies by date