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

[Alex Tingle]

Hmm.

The rewrite rules can't actually be anything to do with the bug - they
simply rewrite the URL into the non-permalink ?cat=3&m=123456 style URL.

Can you reproduce the error, and send me...

1. The URL
2. Your rewrite rules (in .htaccess)
3. The SQL error message.

thanks,

-Alex

--

On Sun, 8 Apr 2007 12:25:09 +0200
Dr. Peter Troxler <peter.troxler at gmx.net> 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


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