web/modules/rhn/RHN/DB/ChannelEditor.pm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 94e4ee1b730becd24c9285752fad9dcb790954ab
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Mon Feb 28 12:19:06 2011 +0100
Adding the AS keyword to column aliases for PostgreSQL.
Addressing
RHN::Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near
"NAME" at character 26
diff --git a/web/modules/rhn/RHN/DB/ChannelEditor.pm
b/web/modules/rhn/RHN/DB/ChannelEditor.pm
index f89e71c..ec6a43f 100644
--- a/web/modules/rhn/RHN/DB/ChannelEditor.pm
+++ b/web/modules/rhn/RHN/DB/ChannelEditor.pm
@@ -157,7 +157,7 @@ sub channels_visible_to_org {
my $sth;
$query = <<EOQ;
-SELECT ACh.channel_name NAME, ACh.channel_id ID, ACh.channel_depth DEPTH, C.org_id
CHANNEL_ORG_ID
+SELECT ACh.channel_name as NAME, ACh.channel_id as ID, ACh.channel_depth as DEPTH,
C.org_id as CHANNEL_ORG_ID
FROM rhnAvailableChannels ACh, rhnChannel C
WHERE ACh.org_id = :org_id
AND C.id = ACh.channel_id
Show replies by date