Created attachment 498711 [details] Converts ksid to long before handing it to the SQL query When I try to change the locale settings for a kickstart profile via "System Details" -> "Locale", I get an internal server error due to an SQL exception. The problem ist that the query "valid_timezone_for_kickstart_profile" in ./java/code/src/com/redhat/rhn/common/db/datasource/xml/General_queries.xml expects a numeric parameter ksid, but the method getValidTimezones in ./java/code/src/com/redhat/rhn/manager/kickstart/KickstartLister.java assigns a string. This results in an SQL exception since PostgreSQL doesn't do an implicit cast. The attached patch fixes the problem, though I'm not sure it's the proper way to do so.
I think function should get Long rather than casting it to string and then back. Fixed in master by commit be6374188bebab573ba993c9d57f9258ad6043a2 704446 - removed unnecessary cast to string
This bugzilla is currently MODIFIED, so we believe the fix is in the Spacewalk nightly yum repository at http://spacewalk.redhat.com/yum/nightly/ Therefore, moving ON_QA.
Spacewalk 1.5 was released.