[pLog-svn] r4333 - plog/branches/lifetype-1.1.3/class/dao

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-11-26 18:54:07 +0000 (Sun, 26 Nov 2006)
New Revision: 4333

Modified:
   plog/branches/lifetype-1.1.3/class/dao/articlecategories.class.php
Log:
fixed an issue with an SQL query


Modified: plog/branches/lifetype-1.1.3/class/dao/articlecategories.class.php
===================================================================
--- plog/branches/lifetype-1.1.3/class/dao/articlecategories.class.php	2006-11-24 22:39:35 UTC (rev 4332)
+++ plog/branches/lifetype-1.1.3/class/dao/articlecategories.class.php	2006-11-26 18:54:07 UTC (rev 4333)
@@ -303,7 +303,7 @@
 			$category->setNumPublishedArticles( $this->getNumItems (
 					$this->getPrefix()."article_categories_link acl, ".$this->getPrefix()."articles a",
 					"acl.category_id = '".Db::qstr($category->getId())."' and acl.article_id = a.id and a.status = ".POST_STATUS_PUBLISHED,
-					"category_id"
+					"acl.category_id"
 			));
         	if( $result = $this->update( $category )) {
 				$this->_cache->removeData( $category->getBlogId(), CACHE_ARTICLE_CATEGORIES_BLOG );