Re: Having problems getting started with Zyons

Quick update, Ian has updated the source in svn to fix the glitch. I've svn-uped and it everything is hunky-dory... Thanks very much Ian, from a reported glitch at 10:16 through to resolution by 12:31. Nice one! Cheers, Tone --~--~-~--~~~---~--~~ You received

Re: Having problems getting started with Zyons

I've posted a ticket at http://zyons.python-hosting.com/ticket/3 with a description of the problem and a possible solution based on the SQL alias. Funny, I would have thought there were more MySQL 4.0-4.1 people around than that (which would have shown the glitch earlier), guess I really do need

Re: Having problems getting started with Zyons

Thanks Ian, Malcolm, this works!; mysql> select content_type_id, object_id, sum( unique_views) as sum_uv from counter_objecthourcounter where site_id=1 and effective_date >= '2006-07-18 09:50:07' and content_type_id in (30) group by content_type_id, object_id order by sum_uv desc LIMIT 40;

Re: Having problems getting started with Zyons

On Wed, 2006-07-19 at 10:40 +, tonemcd wrote: > I dug around a little, href="http://archives.neohapsis.com/archives/mysql/2005-q2/1966.html;>this > helped a lot - and I found that this works (4.1.18-standard); > > mysql> select content_type_id, object_id, sum( unique_views) from >

Re: Having problems getting started with Zyons

try order by 3 descOn 19/07/2006, at 8:40 PM, tonemcd wrote:I dug around a little, http://archives.neohapsis.com/archives/mysql/2005-q2/1966.html">thishelped a lot - and I found that this works (4.1.18-standard);mysql> select

Re: Having problems getting started with Zyons

I dug around a little, http://archives.neohapsis.com/archives/mysql/2005-q2/1966.html;>this helped a lot - and I found that this works (4.1.18-standard); mysql> select content_type_id, object_id, sum( unique_views) from counter_objecthourcounter where site_id=1 and effective_date >=

Re: Having problems getting started with Zyons

hmm..the SQL shouldn't be that complex.. it's pretty standardcan you try running it without the date ?or perhaps changethe with content_type_id in (30) to content_type_id = 30On 19/07/2006, at 8:10 PM, tonemcd wrote:Ian,I think that's it - it definitely causes an SQL error on

Re: Having problems getting started with Zyons

Ian, I think that's it - it definitely causes an SQL error on MySQL 4.1.18-standard. Drat. Our main systems (where I intend to run django 'for real') are stuck on the 4.1 series for the time being (hence why my machine is still running 4.1.18-standard). However, as I make the final decisions on

Re: Having problems getting started with Zyons

didn't 'diss' it at all.bugs happen.have you tried running the SQL directly from the mysql command prompt?it doesn't cause an error on mysql 5.0.16 or 5.1.11;(maybe the trackback will help.On 19/07/2006, at 7:56 PM, tonemcd wrote:Sorry Ian, I didn't mean to diss your application in the

Re: Having problems getting started with Zyons

Sorry Ian, I didn't mean to diss your application in the main discusssion forum! I just thought it might be a stupid user problem (I couldn't find it in the zyons.com forum). I've been watching the development of zyons for a while with a view to using it for the first stage of our Zope migration

Re: Having problems getting started with Zyons

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

Re: Having problems getting started with Zyons

On Wed, 2006-07-19 at 09:16 +, 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

Having problems getting started with Zyons

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