<html> <head> <style></style> </head> <body class='hmmessage'><div dir='ltr'> Here is the SQL statement executed:<div><div>ERROR: syntax error at or near "MINUS" at character 869</div><div>STATEMENT:</div><div> SELECT PN.id AS NAME_ID,</div><div> PE.id AS EVR_ID,</div><div> PN.name AS NAME,</div><div> PE.version AS VERSION,</div><div> PE.release AS RELEASE,</div><div> PE.epoch AS EPOCH,</div><div> PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,</div><div> UPPER(PN.name || '-' || evr_t_as_vre_simple(PE.evr)) AS U_NVRE</div><div> FROM rhnPackageName PN,</div><div> rhnPackageEVR PE,</div><div> rhnPackageNEVRA PNEVRA,</div><div> rhnSnapshotPackage SP,</div><div> rhnSnapshot S</div><div> WHERE S.id = $1</div><div> AND S.server_id = $2</div><div> AND S.id = SP.snapshot_id</div><div> AND SP.nevra_id = PNEVRA.id</div><div> AND PNEVRA.name_id = PN.id</div><div> AND NOT EXISTS (SELECT 1 FROM rhnPackageSyncBlacklist PSB WHERE</div><div> PSB.package_name_id = PN.id AND org_id is NULL OR org_id = $3)</div><div> AND PNEVRA.evr_id = PE.id</div><div> AND NOT EXISTS (</div><div> SELECT 1 FROM rhnServerPackage SP</div><div> WHERE SP.server_id = $2</div><div> AND SP.name_id = PN.id</div><div> AND SP.evr_id = PE.id</div><div> )</div><div> MINUS</div><div> SELECT PN.id AS NAME_ID,</div><div> PE.id AS EVR_ID,</div><div> PN.name AS NAME,</div><div> PE.version AS VERSION,</div><div> PE.release AS RELEASE,</div><div> PE.epoch AS EPOCH,</div><div> PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,</div><div> UPPER(PN.name || '-' || evr_t_as_vre_simple(PE.evr)) AS U_NVRE</div><div> FROM rhnPackageName PN,</div><div> rhnPackageEVR PE,</div><div> rhnPackage P,</div><div> rhnChannelPackage CP,</div><div> rhnSnapshotChannel SC</div><div> WHERE SC.snapshot_id = $1</div><div> AND SC.channel_id = CP.channel_id</div><div> AND CP.package_id = P.id</div><div> AND P.name_id = PN.id</div><div> AND P.evr_id = PE.id</div><div> ORDER BY 8</div><br><div><hr id="stopSpelling">From: pedro109@hotmail.com<br>To: spacewalk-list@redhat.com<br>Date: Fri, 22 Jul 2011 05:55:53 +0000<br>Subject: [Spacewalk-list] Error 500 on snapshots pages<br><br> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="Generator" content="Microsoft SafeHTML"> <style> .ExternalClass .ecxhmmessage P {padding:0px;} .ExternalClass body.ecxhmmessage {font-size:10pt;font-family:Tahoma;} </style> <div dir="ltr"> <font class="ecxApple-style-span" face="Tahoma" size="2">Hello,</font><div style="font-family:Tahoma;font-size:10pt">On spacewalk 1.5 and postgresql 8.4 installation, when I go to Systems --> "SystemName" --> Provisionning --> Snapshots and the I click on any entry, I get the following traceback:</div><div style="font-family:Tahoma;font-size:10pt"><br></div><div><div><font class="ecxApple-style-span" face="Tahoma" size="2">Error message:</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> RHN::Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near "MINUS" at character 869</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> RHN::DB::st /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 564 RHN::DB::handle_error</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 75 RHN::DB::st::execute_h</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> RHN::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108 RHN::DB::DataSource::run_query</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> RHN::DB::SystemSnapshot /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 164 RHN::DataSource::execute_query</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 119 RHN::DB::SystemSnapshot::package_list_is_servable</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160 Sniglets::Snapshot::snapshot_details</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72 PXT::Parser::expand_tag</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 510 PXT::Parser::expand_tags</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113 PXT::ApacheHandler::pxt_parse_data</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113 (eval)</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> main -e 0 PXT::ApacheHandler::handler</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"> main -e 0 (eval)</font></div></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2">I can modify whatever source you want to do some tests, it's just a test box, not a production one!</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2">Thanks</font></div> </div> <br>_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list</div></div> </div></body> </html>