[EventCalendar] Eventcalendar OK on Wordpress 2

Darrell Schulte d at schulte.mn
Fri Jan 6 20:49:00 UTC 2006


On Jan 6, 2006, at 12:04 AM, miri wrote:

> I tried updating my test site to this version with the same  
> settings as above and I get this DB error in my sidebar (called via  
> the ec3_get_events(5) function):
>
>
> 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_posts p, wp_post2cat p2c, wp_users u WHERE post_status =  
> 'publish' AND post_date_gmt > '2006-01-06 00:00:00' AND p.id =  
> post_id AND p.post_author = u.id AND category_id = 10 ORDER BY  
> post_date LIMIT 5
>
>
> I can make this go away by changing line 736-738 of  
> eventcalendar3.php from:
> post_date,
> u.user_nickname AS author
> FROM $tableposts p, $tablepost2cat p2c, $tableusers u
>
> to:
> post_date
> FROM $tableposts p, $tablepost2cat p2c, $tableusers u
>
> But I still have the same problem when I try to access an upcoming  
> event and am not logged in as admin - instead of the event, I get a  
> WordPress404 error. I can view the event just fine if I am logged in.

Ok, I think I got it...when you removed that line from  
eventcalendar3.php, you changed the query. There are two references  
to "user_nickname" in this file, change both of them to  
"user_nicename" instead of the change you implemented and the 404s  
should go away.

Darrell Schulte
http://schulte.mn





More information about the EventCalendar mailing list