Hello everybody,
here is the solution:
**leave the admin.php as is do not remove the trim**

AND

STEP A. UNINSTALL CB Component (uninstall and Restoring your admin tool bar)
1.Log into your mambo admin site.
2.In admin URL window, specify the following url:
ttp://www.yourdomain.com/administrator/index2.php?option=com_installer&element=component
which brings you to the component window, to allow you unistall the CB component. As a result, your menu tool bar is fully restored.

STEP B. UNINSTALL CB module
1. Go to modules an uninstall CB Login module
2. Go to menu and select user menu
move to trash the 2 items created previously namely
the Component - Community Builder and the link URL

STEP C. DROP ALL comprofiler tables
using phpMyAdmin,
drop the comprofiler tables:
comprofiler,
comprofiler_fields,
comprofiler_field_values,
comprofiler_lists,
comprofiler_members,
comprofiler_plugin,
comprofiler_tabs,
comprofiler_userreports,
comprofiler_views

STEP D. Disable caching and SEF / SEF advance

STEP E. preparing a modified com_comprofiler.zip
as follows:
extract comprofiler.xml from the existing zip
remove all "IF NOT EXISTS" clause. Save comprofiler.xml. You now have a modified comprofiler.xml file which needs to be added to com_comprofiler.zip (replace the existing comprofiler.xml). You now have a modified com_comprofiler.zip.

STEP F. rerun the install process:
. Install comprofiler.zip as a component using your modified com_comprofiler.zip
. Install mod_cblogin.zip as a module.
. Edit CB login module params and publish it again.

STEP G. General configuration tasks:
go to Admin->Components->Community Builder->Tools

1. run Check Community Builder database
2. run Synchronize Users
3. run Load sample data.
go to Admin->Components->Community Builder->Configuration

complete various settings but most importantly in
the Registration tab, Allow User registration -->
Yes, independently of global setting.

STEP H)User menu configuration
1. Add a new user menu item for the comprofiler component (the users profile page):go to user menu, click New, select component, then Community Builder (com_comprofiler), give a name and save.
2. Add a new user menu item as a Link-URL and point it to index.php?option=com_comprofiler&task=usersList
(this will be the searchable users list).

STEP I) re-enable caching and SEF / SEF Advance.
LOGOFF admin! and you are done.

NOTE: if your admin session gets hang up in between the steps, use phpMyAdmin to empty the Session table
re-login admin if necessary.

This has been tested with

mambo 4.6.2 hosting environment:
Database Version: 4.0.18
PHP Version: 4.4.1
Web Server: Apache

Good Luck.
(please consider this as an alternate contribution
worthing more than the 32US$ CB documention subscription)
Forum-mambo-foundation.org will be advised accordingly about this workaround.

problem not solved for me, i can't install cb 1.1 on mambo site 4.6.2

always get a similar db error

please help me

Hello,

Did you try my solution as suggested ?
How far do you go. Describe your steps..

Annabel

thanks for your time I try to explain my stat

I have never try to install cb 1.1 with a modified admin.php trim, thereby step A and B was just already,I've check it however.

droped all comprofiler tables

caching and seo are disabled

Modified all this line in comprofiler.xml

CREATE TABLE IF NOT EXISTS `#__comprofiler` (

like this

CREATE TABLE `#__comprofiler` (

installation get error, if you wont I try to install agayn and post the exatly error
thanks daigo

Problem solved, but with a local installation and next uploaded to remote,i dont know if this is right, but now work thanks daigo

if you follow what annabelle says you'll have to enter the SQL table stuff yourself.

Go to your phpmyadmin, and then select the datyabase where Mambo is installed.

to to "SQL"

and paste the following

[code:1] CREATE TABLE IF NOT EXISTS `mos_comprofiler` ( `id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `firstname` VARCHAR( 100 ), `middlename` VARCHAR( 100 ) , `lastname` VARCHAR( 100 ), `hits` int(11) NOT NULL default '0', `avatar` varchar(255) default NULL, `avatarapproved` tinyint(4) default '1', `approved` tinyint(4) NOT NULL default '1', `confirmed` tinyint(4) NOT NULL default '1', `lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00', `banned` tinyint(4) NOT NULL default '0', `banneddate` datetime default NULL, `bannedby` int(11) default NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_field_values` ( `fieldvalueid` int(11) NOT NULL auto_increment, `fieldid` int(11) NOT NULL default '0', `fieldtitle` varchar(50) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `sys` tinyint(4) NOT NULL default '0', PRIMARY KEY (`fieldvalueid`) ) TYPE=MyISAM AUTO_INCREMENT=16 ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `table` varchar(50) NOT NULL default 'mos_comprofiler', `title` varchar(255) NOT NULL default '', `type` varchar(50) NOT NULL default '', `maxlength` int(11) default NULL, `size` int(11) default NULL, `required` tinyint(4) default '0', `tabid` int(11) default NULL, `ordering` int(11) default NULL, `cols` int(11) default NULL, `rows` int(11) default NULL, `value` varchar(50) default NULL, `default` MEDIUMTEXT default NULL, `published` tinyint(1) NOT NULL default '1', `registration` tinyint(1) NOT NULL default '0', `profile` tinyint(1) NOT NULL default '1', `readonly` TINYINT( 1 ) DEFAULT '0' NOT NULL, `calculated` tinyint(1) NOT NULL default '0', `sys` tinyint(4) NOT NULL default '0', PRIMARY KEY (`fieldid`) ) TYPE=MyISAM AUTO_INCREMENT=54 ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_lists` ( `listid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `description` mediumtext, `published` tinyint(1) NOT NULL default '0', `default` tinyint(1) DEFAULT '0' NOT NULL, `usergroupids` varchar(255) NULL, `sortfields` varchar(255) NULL, `ordering` int(11) NOT NULL default '0', `col1title` varchar(255) default NULL, `col1enabled` tinyint(1) NOT NULL default '0', `col1fields` mediumtext, `col2title` varchar(255) default NULL, `col2enabled` tinyint(1) NOT NULL default '0', `col1captions` tinyint(1) NOT NULL default '0', `col2fields` mediumtext, `col2captions` tinyint(1) NOT NULL default '0', `col3title` varchar(255) default NULL, `col3enabled` tinyint(1) NOT NULL default '0', `col3fields` mediumtext, `col3captions` tinyint(1) NOT NULL default '0', `col4title` varchar(255) default NULL, `col4enabled` tinyint(1) NOT NULL default '0', `col4fields` mediumtext, `col4captions` tinyint(1) NOT NULL default '0', PRIMARY KEY (`listid`) ) TYPE=MyISAM AUTO_INCREMENT=4 ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_tabs` ( `tabid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL default '', `description` text, `ordering` int(11) NOT NULL default '0', `width` VARCHAR( 10 ) DEFAULT '.5' NOT NULL , `enabled` TINYINT( 1 ) DEFAULT '1' NOT NULL , `plugin` VARCHAR( 255 ) DEFAULT NULL , `sys` tinyint(4) NOT NULL default '0', PRIMARY KEY (`tabid`) ) TYPE=MyISAM AUTO_INCREMENT=11 ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_userreports` ( `reportid` int(11) NOT NULL auto_increment, `reporteduser` int(11) NOT NULL default '0', `reportedbyuser` int(11) NOT NULL default '0', `reportedondate` date NOT NULL default '0000-00-00', `reportexplaination` text NOT NULL, `reportedstatus` tinyint(4) NOT NULL default '0', PRIMARY KEY (`reportid`) ) TYPE=MyISAM AUTO_INCREMENT=11 ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_members` ( `referenceid` int(11) NOT NULL default '0', `memberid` int(11) NOT NULL default '0', `accepted` tinyint(1) NOT NULL default '1', `pending` tinyint(1) NOT NULL default '0', `membersince` date NOT NULL default '0000-00-00', `description` varchar(255) default NULL, `type` MEDIUMTEXT default NULL, PRIMARY KEY (`referenceid`,`memberid`) ) TYPE=MyISAM ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_views` ( `viewer_id` int(11) NOT NULL default '0', `profile_id` int(11) NOT NULL default '0', `lastip` varchar(50) NOT NULL default '', `lastview` datetime NOT NULL default '0000-00-00 00:00:00', `viewscount` int(11) NOT NULL default '0', `vote` tinyint(3) default NULL, `lastvote` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`viewer_id`,`profile_id`,`lastip`) ) TYPE=MyISAM ;
CREATE TABLE IF NOT EXISTS `mos_comprofiler_plugin` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `name` varchar( 100 ) NOT NULL default '', `element` varchar( 100 ) NOT NULL default '', `type` varchar( 100 ) NULL default '', `folder` varchar( 100 ) NULL default '', `access` tinyint( 3 ) unsigned NOT NULL default '0', `ordering` int( 11 ) NOT NULL default '0', `published` tinyint( 3 ) NOT NULL default '0', `iscore` tinyint( 3 ) NOT NULL default '0', `client_id` tinyint( 3 ) NOT NULL default '0', `checked_out` int( 11 ) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `params` text NOT NULL , PRIMARY KEY ( `id` ) , KEY `idx_folder` ( `published` , `client_id` , `access` , `folder` ) ) TYPE=MyISAM AUTO_INCREMENT=500;
INSERT IGNORE INTO `mos_comprofiler_fields` (`fieldid`, `name`, `table`, `title`, `type`, `maxlength`, `size`, `required`, `tabid`, `ordering`, `cols`, `rows`, `value`, `default`, `published`, `registration`, `profile`, `calculated`, `sys`) VALUES (41, 'name', 'mos_users', '_UE_NAME', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (26, 'NA', 'mos_comprofiler', '_UE_ONLINESTATUS', 'status', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (27, 'lastvisitDate', 'mos_users', '_UE_LASTONLINE', 'date', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (28, 'registerDate', 'mos_users', '_UE_MEMBERSINCE', 'date', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (29, 'avatar', 'mos_comprofiler', '_UE_IMAGE', 'image', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (42, 'username', 'mos_users', '_UE_UNAME', 'predefined', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (45, 'NA', 'mos_comprofiler', '_UE_FORMATNAME', 'formatname', NULL , NULL , 0, NULL , NULL , NULL , NULL , NULL , NULL , 1, 0, 1, 1, 1), (46, 'firstname', 'mos_comprofiler', '_UE_YOUR_FNAME', 'predefined', NULL, NULL, 0, NULL , NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (47, 'middlename', 'mos_comprofiler', '_UE_YOUR_MNAME', 'predefined', NULL, NULL, 0, NULL , NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (48, 'lastname', 'mos_comprofiler', '_UE_YOUR_LNAME', 'predefined', NULL, NULL, 0, NULL , NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1), (49, 'lastupdatedate', 'mos_comprofiler', '_UE_LASTUPDATEDON', 'date', NULL , NULL , 0, NULL , NULL , NULL , NULL , NULL , NULL , 1, 0, 1, 1, 1), (50, 'email', 'mos_users', '_UE_EMAIL', 'primaryemailaddress', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, 1);
INSERT IGNORE INTO mos_comprofiler (id,user_id) SELECT id,id FROM mos_users
INSERT IGNORE INTO `mos_comprofiler_plugin` (`id`, `name`, `element`, `type`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'CB Core', 'cb.core', 'user', 'plug_cbcore', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (2, 'CB Connections', 'cb.connections', 'user', 'plug_cbconnections', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (3, 'Content Author', 'cb.authortab', 'user', 'plug_cbmamboauthortab', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (4, 'Simpleboard Forum', 'cb.simpleboardtab', 'user', 'plug_cbsimpleboardtab', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', ''), (5, 'Mamblog Blog', 'cb.mamblogtab', 'user', 'plug_cbmamblogtab', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (6, 'YaNC Newsletters', 'yanc', 'user', 'plug_yancintegration', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''), (7, 'Default', 'default', 'templates', 'default', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (8, 'WinClassic', 'winclassic', 'templates', 'winclassic', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (9, 'WebFX', 'webfx', 'templates', 'webfx', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (10, 'OSX', 'osx', 'templates', 'osx', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (11, 'Luna', 'luna', 'templates', 'luna', 0, 5, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (12, 'Dark', 'dark', 'templates', 'dark', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (13, 'Default language (English)', 'default_language', 'language', 'default_language', 0, -1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (14, 'CB Menu', 'cb.menu', 'user', 'plug_cbmenu', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (15, 'PMS MyPMS and Pro', 'pms.mypmspro', 'user', 'plug_pms_mypmspro', 0, 8, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
[/code:1]

you will get an error but ignore it, then install CB.

It worked for me