[EventCalendar] calendar broke

Dr. Peter Troxler peter.troxler at gmx.net
Sun Feb 12 18:29:22 UTC 2006


Jaap

there is a bug in eventcalendar (3.0; don't know if fixed in a more  
recent release, this is what you should check first)

  it should query u.user_nicename ... you need to change
user_nickname to user_nicename
in cols 737 and 1134

/ Peter

On 12 feb 2006, at 14:39, Jaap Stronks wrote:

> Hi,
>
> after upgrading to Wordpress 2.0, and applying the hack, I get the  
> following error when I want to display the list of upcoming events  
> in my sidebar:
>
> //
>
> WordPress database error: [Unknown column 'u.user_nickname' in  
> 'field list']
> SELECT p.id AS id, post_title, post_date, u.user_nickname AS author  
> FROM wp_3posts p, wp_3post2cat p2c, wp_3users u WHERE post_status =  
> 'publish' AND post_date_gmt > '2006-02-12 00:00:00' AND p.id =  
> post_id AND p.post_author = u.id AND category_id = 11 ORDER BY  
> post_date LIMIT 5
>
>     * No events.
>
> //
>
> That message puzzles me - I have no experience with mysql.
>
> Also, when viewing the category page I get the 'sorry, no posts  
> matched your criteria" message. When I deactivate the plugin, or  
> change the event category, the category page displays only past  
> events (that's normal). At all times, individual entries remain  
> accessible through their own permalinks.
>
> Anyone have any idea how to solve this? I would really appreciate  
> it, the local student community of Nijmegen, the Netherlands kinda  
> depends on it!
>
> Cheers,
>
> Jaap Stronks
>
>
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
>




More information about the EventCalendar mailing list