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

[Dr. Peter Troxler]

sorry, forgot to add:

this below is only correct, if the category base is *not* identical  
to the wordpress-install-directory

/ pt
On 8 apr 2007, at 12:25, Dr. Peter Troxler wrote:

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