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

Dr. Peter Troxler peter.troxler at gmx.net
Sun Apr 8 16:54:08 UTC 2007


On 8 apr 2007, at 15:21, Alex Tingle wrote:

> 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...

I'll reproduce it on my test site,
You'll need a user & password:
The user alex now has the password elgnit .

but this has no influence on the error I get  ... I just want to keep  
people out from my test factory

>
> 1. The URL

http://test.yourauthor.org/about/contact/

> 2. Your rewrite rules (in .htaccess)

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

# END WordPress


> 3. The SQL error message.
I get this one when I open the image in a new window:

> 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-08 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-08 14:40: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20070408/02e50c3e/attachment.htm


More information about the EventCalendar mailing list