Tadashi Okoshi
slash****@users*****
2006年 6月 6日 (火) 11:22:14 JST
Index: affelio/lib/Affelio/Managing/NewsAggregator.pm
diff -u affelio/lib/Affelio/Managing/NewsAggregator.pm:1.24 affelio/lib/Affelio/Managing/NewsAggregator.pm:1.25
--- affelio/lib/Affelio/Managing/NewsAggregator.pm:1.24 Tue Jun 6 11:08:42 2006
+++ affelio/lib/Affelio/Managing/NewsAggregator.pm Tue Jun 6 11:22:14 2006
@@ -14,7 +14,7 @@
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
#
-# $Id: NewsAggregator.pm,v 1.24 2006/06/06 02:08:42 slash5234 Exp $
+# $Id: NewsAggregator.pm,v 1.25 2006/06/06 02:22:14 slash5234 Exp $
package Affelio::Managing::NewsAggregator;
{
@@ -89,14 +89,14 @@
##############################
#retrieve all friend records from DB
- my $query = "SELECT datetime, af_id, nickname, app_install_name, title, description, creator, URL FROM $af->{site__dbtbl_prefix}_CORE_nghr_news order by datetime desc WHERE af_type='$type'";
+ my $query = "SELECT datetime, af_id, nickname, app_install_name, title, description, creator, URL FROM $af->{site__dbtbl_prefix}_CORE_nghr_news WHERE af_type='$type' order by datetime desc";
my $sth;
eval{
$sth = $af->getDB->prepare($query);
$sth->execute();
};
if($@){
- throw Affelio::exception::DBException($af->getDB->errstr);
+ throw Affelio::exception::DBException($af->getDB->errstr . "<P>Query=[$query]");
}
debug_print("NewsAggregator::retrieve_news: end.");