hello list,
Please find attached a patch to correct an ISE encountered on perl
pages, when scheduling an package deployment, going into In-Progress
System and clicking on a client.
Thanks in advance to review it.
Pierre
From 6d604d3c994dc5c931ef45358990f01bf55130d3 Mon Sep 17 00:00:00 2001
From: Pierre Casenove
Date: Wed, 11 Jul 2012 16:20:49 +0000
Subject: [PATCH] Fix ISE on pgsql:
Error message:
RHN::Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near
"NAME" at character 40
---
web/modules/rhn/RHN/DB/Server.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/web/modules/rhn/RHN/DB/Server.pm b/web/modules/rhn/RHN/DB/Server.pm
index 8d466ad..235c483 100644
--- a/web/modules/rhn/RHN/DB/Server.pm
+++ b/web/modules/rhn/RHN/DB/Server.pm
@@ -848,7 +848,7 @@ sub server_event_delta_action {
my $dbh = RHN::DB->connect;
my $sth = $dbh->prepare(<<EOS);
-SELECT rTO.label AS OPERATION, PN.name NAME, PN.name || '-' ||
PE.evr.as_vre_simple() AS NVRE
+SELECT rTO.label AS OPERATION, PN.name AS NAME, PN.name || '-' ||
evr_t_as_vre_simple(PE.evr) AS NVRE
FROM rhnPackageName PN,
rhnPackageEVR PE,
rhnTransactionOperation rTO,
--
1.7.4.1_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
