[Spacewalk-list] Installed Systems/Target Systems - 500 error

[Jan Pazdziora]

On Thu, Sep 08, 2011 at 01:19:28PM +0200, Gerald wrote:
> Hi Michael,
> 
> here is the requested error-log:
> --
> [Thu Sep 08 13:16:53 2011] [error] Execution of /var/www/html/network/software/packages/system_list.pxt failed at Thu Sep  8 13:16:53 2011: Cannot bind unknown placeholder ':p1' at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.
> --
>  [Thu Sep 08 13:17:11 2011] [error] Execution of /var/www/html/network/software/packages/target_system_list.pxt failed at Thu Sep  8 13:17:11 2011: Cannot bind unknown placeholder ':p1' at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.

I was not able to reproduce, fresh nightly install on RHEL 5.

You might want to wrap that

	$self->bind_param(":$k" => $v, $attr)

with eval, catch $@, use Carp, and call Carp::confess so that we get
the backtrace to see which code produced that :p1 parameter for which
SQL.

I suspect there is something wrong with the elaborators for the
potential_systems_for_package and systems_with_package queries but I
don't see what exactly might be wrong.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat