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

[BalearWeb]

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
>
>
>