[EventCalendar] Beta 2

Darrell Schulte d at schulte.mn
Sun Nov 27 19:54:38 UTC 2005


On Nov 27, 2005, at 1:11 PM, Alex Tingle wrote:

> On Sun, 27 Nov 2005 17:43:56 +0000
> Richard Brown <rich at cregy.co.uk> wrote:
>
>> 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
>
> Thanks for the heads-up. Where is the new version's database schema  
> documented? What's the new name for wp_users.user_nickname?

-- 
-- Table structure for table `wp_usermeta`
-- 

CREATE TABLE `wp_usermeta` (
   `umeta_id` bigint(20) NOT NULL auto_increment,
   `user_id` bigint(20) NOT NULL default '0',
   `meta_key` varchar(255) default NULL,
   `meta_value` longtext,
   PRIMARY KEY  (`umeta_id`),
   KEY `user_id` (`user_id`),
   KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `wp_usermeta`
-- 

INSERT INTO `wp_usermeta` VALUES (1, 1, 'wp_user_level', '10');
INSERT INTO `wp_usermeta` VALUES (2, 1, 'wp_capabilities', 'a:1:{s: 
13:"administrator";b:1;}');
INSERT INTO `wp_usermeta` VALUES (3, 1, 'first_name', '');
INSERT INTO `wp_usermeta` VALUES (4, 1, 'last_name', '');
INSERT INTO `wp_usermeta` VALUES (5, 1, 'nickname', 'HERE IS MY  
NICKNAME');
INSERT INTO `wp_usermeta` VALUES (6, 1, 'description', '');
INSERT INTO `wp_usermeta` VALUES (7, 1, 'jabber', '');
INSERT INTO `wp_usermeta` VALUES (8, 1, 'aim', '');
INSERT INTO `wp_usermeta` VALUES (9, 1, 'yim', '');



More information about the EventCalendar mailing list