[Spacewalk-list] Error 500 on snapshots pages

[Pierre Casenove]

Crapy hotmail...Please find attached the diff.I've created BZ 724963 also.
 > Date: Fri, 29 Jul 2011 17:37:55 +0200
> From: jpazdziora at redhat.com
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] Error 500 on snapshots pages
> 
> On Mon, Jul 25, 2011 at 01:13:54PM +0000, Pierre Casenove wrote:
> > 
> > Hello,I've modified 4 queries in order to get this work... But I don't have an oracle set up to test my queries.Moreover, I'm not sure the queries actually returns the legitimate results.
> > I insist on the fact that I'm not a DBA. I'm really not sure that the rewritten queries are correct. Please have a look on the diffs
> > Here are the diff on the three modifed files, in folder /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource/xml:diff config_queries.xml /root/config_queries.xml.orig85,90c85,90<   FROM rhnConfigFile CF<   LEFT OUTER JOIN rhnConfigRevision CR ON (CR.config_file_id = CF.id)<   LEFT OUTER JOIN rhnSnapshotConfigRevision SCR ON (SCR.config_revision_id = CR.id)<   LEFT OUTER JOIN rhnConfigFileName CFN ON (CFN.id = CF.config_file_name_id)<   LEFT OUTER JOIN rhnConfigContent CCon ON (CCon.id = CR.config_content_id)<   LEFT OUTER JOIN rhnChecksumView Csum ON (Csum.id = CCon.checksum_id)--->   FROM rhnConfigContent CCon,>        rhnConfigFileName CFN,>        rhnConfigFile CF,>        rhnConfigRevision CR,>        rhnSnapshotConfigRevision SCR,>        rhnChecksumView Csum91a92,96>    AND SCR.config_revision_id = CR.id>    AND CR.config_content_id = CCon.id (+)>    AND CR.config_file_id = CF.id>    AND CF.config_file_name_id = CFN.id>    AND  CCon.checksum_id = Csum.id (+)
> 
> Pierre,
> 
> could you please attach the diff? Your MUA seems to be screwing the
> newlines badly, so we really cannot use them.
> 
> Thank you,
> 
> -- 
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110730/dd0f1c62/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: requests_diff.txt
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110730/dd0f1c62/attachment.txt>