I went back and forth with many viable attempts to correct the issue I was having but in the end a fresh install did the trick. In hindsite now I suspect I had a corrupt DB installation. Get the com_comprofiler.zip file that Annabel posted on an earlier post and do the following;

1.) Create a new DB on my server
2.) Create a new folder location for new installation (Only if you want to keep the old installation)
3.) Upload and install Mambo4.6.2 (Might as well get the latest)
4.) Upload and install any Template or graphics created.
5.) Export the OLD DB using phpMyAdmin
6.) Import the OLD DB into new DB.
7.) Get Annabels com_comprofiler.zip file
8.) Install CB1.1 and ran through CB configuration etc. Use com_comprofiler.zip file from Annabel
9.) Using CB tools, synced users.
10.) Test site and voila....... should work!

Good Luck!

JKC

Post edited by: jkcgroup, at: 2007/12/03 14:38

Hi all,
I made, Al Warren's changes on admin.php

Step 1. - At about line 107 of administrator/includes/admin.php in function mosBasicXML::end_element():

ReplaceCode:

$this->chardata = str_replace(' ampersand ', '&', $this->chardata);

WithCode:

$this->chardata = trim(str_replace(' ampersand ', '&', $this->chardata));

Step 2. - At about line 119 of administrator/includes/admin.php in function mosBasicXML::character_data():

ReplaceCode:

$this->chardata .= trim($data);

WithCode:

$this->chardata .= $data;

and tried to install annabels com_comprofiler, but got the following, (Am I missing something?):

Installation Process:
Start correcting icons in administration backend.
FINISHED: Image of menu entry 0 has been corrected.
FINISHED: Image of menu entry 1 has been corrected.
FINISHED: Image of menu entry 2 has been corrected.
FINISHED: Image of menu entry 3 has been corrected.
FINISHED: Image of menu entry 4 has been corrected.
FINISHED: Image of menu entry 5 has been corrected.
/hermes/web09/b795/blu.ayolov/prop//images/comprofiler/ already exists!
/hermes/web09/b795/blu.ayolov/prop//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.
Upload universal - Failed
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler' already exists SQL=CREATE TABLE `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;
SQL =
CREATE TABLE `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;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_field_values' already exists SQL=CREATE TABLE `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 ;
SQL =
CREATE TABLE `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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_fields' already exists SQL=CREATE TABLE `mos_comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `table` varchar(50) NOT NULL default '#__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 ;
SQL =
CREATE TABLE `mos_comprofiler_fields` (
`fieldid` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`table` varchar(50) NOT NULL default '#__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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_lists' already exists SQL=CREATE TABLE `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 ;
SQL =
CREATE TABLE `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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_tabs' already exists SQL=CREATE TABLE `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 ;
SQL =
CREATE TABLE `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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_userreports' already exists SQL=CREATE TABLE `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 ;
SQL =
CREATE TABLE `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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_members' already exists SQL=CREATE TABLE `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 ;
SQL =
CREATE TABLE `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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_views' already exists SQL=CREATE TABLE `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 ;
SQL =
CREATE TABLE `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 ;
Fatal: Installer error with /hermes/web09/b795/blu.ayolov/prop/media/install_476018157183f/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1050
Table 'mos_comprofiler_plugin' already exists SQL=CREATE TABLE `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;
SQL =
CREATE TABLE `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;

Post edited by: yincito, at: 2007/12/12 19:11

Think I worked it out, with so many instalations I had to uninsatll in phpMyAdmin CB
1. in modules
2. in components

there must be tables:
`mos_comprofiler`,
`mos_comprofiler_fields`,
`mos_comprofiler_field_values`,
`mos_comprofiler_lists`,
`mos_comprofiler_members`,
`mos_comprofiler_plugin`,
`mos_comprofiler_tabs`,
`mos_comprofiler_userreports`,
`mos_comprofiler_views`


And then Re-install CB annabel's comprofiler.zip and the mod_cblogin.zip with mambo Universal installers.

But now I get the: "Not authorised view ressource" when I click anything in the login module.

I am getting the same error when I install this component into mambo 4.6.2, exact same error codes as posted by jplagarde on 2007/08/09, So then I tried to install the eddited component that was previously posted into this topic and I get the following errors when i try to import the users:

SQL errorDB function failed with error number 1146
Table 'jboadmin_mamb1.mos_comprofiler' doesn't exist SQL=INSERT IGNORE INTO mos_comprofiler(id,user_id) SELECT id,id FROM mos_users
SQL =
INSERT IGNORE INTO mos_comprofiler(id,user_id) SELECT id,id FROM mos_users

What is it thatm i am doing wrong? I emptied the tables from my data base using phpdbadmin thingy as instructed then checked the setting and all of the settings are as they were supposed to be. I installed the edited component and it installed just fine without any errors and when i look at the tables in the database i only see 8 tables instead of the 9 that are supposed to be there.

the error i am refering to is the original error at the beginning of this forum.