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

[Jan Pazdziora]

On Fri, Sep 16, 2011 at 02:38:20PM +0200, Gerald wrote:

> Both errors persists, for system_list I still get:
> 
> --
> [Fri Sep 16 14:29:11 2011] [error] Execution of
> /var/www/html/network/software/packages/system_list.pxt failed at Fri Sep 16
> 14:29:11 2011: Cannot bind unknown placeholder ':p1' at
> /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560.
> --
> 
> but for target_systems I now get this error-log:
> 
> --
> [Fri Sep 16 14:27:46 2011] [error] Execution of
> /var/www/html/network/software/packages/target_system_list.pxt failed at Fri
> Sep 16 14:27:46 2011: RHN::Exception: DBD::Pg::st execute failed: ERROR:
> function nvl(evr_t, evr_t) does not exist at character 243\nHINT:  No
> function matches the given name and argument types. You might need to add
> explicit type casts.\n\n  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm

[...]

> I guess the latter is a small fix, could you just point me to the right SQL
> for the missing NVL function?

You don't want that. Instead, you probably want to apply patch

	http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=cab6342be786e25f9ce2cae6665e26c1e99940a8

to your installation.

> I already tried debugging before with carp, but I'll try again for the "
> Cannot bind unknown placeholder". 

Great.

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