[EventCalendar] WordPress Categories generate error (EC 3.1._pre14)

[TIGA31328 at cs.com]

Alex,

       Thanks, sorry it took me a bit to get back to you on this, I have been 
traveling, out of town as I write this.  I did the update you suggested, I 
don't get that error any more but I do get the obligatory SQL Event error that 
several have reported.  I will update to Pre15 when I get a chance to see if it 
resolves the SQL problems.  Good thing is that the calendar itself is working 
fine on display and usage, just when I post do I get an error and the post is 
succesful, so a minor issue for now.

Thanks again,
Patrick

P.S. - I greatly appreciate all of the work and support that you and the 
others are doing with this plugin, by far it is the best support and development I 
have seen for a WP plugin.



> Subj: Re: [EventCalendar] WordPress Categories generate error (EC 
> 3.1._pre14) 
> Date:10/2/2006 4:54:57 PM Mountain Daylight Time
> From:alex at firetree.net
> To:eventcalendar at firetree.net
> Received from Internet: 
> 
> 
> 
> Try this...
> 
> Index: eventcalendar3.php
> ===================================================================
> --- eventcalendar3.php  (revision 163)
> +++ eventcalendar3.php  (working copy)
> @@ -252,7 +252,7 @@
> {
>    global $ec3,$wpdb;
>    // The necessary joins are decided upon in ec3_filter_posts_where().
> -  if($ec3->join_post2cat &&!preg_match("/ JOIN +$wpdb->post2cat 
> +/i",$join))
> +  if($ec3->join_post2cat)
>    {
>      $join.=" LEFT JOIN $wpdb->post2cat ec3_post2cat ON 
> ec3_post2cat.post_id=id";
>    }
> 
> 
> -Alex
> 
> --
> 
> 
> On Mon, 02 Oct 2006 18:39:29 -0400
> TIGA31328 at cs.com wrote:
> 
> >
> >Hiya folks,
> >
> >A new error I am experiencing since updating to 3.1._pre14:
> >
> >Error is reproduced by attempting to click on any Category link in the 
> blogspace, results in a "Not Found" page in WP with this error displayed at the 
> top of the page(above all blog content):
> >
> >
> >
> >WordPress database error: [Unknown table 'ec3_post2cat' in where clause]
> >SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID = 
> wp_postmeta.post_id LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) 
> WHERE 1=1 AND (category_id = 6) AND post_date_gmt <= '2006-10-02 22:35:59' 
> AND ((post_status = "publish" OR (post_status = "private" AND 
> (wp_postmeta.meta_key = 'post_level' AND wp_postmeta.meta_value <= 10 ))) OR post_author = 1 
> AND post_status != 'draft' AND post_status != 'static') AND post_status != 
> "attachment" AND ec3_post2cat.category_id!=10 GROUP BY wp_posts.ID ORDER BY 
> post_date DESC LIMIT 0, 25
> >
> >
> >NOTE:  I have not installed any other plugins or made any changes to my 
> databases since this update.
> >
> >Any ideas are greatly appreciated.
> >
> >Thanks,
> >Patrick
> >
> >
> >_______________________________________________
> >EventCalendar mailing list
> >EventCalendar at firetree.net
> >Unsubscribe, or change options: http://penguin.firetree.net/eventcalendar
> 
> 
> -- 
> :: Let me solve your problems: http://www.firetree.net/consulting/
> :: alex.tingle AT firetree.net  +44-7901-552763 
> 
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> Unsubscribe, or change options: http://penguin.firetree.net/eventcalendar
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20061006/089861a0/attachment.htm