WordPress.org

1. cregy
   Member
   Posted 3 years ago #

   Hi Guys

   I have tried the above plugin with beta 2 and found this error for the events part of the php:
   Events

   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 > '2005-11-27 00:00:00' AND p.id = post_id AND p.post_author = u.id AND category_id = 2 ORDER BY post_date LIMIT 5

   * No events.

   However if you remove these lines:
   <?php _e('Events'); ?>
   <?php ec3_get_events(5); ?>
   it works fine.

   It is on display at:
   <http://www.cornwallinfo.info>

   The plugin used is:
   <http://blog.firetree.net/2005/07/18/eventcalendar-30/>

   Any ideas on getting it to work fully please?

   Thanks.

   Rich

2. andrewj
   Member
   Posted 3 years ago #

   Hi,
   I don't know if this was posted somewhere else..

   In order to correct this problem open eventcalendar3.php with a txt editor. This file should be located in the directory /wp-content/plugins

   Modify lines 737 and 1134. Replacing u.user_nickname with display_name.

Topic Closed

This topic has been closed to new replies.