[EventCalendar] Event List Ordering

Hunter Greene hunter at brainspiral.com
Wed Dec 10 23:30:23 UTC 2008


Hi -

We're having a problem with the event list ordering with the sidebar  
widget (currently running 3.2.dev-02).  Regardless of the query string  
(currently ec3_after=today&order=asc&posts_per_page=5), what is  
displayed is always the 5 events furthest in the future.  Changing the  
'order' doesn't seem to make any difference.

Has anyone noticed this?

Might it have something to do with these query errors:

WordPress database error Unknown column 'wp_ec3_schedule.post_id' in  
'field list' for query  SELECT SQL_CALC_FOUND_ROWS  wp_posts.*,  
IF(wp_ec3_schedule.post_id IS  
NULL,wp_posts.post_date,MIN(wp_ec3_schedule.start)) AS ec3_start  FROM  
wp_posts  LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id   
WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status =  
'publish' OR wp_posts.post_status = 'private') AND  
(ec3_sch.end>='2008-12-10')  GROUP BY wp_posts.ID ORDER BY  
`wp_posts`.`sticky`='1' DESC,`wp_posts`.`ordering`  
ASC,`wp_posts`.`post_date` DESC,`wp_posts`.`post_title` ASC LIMIT 0, 5

Thanks!

hunter




More information about the EventCalendar mailing list