web/modules/rhn/RHN/DB/Server.pm | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 3379c0ba58589ecb7b480a1e1672807d0bfaa0cc
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Fri Jul 20 13:13:04 2012 +0200
841453 - forcing parameter to be numeric
[error] Execution of
/var/www/html/network/systems/details/history/snapshots/rollback.pxt failed at Wed Jul 18
18:12:52 2012: RHN::Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near
"SCC"
LINE 1: INSERT INTO rhnServerConfigChannel SCC
^
RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 121 RHN::Exception::DB::throw
RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 452 RHN::DB::handle_error
RHN::DB::Server /usr/share/perl5/vendor_perl/RHN/DB/Server.pm 2016
RHN::DB::st::execute_h
RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 424
RHN::DB::Server::set_normal_config_channels
RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 352
(eval)
Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 301
RHN::DB::SystemSnapshot::rollback_to_snapshot
Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 300 (eval)
PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 482
Sniglets::Snapshot::system_snapshot_rollback_cb
PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103
PXT::ApacheHandler::pxt_parse_data
PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval)
main -e 0 PXT::ApacheHandler::handler\n main -e 0 (eval)
diff --git a/web/modules/rhn/RHN/DB/Server.pm b/web/modules/rhn/RHN/DB/Server.pm
index 235c483..3b73400 100644
--- a/web/modules/rhn/RHN/DB/Server.pm
+++ b/web/modules/rhn/RHN/DB/Server.pm
@@ -2005,9 +2005,9 @@ EOS
}
$sth = $dbh->prepare(<<EOS);
-INSERT INTO rhnServerConfigChannel SCC
+INSERT INTO rhnServerConfigChannel
(server_id, config_channel_id, position)
-SELECT DISTINCT S.id, :ccid, :pos
+SELECT DISTINCT S.id, :ccid + 0, :pos + 0
FROM rhnServer S
WHERE S.id = :sid
AND EXISTS (
Show replies by date