Re: Having problems getting started with Zyons

[Ian Holsman]

Hi Tony. Thanks for giving Zyons a whirl. 'popular_objects' is part of the 'counter' app which tracks what people are viewing. you don't need it installed for the rest of the app to run. that being said. he SQL you are showing me doesn't seem to contain the 'group by' command which looks like it is present in  all the vairous forms in zilbo/common/counter/models.py ;( can you post the trackback on zyons in the 'bugs' forum.. http://zyons.com/forum/bugs/ as I'm not sure django-users is appropriate for discussion custom apps. On 19/07/2006, at 7:16 PM, tonemcd wrote: Hi all, I'm trying to get the Zyons community/bulletin board system up and running - we think it could be extremely useful for a large part of our education community, and will assist us in migrating from Zope to Django. Trouble is, I can't get it to work on my machine (MacBook Pro, Python 2.4.3/MySL 4.1.18-standard) I get this error on pointing at the root; ProgrammingError at / (1111, 'Invalid use of group function') Template error (at line 38) In template /Users/bingobob/Sites/zilbo/common/forum/templates/forum/main_page.html, error at line 38 Caught an exception while rendering. 28         {% latest_conversations conv 10 %} 29 <ul> 30   {% for c in conv %} 31   <li><a href=''>{{ c.forum.name }}</a> <a href=''>{{ c.name }}</a></li> 32   {% endfor %} 33 </ul> 34 </div> 35 36 <div class='right_side'> 37 <b>Most Popular</b> 38 {% popular_objects Conversation c_o 40 %} 39 <ul> 40 {% for a in c_o %} 41 <li><a href=''>{{ a.0.name }}</a></li> 42 {% endfor %} 43 </ul> 44 </p> 45 </div> 46 </div> 47 48 {% endblock %} The actual SQL generated is; select content_type_id, object_id, sum( unique_views)  from counter_objecthourcounter  where site_id=1 and effective_date >= '2006-07-18 09:12:08' and content_type_id in (30) order by sum( unique_views ) desc LIMIT 40 Is this a simple thing that I can fix (ie I've done something stupid), or do I need to include more traceback information? Cheers for any help, Tone --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---