Please Help !!! Problem installing community builder

[rakeshkumark]

Hi  Please Help !!!!!!!,
  I have installed the latest version of joomla (joomla! 1.0.12 Stable [ Sunfire ]),  I tried to install the community builder component ,but its giving following errors.

Code: Select all

1.0 Beta 4 to 1.0 RC 1 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 to 1.0 RC 1 failed! SQL error:DB function failed with error number 1054
Unknown column 'plugin_include' in 'field list' SQL=INSERT INTO `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 INTO `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 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 1054
Unknown column 'pluginclass' in 'field list' SQL=INSERT INTO `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 INTO `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 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 1054
Unknown column 'pluginclass' in 'where clause' SQL=UPDATE `jos_comprofiler_tabs` SET pluginid=2 WHERE pluginclass='getConnectionTab'
SQL =

UPDATE `jos_comprofiler_tabs` SET pluginid=2 WHERE pluginclass='getConnectionTab'


1.0 RC 1 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 1054
Unknown column 'pluginclass' in 'where clause' SQL=UPDATE `jos_comprofiler_tabs` SET `pluginclass`=NULL, `pluginid`=NULL WHERE `pluginclass` != 'getContactTab' AND `fields` = 1
SQL =

UPDATE `jos_comprofiler_tabs` SET `pluginclass`=NULL, `pluginid`=NULL WHERE `pluginclass` != 'getContactTab' AND `fields` = 1


1.0 RC 1 to 1.0 RC 2 part 3 Upgrade Applied Successfully!
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'ucmsnepal'@'localhost' for 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 and 1.0.1 to 1.0.2 Upgrade Applied Successfully!
D:/jithinadmin/Universal/ucmsnepal.com/www/images/comprofiler/ already exists!
D:/jithinadmin/Universal/ucmsnepal.com/www/images/comprofiler/gallery/ already exists!
airplane.gif Successfully added to the gallery!
ball.gif Successfully added to the gallery!
butterfly.gif Successfully added to the gallery!
car.gif Successfully added to the gallery!
dog.gif Successfully added to the gallery!
duck.gif Successfully added to the gallery!
fish.gif Successfully added to the gallery!
frog.gif Successfully added to the gallery!
guitar.gif Successfully added to the gallery!
kick.gif Successfully added to the gallery!
pinkflower.gif Successfully added to the gallery!
redflower.gif Successfully added to the gallery!
skater.gif Successfully added to the gallery!
index.html Successfully added to the gallery!
Installation finished. Important: Please read README.TXT and manual for further settings.

somehow its showing Upload component - Success at the bottom .But after installation if i click the tab management or plugin managemtn again its giving the error messages

DB function failed with error number 1054
Unknown column 'a.pluginid' in 'on clause' SQL=SELECT a.*, p.name AS pluginname, p.published AS pluginpublished FROM jos_comprofiler_tabs AS a LEFT JOIN jos_comprofiler_plugin AS p ON p.id = a.pluginid ORDER BY position, ordering LIMIT 0, 30

Please Help !!!!

Thanks in advance
Rakesh

[Colt_45]

Is this installation on a local machine or a hosted server?

What versions of PHP and MySQL

Did the MySQL database being used have a previous installation of Community Builder?

[rakeshkumark]

thank you,

Actually the website is a fresh installation .
And it is installed on a hosted server.

Will there be any problem if i delete the table " com_profiler " and the relevant tables ,and suppose if i reinstall the community builder after that .does that help ?

[Colt_45]

Deleting the tables manually could fix your problem.

Also, I remember some problems being reported with CB being installed on MySQL 5 servers. Try asking on the joomlapolis forums.

[rakeshkumark]

thank you,

I'll try that ..

[borja]

did yoou solve the problem? i´ve trying installing during one week. there are rest of previous failed installation. what i shold delete?