[EventCalendar] Re: vcal output error apparantly?

Alex Tingle alex at firetree.net
Mon Feb 20 16:00:18 UTC 2006


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!

-Alex




More information about the EventCalendar mailing list