[Fwd: Re: [EventCalendar] Re: vcal output error apparantly?]
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
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>
>> 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:
That's OK. I can muddle on by in German.
Here is the real reason, I think...
> 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
>> 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
Skype u/n: malcolmbell
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the EventCalendar