web/modules/rhn/RHN/DB/Scheduler.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 3ebe752c01faa2e685e82bf6b59567a682d6ee30 Author: Ville Salmela Ville.Salmela@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,
spacewalk-commits@lists.fedorahosted.org