[pLog-svn] r2340 - plog/branches/plog-1.0.2/class/dao
Oscar Renalias
phunkphorce at gmail.com
Sat Jul 16 07:43:20 GMT 2005
is everybody experiencing the same issue? I cannot reproduce it... (I
am using custom urls too)
Oscar
On 7/16/05, Paul Westbrook <paul at westbrooks.org> wrote:
> 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>
>
>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.plogworld.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
>
>
>
More information about the pLog-svn
mailing list