[EventCalendar] WordPress Categories generate error (EC3.1._pre14)

[Gerjan Boer]

I had to delete the IGNORE tag out of the queries, to avoid error messages. Works fine

Gerjan Boer
  ----- Original Message ----- 
  From: TIGA31328 at cs.com 
  To: eventcalendar at firetree.net 
  Sent: Friday, October 06, 2006 6:35 AM
  Subject: Re: [EventCalendar] WordPress Categories generate error (EC3.1._pre14)



  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





------------------------------------------------------------------------------


  _______________________________________________
  EventCalendar at firetree.net mailing list
  Unsubscribe: http://penguin.firetree.net/eventcalendar
  Download: http://sf.net/projects/wpcal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20061006/97d7eaf1/attachment-0001.html