[EventCalendar] WordPress database error

[Alex Tingle]

Your problem is not EventCalendar, but another plugin. Whatever created 
this part of the SQL...

LEFT JOIN wp_catt_visibility
  ON (wp_post2cat.category_id = wp_catt_visibility.catt_ID)

The error message is quite correct, nobody's JOIN'd wp_post2cat (under 
that name), so this SQL is nonsense. You should contact the plugin 
author.

Something like this would work for them...

LEFT JOIN wp_post2cat myplugin_post2cat
  ON myplugin_post2cat.post_id=id
LEFT JOIN wp_catt_visibility
  ON (myplugin_post2cat.category_id = wp_catt_visibility.catt_ID)

-Alex

--
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763

On 11 Oct 2006, at 15:42, Dave Sabol wrote:

> Alex,
>
> Just tried the newest release. It didn't do a thing to fix my specific
> error. Not sure what to make of it...I upgraded another site a few
> days ago and it worked fine. I am on the save server, etc.
>
> http://www.sprcc.net/
>
> Dave
>
> _______________________________________________
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
> Download: http://sf.net/projects/wpcal