<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
Crapy hotmail...<BR>Please find attached the diff.<BR>I've created BZ 724963 also.<BR><br> <BR><div>> Date: Fri, 29 Jul 2011 17:37:55 +0200<br>> From: jpazdziora@redhat.com<br>> To: spacewalk-list@redhat.com<br>> Subject: Re: [Spacewalk-list] Error 500 on snapshots pages<br>> <br>> On Mon, Jul 25, 2011 at 01:13:54PM +0000, Pierre Casenove wrote:<br>> > <br>> > 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.<br>> > 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<br>> > 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 (+)<br>> <br>> Pierre,<br>> <br>> could you please attach the diff? Your MUA seems to be screwing the<br>> newlines badly, so we really cannot use them.<br>> <br>> Thank you,<br>> <br>> -- <br>> Jan Pazdziora<br>> Principal Software Engineer, Satellite Engineering, Red Hat<br>> <br>> _______________________________________________<br>> Spacewalk-list mailing list<br>> Spacewalk-list@redhat.com<br>> https://www.redhat.com/mailman/listinfo/spacewalk-list<br></div> </div></body>
</html>