[EventCalendar] Re: vcal output error apparantly?

Peter Allgeyer allgeyer at web.de
Sun Feb 19 21:38:34 UTC 2006


Am Sonntag, den 19.02.2006, 22:09 +0100 schrieb Peter Allgeyer:
> Hi,
> 
> same problem here (MySQL 5.0, WP 2.0.1).
> 
> post_author is bigint(20) in wp_posts, I can confirm that.
> 
> Let me know, if I can help further in debugging the problem.

Ok, found the solution (see http://www.planetmysql.org/):

Relace the ',' with INNER JOIN:

---< schnipp >---
SELECT p.id AS id,
  post_title,
  post_excerpt,
  DATE_FORMAT( post_date_gmt, '%Y%m%dT%H%i%sZ' ) AS dt_start,     
  user_nicename
FROM wp_posts p INNER JOIN wp_post2cat p2c
LEFT JOIN wp_users u ON u.ID = p.post_author
WHERE post_status = 'publish'
  AND p.id = post_id
  AND category_id =18
---< schnapp >---

BR,
  PIT


---------------------------------------------------------------------------
 copyleft(c) by |           If you want your program to be readable,
 Peter Allgeyer |   _-_     consider supplying the argument.  -- Larry
                | 0(o_o)0   Wall in the perl man page
---------------oOO--(_)--OOo-----------------------------------------------





More information about the EventCalendar mailing list