[EventCalendar] Event List Ordering

Alex Tingle alex at firetree.net
Wed Dec 10 23:49:40 UTC 2008


Hi Hunter,

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

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.

-Alex

-- 
:: 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...
Name: signature.asc
Type: application/pgp-signature
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 mailing list