[Spacewalk-list] Error 500 on page event.pxt

[Pierre Casenove]

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
-------------- next part --------------
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