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

Dr. Peter Troxler peter.troxler at gmx.net
Wed Apr 4 11:26:05 UTC 2007


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/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20070404/1ced188b/attachment.htm


More information about the EventCalendar mailing list