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

[Alex Tingle]

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