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

[Dr. Peter Troxler]

Alex

I checked the code of the formmailer plugin ... they are actually not  
using any database queries, let alone a LEFT JOIN ... so I actually  
don't see the point of telling them to use an alias.

I did some further investigations and found out, that having  
permalinks set as
/%category%/%author%/%year%/%postname%/
or
/%category%/%year%/%postname%/
or
/%category%/%year%/%post_id%/
(case 1)

results in an error, while changing them to
/%category%/%postname%/
or
/%category%/%author%/%postname%/
or
/%year%/%postname%/
or
/%year%/%category%/%post_id%/
(case 2)
lets the trouble disappear

so this let's me think that for some reason, wp interprets the path  
to the verification image in question:
http://site-url/wordpress-install-directory/wp-content/plugins/dd- 
formmailer/dd-formmailer.php?v=1
in one way or another, depending on what it is looking for in terms  
of permalinks.

obviously in case 1 it lets your plugin, together with the default  
query, generate the error. This actually might be a very special  
condition, i.e. the combination of the /%category%/ tag earlier in  
the permalink structure and the /%year%/ tag later in the permalink  
structure which you might not have caught when introducing your alias.

/ Peter

On 6 apr 2007, at 15:28, Alex Tingle wrote:

> 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
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar