[EventCalendar] conflict ec_3.1 and dagondesign formmailer v.5.22 -> SQL error

[Alex Tingle]

Peter,

This is a problem with the formmailer plugin. They need to use an alias
with their LEFT JOIN. It's a common problem (I made this mistake with EC
until I started getting error reports).

Contact the formmailer developers and give them the bug report. If they
want some help fixing their problem, then you should tell them to e-mail
me.

-Alex

--

On Wed, 4 Apr 2007 13:26:05 +0200
"Dr. Peter Troxler" <peter.troxler at gmx.net> wrote:

> when ec_3.1.0 is activated and keep events separate selected it  
> generates this mysql error (we've seen it before in oct last year, I  
> think, and it seemed to be fixed at that time)
> 
> > WordPress database error: [Column 'category_id' in where clause is  
> > ambiguous]
> > SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON  
> > (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON  
> > (wp_post2cat.category_id = wp_categories.cat_ID) LEFT JOIN  
> > wp_post2cat ec3_post2cat ON ec3_post2cat.post_id=id LEFT JOIN  
> > wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id AND  
> > ec3_sch.end>='2007-04-04 00:00:00' WHERE 1=1 AND (((post_title LIKE  
> > '%8%') OR (post_content LIKE '%8%')) OR (post_title LIKE '%8%') OR  
> > (post_content LIKE '%8%')) AND (category_id = '0') AND  
> > post_date_gmt <= '2007-04-04 11:00:59' AND (post_status = "publish"  
> > OR post_author = 3 AND post_status != 'draft' AND post_status !=  
> > 'static') AND post_status != "attachment" AND (ec3_sch.post_id IS  
> > NOT NULL OR ec3_post2cat.category_id!=3) GROUP BY wp_posts.ID ORDER  
> > BY post_date DESC LIMIT 0, 10
> 
> when formmailer tries to generate a captcha image:
> http://www.yourauthor.org/content/wp-content/plugins/dd-formmailer/dd- 
> formmailer.php?v=1
> 
> obviously the formmailer plugin includes the wp-blog-header.php in  
> this function "to access WP stuff" (line 48 of the plugin)
> 
> plus some "could not modify header information" (which is kind of  
> logical)
> 
> this disappears when I switch to "events are normal posts"  (this  
> also seems kind of logical to me, actually)
> 
> installed ec_3.1.1, but does not change anything to it
> 
> any clues ?
> 
> / Peter
> 
> PS dagondesign formmailer is here: http://www.dagondesign.com/ 
> articles/secure-form-mailer-plugin-for-wordpress/
> 
> 


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