[EventCalendar] Re: vcal output error apparantly?
alex at firetree.net
Mon Feb 20 16:00:18 UTC 2006
>> 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!
More information about the EventCalendar