web/modules/rhn/RHN/DB/Scheduler.pm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 3ebe752c01faa2e685e82bf6b59567a682d6ee30
Author: Ville Salmela <Ville.Salmela(a)csc.fi>
Date: Fri May 6 11:42:21 2011 +0200
Fix remote commands on Spacewalk 1.4 and PostgreSQL
Addressing
Execution of /var/www/html/network/systems/ssm/provisioning/remote_command_conf.pxt
failed at Fri Apr 29 15:05:05 2011:
RHN::Exception: DBD::Pg::st execute failed: ERROR: column "action_id" is
of type numeric but expression is of type text at character 82
HINT: You will need to rewrite or cast the expression.
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw
RHN::DB::st /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 564
RHN::DB::handle_error
RHN::DB::Scheduler /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Scheduler.pm 1530
RHN::DB::st::execute_h
Sniglets::ListView::SystemList
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/SystemList.pm 385
RHN::DB::Scheduler::schedule_remote_command
diff --git a/web/modules/rhn/RHN/DB/Scheduler.pm b/web/modules/rhn/RHN/DB/Scheduler.pm
index 75a2ba2..2ee15e4 100644
--- a/web/modules/rhn/RHN/DB/Scheduler.pm
+++ b/web/modules/rhn/RHN/DB/Scheduler.pm
@@ -1511,7 +1511,7 @@ sub schedule_remote_command {
# can't use the normal add_systems for the set...
$sth = $dbh->prepare(<<EOQ);
INSERT INTO rhnServerAction (server_id, action_id, status)
-SELECT DISTINCT S.id, :action_id, :status
+SELECT DISTINCT S.id, :action_id + 0, :status + 0
FROM rhnServer S,
rhnClientCapabilityName CCN,
rhnClientCapability CC,
Show replies by date