[pLog-svn] r2340 - plog/branches/plog-1.0.2/class/dao

[Paul Westbrook]

Hello,
    This change causes the following error:

Jul 15 17:03:16 server httpd: PHP Fatal error:  Call to a member  
function on a non-object in  
/var/www/plog-1.0/class/net/customrequestgenerator.class.php on line 76


When I revert to the previous revision the problem goes away.  I am  
using custom urls for my blog.

--Paul


On Jul 15, 2005, at 12:58 PM, oscar at devel.plogworld.net wrote:

> Author: oscar
> Date: 2005-07-15 19:58:20 +0000 (Fri, 15 Jul 2005)
> New Revision: 2340
>
> Modified:
>    plog/branches/plog-1.0.2/class/dao/articlecategories.class.php
> Log:
> added matt's optimizations to the queries to load blog categories, see  
> http://bugs.plogworld.net/view.php?id=614
>
>
> Modified:  
> plog/branches/plog-1.0.2/class/dao/articlecategories.class.php
> ===================================================================
> ---  
> plog/branches/plog-1.0.2/class/dao/articlecategories.class.php	2005 
> -07-15 06:22:07 UTC (rev 2339)
> +++  
> plog/branches/plog-1.0.2/class/dao/articlecategories.class.php	2005 
> -07-15 19:58:20 UTC (rev 2340)
> @@ -167,8 +167,9 @@
>  				          c.last_modification AS last_modification,  
> c.in_main_page AS in_main_page,
>  						  c.parent_id AS parent_id, c.description AS description,  
> c.properties AS properties,
>  						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*))  
> AS num_articles, a.date AS last_update
> -						  FROM {$prefix}articles_categories c LEFT JOIN  
> {$prefix}article_categories_link l
> -						  ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id =  
> l.article_id
> +						  FROM {$prefix}articles a
> +						  LEFT JOIN {$prefix}articles_categories c ON c.id =  
> l.category_id
> +						  LEFT JOIN {$prefix}article_categories_link l ON a.id =  
> l.article_id
>  						  WHERE c.blog_id = '".Db::qstr($blogId)."'";
>  						
>  			if( $onlyInMainPage )
> @@ -210,8 +211,9 @@
>  				          c.last_modification AS last_modification,  
> c.in_main_page AS in_main_page,
>  						  c.parent_id AS parent_id, c.properties AS properties,  
> c.description AS description,
>  						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*))  
> AS num_articles, a.date AS last_update
> -						  FROM {$prefix}articles_categories c LEFT JOIN  
> {$prefix}article_categories_link l
> -						  ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id =  
> l.article_id
> +						  FROM {$prefix}articles a
> +						  LEFT JOIN {$prefix}articles_categories c ON c.id =  
> l.category_id
> +						  LEFT JOIN {$prefix}article_categories_link l ON a.id =  
> l.article_id
>  						  WHERE c.blog_id = $blogId";
>  						
>  			if( $onlyInMainPage )
> @@ -478,9 +480,10 @@
>  			$query = "SELECT a.id as article_id, c.id AS id, c.name AS name,  
> c.url AS url, c.blog_id AS blog_id,
>  				          c.last_modification AS last_modification,  
> c.in_main_page AS in_main_page,
>  						  c.parent_id AS parent_id, c.properties AS properties,  
> c.description AS description,
> -						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*))  
> AS num_articles, a.date AS last_update
> -						  FROM {$prefix}articles_categories c LEFT JOIN  
> {$prefix}article_categories_link l
> -						  ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id =  
> l.article_id
> +						  c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*))  
> AS num_articles, a.date AS last_update 						
> +						  FROM {$prefix}articles a
> +						  LEFT JOIN {$prefix}articles_categories c ON c.id =  
> l.category_id
> +						  LEFT JOIN {$prefix}article_categories_link l ON a.id =  
> l.article_id						
>  						  WHERE a.id IN (".$articleIds.") ";
>  			if( $blogId > -1 ) {
>  				$query .= " AND a.blog_id = '".Db::qstr( $blogId )."' AND  
> c.blog_id = '".Db::qstr( $blogId )."'";	
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.plogworld.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
>
>
--
Paul Westbrook
paul at westbrooks.org
<http://www.westbrooks.org>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2367 bytes
Desc: not available
Url : http://www.plogworld.net/pipermail/plog-svn/attachments/20050715/86edb3b9/smime.bin