backend/server/rhnChannel.py | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-)
New commits: commit 3cf5d524129038e68cf4daf4d6191e6e7ddcfff4 Author: Michael Mraka michael.mraka@redhat.com Date: Tue Aug 16 14:48:37 2011 +0200
730452 - fixed table aliasses
fixing SQL Error generated: ('ORA-00904: "PR"."SENSE": invalid identifier\n', 904, "select pp.package_id, 'provides', pp.capability_id, pp.sense, pc.name, pc.version from rhnPackageProvides pp, rhnPackageCapability pc where pp.package_id = :package_id and pp.capability_id = pc.id union all select ...
diff --git a/backend/server/rhnChannel.py b/backend/server/rhnChannel.py index d3bb81f..c8af77d 100644 --- a/backend/server/rhnChannel.py +++ b/backend/server/rhnChannel.py @@ -1123,10 +1123,10 @@ def list_all_packages_complete_sql(channel_id): and pr.capability_id = pc.id union all select - pr.package_id, + prec.package_id, 'recommends', - pr.capability_id, - pr.sense, + prec.capability_id, + prec.sense, pc.name, pc.version from @@ -1137,10 +1137,10 @@ def list_all_packages_complete_sql(channel_id): and prec.capability_id = pc.id union all select - pr.package_id, + sugg.package_id, 'suggests', - pr.capability_id, - pr.sense, + sugg.capability_id, + sugg.sense, pc.name, pc.version from @@ -1151,10 +1151,10 @@ def list_all_packages_complete_sql(channel_id): and sugg.capability_id = pc.id union all select - pr.package_id, + supp.package_id, 'supplements', - pr.capability_id, - pr.sense, + supp.capability_id, + supp.sense, pc.name, pc.version from
spacewalk-commits@lists.fedorahosted.org