[pLog-svn] r4572 - plog/branches/lifetype-1.1.5/class/summary/dao

Oscar Renalias oscar at renalias.net
Wed Jan 31 11:07:36 EST 2007


In that case I am afraid that it will have to stay as it is, you may  
choose to apply the fix in the forthcoming 1.1.5 release or keep the  
pre-1.1.5 behaviour. I wasn't able to understand the previous query  
(we didn't write it in the first place) and this is all I can come up  
with at the moment, sorry.

On 31 Jan 2007, at 18:06, BalearWeb wrote:

> myphpadmin shows a list of 15 blog rows, it looks like it works  
> fine there.
> Nevertheless, the list just include the blogs that have been updated
> most recently,
> and I think that is not a good reference. In our community, it  
> includes,
> for example,
> a blog that has only posted 1 single post in January. We can say that
> that blog
> is one of the top 15 active blogs.
>
>
> Oscar Renalias wrote:
>> That's weird, I'm not getting any error in my local instance.
>>
>> Would you be able to try to the following query in your database
>> client (something like mysqladmin will do) and see what the results
>> are? It's the same query that the code is executing.
>>
>> SELECT id, num_posts, last_update_date FROM lt_blogs WHERE
>> show_in_summary = '1' AND last_update_date >= 20070101000000 AND
>> last_update_date <= 20070131173715 AND status = 1 AND
>> last_update_date > create_date ORDER BY last_update_date DESC,
>> num_posts DESC LIMIT 0,15
>>
>> (you probably need to replace "lt_blogs" with "plog_blogs" depending
>> on your prefix settings)
>>
>> On 31 Jan 2007, at 17:34, BalearWeb wrote:
>>
>>
>>> It caused an error on my install:
>>> Fatal error: Call to a member function on a non-object in
>>> /home/sites/bloc.balearweb.net/web/class/summary/dao/
>>> summarystats.class.php
>>> on line 204
>>>
>>> Oscar Renalias wrote:
>>>
>>>> Is revision 4640 better?
>>>>
>>>> http://devel.lifetype.net/svn/plog/plog/branches/lifetype-1.1.5/
>>>> class/
>>>> summary/dao/summarystats.class.php
>>>>
>>> _______________________________________________
>>> pLog-svn mailing list
>>> pLog-svn at devel.lifetype.net
>>> http://limedaley.com/mailman/listinfo/plog-svn
>>>
>>>
>>
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://limedaley.com/mailman/listinfo/plog-svn
>>
>>
>>
>
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>



More information about the pLog-svn mailing list