Please Help !!! Problem installing community builder - Joomla! Forum - community, help and support

hi  please !!!!!!!,
  have installed latest version of joomla (joomla! 1.0.12 stable [ sunfire ]),  tried install community builder component ,but giving following errors.

code: select all

1.0 beta 4 1.0 rc 1 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_tabs' sql=alter table jos_comprofiler_tabs add `plugin_include` varchar( 255 ) after `plugin` , add `fields` tinyint( 1 ) default '1' not null after `plugin_include`
sql =

alter table jos_comprofiler_tabs add `plugin_include` varchar( 255 ) after `plugin` ,
 add `fields` tinyint( 1 ) default '1' not null after `plugin_include`


1.0 beta 4 1.0 rc 1 failed! sql error:db function failed error number 1054
unknown column 'plugin_include' in 'field list' sql=insert `jos_comprofiler_tabs` ( `title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) values ( '_ue_contact_info_header', '', -4, '1', 1, 'getcontacttab', null, 1, 1), ( '_ue_authortab', '', -3, '1', 0, 'getauthortab', null, 0, 1), ( '_ue_forumtab', '', -2, '1', 0, 'getforumtab', null, 0, 1), ( '_ue_blogtab', '', -1, '1', 0, 'getblogtab', null, 0, 1);
sql =

insert `jos_comprofiler_tabs` ( `title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) values
 ( '_ue_contact_info_header', '', -4, '1', 1, 'getcontacttab', null, 1, 1),
 ( '_ue_authortab', '', -3, '1', 0, 'getauthortab', null, 0, 1),
 ( '_ue_forumtab', '', -2, '1', 0, 'getforumtab', null, 0, 1),
 ( '_ue_blogtab', '', -1, '1', 0, 'getblogtab', null, 0, 1);



update `jos_comprofiler_tabs` set position='cb_tabmain', displaytype='tab'


1.0 rc 1 1.0 rc 2 part 3 failed! sql error:db function failed error number 1054
unknown column 'pluginclass' in 'field list' sql=insert `jos_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `pluginclass`, `pluginid`, `fields`, `sys`, `position`, `displaytype`) values ( '_ue_menu', '', -10, '1', 1, 'getmenutab', 14, 0, 1, 'cb_head', 'html'), ( '_ue_connectionpaths', '', -9, '1', 1, 'getconnectionpathstab', 2, 0, 1, 'cb_head', 'html'), ( '_ue_profile_page_title', '', -8, '1', 1, 'getpagetitletab', 1, 0, 1, 'cb_head', 'html'), ( '_ue_portrait', '', -7, '1', 1, 'getportraittab', 1, 0, 1, 'cb_middle', 'html'), ( '_ue_user_status', '', -6, '.5', 1, 'getstatustab', 14, 0, 1, 'cb_right', 'html'), ( '_ue_pmstab', '', -5, '.5', 0, 'getmypmsprotab', 15, 0, 1, 'cb_right', 'html');
sql =

insert `jos_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `pluginclass`, `pluginid`, `fields`, `sys`, `position`, `displaytype`) values
 ( '_ue_menu', '', -10, '1', 1, 'getmenutab', 14, 0, 1, 'cb_head', 'html'),
 ( '_ue_connectionpaths', '', -9, '1', 1, 'getconnectionpathstab', 2, 0, 1, 'cb_head', 'html'),
 ( '_ue_profile_page_title', '', -8, '1', 1, 'getpagetitletab', 1, 0, 1, 'cb_head', 'html'),
 ( '_ue_portrait', '', -7, '1', 1, 'getportraittab', 1, 0, 1, 'cb_middle', 'html'),
 ( '_ue_user_status', '', -6, '.5', 1, 'getstatustab', 14, 0, 1, 'cb_right', 'html'),
 ( '_ue_pmstab', '', -5, '.5', 0, 'getmypmsprotab', 15, 0, 1, 'cb_right', 'html');


1.0 rc 1 1.0 rc 2 part 3 failed! sql error:db function failed error number 1054
unknown column 'pluginclass' in 'where clause' sql=update `jos_comprofiler_tabs` set pluginid=2 pluginclass='getconnectiontab'
sql =

update `jos_comprofiler_tabs` set pluginid=2 pluginclass='getconnectiontab'


1.0 rc 1 1.0 rc 2 part 3 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_members' sql=alter table `jos_comprofiler_members` add `reason` mediumtext default null after `membersince`
sql =

alter table `jos_comprofiler_members` add `reason` mediumtext default null after `membersince`


1.0 rc 1 1.0 rc 2 part 3 failed! sql error:db function failed error number 1054
unknown column 'pluginclass' in 'where clause' sql=update `jos_comprofiler_tabs` set `pluginclass`=null, `pluginid`=null `pluginclass` != 'getcontacttab' , `fields` = 1
sql =

update `jos_comprofiler_tabs` set `pluginclass`=null, `pluginid`=null `pluginclass` != 'getcontacttab' , `fields` = 1


1.0 rc 1 1.0 rc 2 part 3 upgrade applied successfully!
1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_fields' sql=alter table `jos_comprofiler_fields` change `default` `default` mediumtext default null;
sql =

alter table `jos_comprofiler_fields` change `default` `default` mediumtext default null;


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_fields' sql=alter table `jos_comprofiler_fields` change `tabid` `tabid` int(11) default null;
sql =

alter table `jos_comprofiler_fields` change `tabid` `tabid` int(11) default null;


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table jos_comprofiler add `registeripaddr` varchar( 50 ) default '' not null after `lastupdatedate`;
sql =

alter table jos_comprofiler add `registeripaddr` varchar( 50 ) default '' not null after `lastupdatedate`;


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table jos_comprofiler add `cbactivation` varchar( 50 ) default '' not null after `registeripaddr`;
sql =

alter table jos_comprofiler add `cbactivation` varchar( 50 ) default '' not null after `registeripaddr`;


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table jos_comprofiler add `message_last_sent` datetime not null default '0000-00-00 00:00:00' after `hits`;
sql =

alter table jos_comprofiler add `message_last_sent` datetime not null default '0000-00-00 00:00:00' after `hits`;


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table jos_comprofiler add `message_number_sent` int( 11 ) default 0 not null after `message_last_sent`;
sql =

alter table jos_comprofiler add `message_number_sent` int( 11 ) default 0 not null after `message_last_sent`;


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_field_values' sql=alter table `jos_comprofiler_field_values` add index fieldid_ordering (`fieldid`, `ordering` );
sql =

alter table `jos_comprofiler_field_values` add index fieldid_ordering (`fieldid`, `ordering` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_fields' sql=alter table `jos_comprofiler_fields` add index `tabid_pub_prof_order` ( `tabid` , `published` , `profile` , `ordering` );
sql =

alter table `jos_comprofiler_fields` add index `tabid_pub_prof_order` ( `tabid` , `published` , `profile` , `ordering` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_fields' sql=alter table `jos_comprofiler_fields` add index `readonly_published_tabid` ( `readonly` , `published` , `tabid` );
sql =

alter table `jos_comprofiler_fields` add index `readonly_published_tabid` ( `readonly` , `published` , `tabid` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_fields' sql=alter table `jos_comprofiler_fields` add index `registration_published_order` ( `registration` , `published` , `ordering` );
sql =

alter table `jos_comprofiler_fields` add index `registration_published_order` ( `registration` , `published` , `ordering` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_members' sql=alter table `jos_comprofiler_members` add index `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
sql =

alter table `jos_comprofiler_members` add index `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_members' sql=alter table `jos_comprofiler_members` add index `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
sql =

alter table `jos_comprofiler_members` add index `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_members' sql=alter table `jos_comprofiler_members` add index `membrefid` ( `memberid` , `referenceid` );
sql =

alter table `jos_comprofiler_members` add index `membrefid` ( `memberid` , `referenceid` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_plugin' sql=alter table `jos_comprofiler_plugin` add index `type_pub_order` ( `type` , `published` , `ordering` );
sql =

alter table `jos_comprofiler_plugin` add index `type_pub_order` ( `type` , `published` , `ordering` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_tabs' sql=alter table `jos_comprofiler_tabs` add index `enabled_position_ordering` ( `enabled` , `position` , `ordering` );
sql =

alter table `jos_comprofiler_tabs` add index `enabled_position_ordering` ( `enabled` , `position` , `ordering` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_lists' sql=alter table `jos_comprofiler_lists` add index `pub_ordering` ( `published` , `ordering` );
sql =

alter table `jos_comprofiler_lists` add index `pub_ordering` ( `published` , `ordering` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_lists' sql=alter table `jos_comprofiler_lists` add index `default_published` ( `default` , `published` );
sql =

alter table `jos_comprofiler_lists` add index `default_published` ( `default` , `published` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_userreports' sql=alter table `jos_comprofiler_userreports` add index `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` );
sql =

alter table `jos_comprofiler_userreports` add index `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_userreports' sql=alter table `jos_comprofiler_userreports` add index `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` );
sql =

alter table `jos_comprofiler_userreports` add index `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_views' sql=alter table `jos_comprofiler_views` add index `lastview` ( `lastview` );
sql =

alter table `jos_comprofiler_views` add index `lastview` ( `lastview` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler_views' sql=alter table `jos_comprofiler_views` add index `profile_id_lastview` (`profile_id`,`lastview`);
sql =

alter table `jos_comprofiler_views` add index `profile_id_lastview` (`profile_id`,`lastview`);


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table `jos_comprofiler` add unique key user_id (`user_id`);
sql =

alter table `jos_comprofiler` add unique key user_id (`user_id`);


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table `jos_comprofiler` add index `apprconfbanid` ( `approved` , `confirmed` , `banned` , `id` );
sql =

alter table `jos_comprofiler` add index `apprconfbanid` ( `approved` , `confirmed` , `banned` , `id` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table `jos_comprofiler` add index `avatappr_apr_conf_ban_avatar` ( `avatarapproved` , `approved` , `confirmed` , `banned` , `avatar` );
sql =

alter table `jos_comprofiler` add index `avatappr_apr_conf_ban_avatar` ( `avatarapproved` , `approved` , `confirmed` , `banned` , `avatar` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 failed! sql error:db function failed error number 1142
alter command denied user 'ucmsnepal'@'localhost' table 'jos_comprofiler' sql=alter table `jos_comprofiler` add index `lastupdatedate` ( `lastupdatedate` );
sql =

alter table `jos_comprofiler` add index `lastupdatedate` ( `lastupdatedate` );


1.0 rc 2, 1.0 , 1.0.1 1.0.2 upgrade applied successfully!
d:/jithinadmin/universal/ucmsnepal.com/www/images/comprofiler/ exists!
d:/jithinadmin/universal/ucmsnepal.com/www/images/comprofiler/gallery/ exists!
airplane.gif added gallery!
ball.gif added gallery!
butterfly.gif added gallery!
car.gif added gallery!
dog.gif added gallery!
duck.gif added gallery!
fish.gif added gallery!
frog.gif added gallery!
guitar.gif added gallery!
kick.gif added gallery!
pinkflower.gif added gallery!
redflower.gif added gallery!
skater.gif added gallery!
index.html added gallery!
installation finished. important: please read readme.txt , manual further settings.

somehow showing upload component - success @ bottom .but after installation if click tab management or plugin managemtn again giving error messages

db function failed error number 1054
unknown column 'a.pluginid' in 'on clause' sql=select a.*, p.name pluginname, p.published pluginpublished jos_comprofiler_tabs left join jos_comprofiler_plugin p on p.id = a.pluginid order position, ordering limit 0, 30

please !!!!

thanks in advance
rakesh

is installation on local machine or hosted server?

what versions of php , mysql

did mysql database being used have previous installation of community builder?