[Fwd: Re: [EventCalendar] Re: vcal output error apparantly?]

Malcolm Bell malcolm at 3hc.co.uk
Mon Feb 20 16:24:23 UTC 2006

I can confirm that simply changing 2.0 to 1.0 doesn't help.  I've also 
discovered the standard is 148 pages long (eek) but will have a look a 
bit later.

Alex - what are the implications for everywhere else that you have used 
this construct in the sql?  Would you expect other operations not to 
work, and if so which ones as I'll take a look.


-------- Original Message --------
Subject: 	Re: [EventCalendar] Re: vcal output error apparantly?
Date: 	Mon, 20 Feb 2006 16:00:18 +0000
From: 	Alex Tingle <alex at firetree.net>
To: 	eventcalendar at firetree.net
References: 	<1140383383.14238.14.camel at localhost> 
<1140385114.14245.19.camel at localhost> 
<d467fc795297497792748585d2d6189e at firetree.net> 
<1140449976.25934.20.camel at localhost>

Hi Peter,

>> Do you have a better link than simply to planetmysql? I can't find the
>> specific article to which you were referring.
> Unfortunately not. I've googled for 'Unknown column in on clause' and
> got a german page, which had the solution:
> http://www.issociate.de/board/post/304577/ 
> Unknown_column_'..'_in_'on_clause'.html

That's OK. I can muddle on by in German.

Here is the real reason, I think...

http://dev.mysql.com/doc/refman/5.0/en/join.html :
>  Previously, the comma operator (,) and  JOIN both had the same  
> precedence, so  the join expression t1, t2 JOIN t3 was  interpreted as  
> ((t1, t2) JOIN t3). Now  JOIN has higher precedence, so the   
> expression is interpreted as (t1, (t2 JOIN  t3)). This change affects  
> statements that use an  ON clause, because that clause can  refer only  
> to columns in the operands of the join, and the  change in precedence  
> changes interpretation of what those  operands are.

I conclude that the error could be eliminated by putting parentheses ()  
around the comma-separated list of tables.

>> Hmm. I suspect it might simply be the version specifier. We changed it
>> to version 2 in order to keep OSX's iCal happy. Try changing it back  
>> to
>> version1, and see if that helps.
> No, I don't think so. I have two iCal files laying around here (for
> german holidays) which are both version 2.0 and are working fine.
> It's only a "nice to have" for me, so I'll only take a look at it, if I
> have a little more time.

I'd be grateful. I can't test everything on everything!


EventCalendar mailing list
EventCalendar at firetree.net

website:    www.3hc.co.uk
Skype u/n:  malcolmbell

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060220/61f8ad11/attachment-0001.htm

More information about the EventCalendar mailing list