[EventCalendar] Event List Ordering
alex at firetree.net
Wed Dec 10 23:49:40 UTC 2008
Sorry to hear you are having problems. Thank you for trying out the dev version.
*Which* development version did you download (sadly, the version number is
Hunter Greene wrote:
> 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
Hmm. Sticky posts. I've had trouble with that plug-in before.
Can you try turning off all your other plug-ins. If that fixes the problem,
then reactive them one by one until you find the culprit. Then get back to me
and I'll see what I can do.
I must say, those back-ticks in the SQL look really dodgy to me.
:: Let me solve your problems: http://www.firetree.net/alex/
:: alex.tingle AT firetree.net +44-7901-552763
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://penguin.firetree.net/pipermail/eventcalendar/attachments/20081210/525a7a97/signature-0001.pgp
More information about the EventCalendar