Joomla/Mambo Community Builder 1.7.1 native for Joomla! 1.7.0 - 1.7.2, 1.6.0 - 1.6.6, 1.5.3 - 1.5.23, 1.0.0 - 1.0.15 and Mambo 4.5.0 - 4.6.5.


Copyright 2004-2011 MamboJoe/JoomlaJoe, Beat and CB team on joomlapolis.com . This component is released under the GNU/GPL version 2 License. All copyright statements must be kept. Derivate work must prominently duly acknowledge original work and include visible online links. Official site: www.joomlapolis.com 

Installation Process:
1.0 Beta 2 to 1.0 Beta 3 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_lists` ADD `default` TINYINT( 1 ) DEFAULT '0' NOT NULL, ADD `usergroupids` VARCHAR( 255 ), ADD `sortfields` VARCHAR( 255 ), ADD `ordering` INT( 11 ) DEFAULT '0' NOT NULL AFTER `published`
SQL = 
ALTER TABLE `#__comprofiler_lists`
 ADD `default` TINYINT( 1 ) DEFAULT '0' NOT NULL,
 ADD `usergroupids` VARCHAR( 255 ),
 ADD `sortfields` VARCHAR( 255 ),
 ADD `ordering` INT( 11 ) DEFAULT '0' NOT NULL AFTER `published`

1.0 Beta 2 to 1.0 Beta 3 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE jjint_comprofiler_lists SET `default`=1 WHERE published =1
SQL = 
UPDATE #__comprofiler_lists SET `default`=1 WHERE published =1

1.0 Beta 2 to 1.0 Beta 3 failed! SQL error:DB function failed with error number 42S02 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'jjint_comprofiler_lists'.SQL=UPDATE jjint_comprofiler_lists SET usergroupids = '29, 18, 19, 20, 21, 30, 23, 24, 25', sortfields = '`username` ASC'
SQL = 
UPDATE #__comprofiler_lists SET usergroupids = '29, 18, 19, 20, 21, 30, 23, 24, 25', sortfields = '`username` ASC'

1.0 Beta 2 to 1.0 Beta 3 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD `acceptedterms` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `bannedreason`
SQL = 
ALTER TABLE `#__comprofiler` ADD `acceptedterms` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `bannedreason`

1.0 Beta 2 to 1.0 Beta 3 Upgrade Applied Successfully.
1.0 Beta 3 to 1.0 Beta 4 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE jjint_comprofiler ADD `firstname` VARCHAR( 100 ) AFTER `user_id` , ADD `middlename` VARCHAR( 100 ) AFTER `firstname` , ADD `lastname` VARCHAR( 100 ) AFTER `middlename`
SQL = 
ALTER TABLE #__comprofiler ADD `firstname` VARCHAR( 100 ) AFTER `user_id` ,
 ADD `middlename` VARCHAR( 100 ) AFTER `firstname` ,
 ADD `lastname` VARCHAR( 100 ) AFTER `middlename` 

1.0 Beta 3 to 1.0 Beta 4 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` ADD `readonly` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `profile`
SQL = 
ALTER TABLE `#__comprofiler_fields` ADD `readonly` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `profile`

1.0 Beta 3 to 1.0 Beta 4 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD `width` VARCHAR( 10 ) DEFAULT '.5' NOT NULL AFTER `ordering` , ADD `enabled` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `width` , ADD `plugin` VARCHAR( 255 ) DEFAULT NULL AFTER `enabled`
SQL = 
ALTER TABLE `#__comprofiler_tabs` ADD `width` VARCHAR( 10 ) DEFAULT '.5' NOT NULL AFTER `ordering` ,
 ADD `enabled` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `width` ,
 ADD `plugin` VARCHAR( 255 ) DEFAULT NULL AFTER `enabled`

1.0 Beta 3 to 1.0 Beta 4 Upgrade Applied Successfully.
1.0 Beta 4 to 1.0 RC 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE jjint_comprofiler_tabs ADD `plugin_include` VARCHAR( 255 ) AFTER `plugin` , ADD `fields` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `plugin_include`
SQL = 
ALTER TABLE #__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=INSERT INTO `jjint_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 `#__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);

1.0 Beta 4 to 1.0 RC 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_lists` ADD `filterfields` VARCHAR( 255 ) AFTER `sortfields`;
SQL = 
ALTER TABLE `#__comprofiler_lists` ADD `filterfields` VARCHAR( 255 ) AFTER `sortfields`;

1.0 Beta 4 to 1.0 RC 1 Upgrade Applied Successfully.
1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` ADD `description` MEDIUMTEXT NOT NULL default '' AFTER `title`
SQL = 
ALTER TABLE `#__comprofiler_fields` ADD `description` MEDIUMTEXT  NOT NULL default '' AFTER `title` 

1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` CHANGE `title` `title` VARCHAR( 255 ) NOT NULL
SQL = 
ALTER TABLE `#__comprofiler_fields` CHANGE `title` `title` VARCHAR( 255 ) NOT NULL

1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=INSERT INTO `jjint_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_CONNECTION', '',99, '1', 0, 'getConnectionTab', NULL, 0, 1);
SQL = 
INSERT INTO `#__comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES 
 ( '_UE_CONNECTION', '',99, '1', 0, 'getConnectionTab', NULL, 0, 1);

1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=INSERT INTO `jjint_comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_NEWSLETTER_HEADER', '_UE_NEWSLETTER_INTRODCUTION', 99, '1', 0, 'getNewslettersTab', NULL, 0, 1);
SQL = 
INSERT INTO `#__comprofiler_tabs` (`title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES 
 ( '_UE_NEWSLETTER_HEADER', '_UE_NEWSLETTER_INTRODCUTION', 99, '1', 0, 'getNewslettersTab', NULL, 0, 1);

1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET sys=2, enabled=1 WHERE plugin='getContactTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET sys=2, enabled=1 WHERE plugin='getContactTab' 

1.0 RC 1 to 1.0 RC 2 part 1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_lists` ADD `useraccessgroupid` INT( 9 ) DEFAULT '18' NOT NULL AFTER `usergroupids`
SQL = 
ALTER TABLE `#__comprofiler_lists` ADD `useraccessgroupid` INT( 9 ) DEFAULT '18' NOT NULL AFTER `usergroupids` 

1.0 RC 1 to 1.0 RC 2 part 1 Upgrade Applied Successfully.
1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` CHANGE `plugin` `pluginclass` VARCHAR( 255 ) DEFAULT NULL , CHANGE `plugin_include` `pluginid` INT( 11 ) DEFAULT NULL
SQL = 
ALTER TABLE `#__comprofiler_tabs` CHANGE `plugin` `pluginclass` VARCHAR( 255 ) DEFAULT NULL , 
 CHANGE `plugin_include` `pluginid` INT( 11 ) DEFAULT NULL 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD `params` MEDIUMTEXT AFTER `fields` ;
SQL = 
ALTER TABLE `#__comprofiler_tabs` ADD `params` MEDIUMTEXT AFTER `fields` ;

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` ADD `pluginid` INT( 11 ) , ADD `params` MEDIUMTEXT;
SQL = 
ALTER TABLE `#__comprofiler_fields` ADD `pluginid` INT( 11 ) , 
 ADD `params` MEDIUMTEXT; 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=1 WHERE pluginclass='getContactTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET pluginid=1 WHERE pluginclass='getContactTab' 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=1 WHERE pluginclass='getConnectionTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET pluginid=1 WHERE pluginclass='getConnectionTab' 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=3 WHERE pluginclass='getAuthorTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET pluginid=3 WHERE pluginclass='getAuthorTab' 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=4 WHERE pluginclass='getForumTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET pluginid=4 WHERE pluginclass='getForumTab' 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=5 WHERE pluginclass='getBlogTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET pluginid=5 WHERE pluginclass='getBlogTab' 

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=6 WHERE pluginclass='getNewslettersTab'
SQL = 
UPDATE `#__comprofiler_tabs` SET pluginid=6 WHERE pluginclass='getNewslettersTab' 

1.0 RC 1 to 1.0 RC 2 part 2 Upgrade Applied Successfully.
1.0 RC 1 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD `position` VARCHAR( 255 ) DEFAULT '' NOT NULL, ADD `displaytype` VARCHAR( 255 ) DEFAULT '' NOT NULL AFTER `sys`
SQL = 
ALTER TABLE `#__comprofiler_tabs`
 ADD `position` VARCHAR( 255 ) DEFAULT '' NOT NULL,
 ADD `displaytype` VARCHAR( 255 ) DEFAULT '' NOT NULL AFTER `sys`

1.0 RC 1 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET position='cb_tabmain', displaytype='tab'
SQL = 
UPDATE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=INSERT INTO `jjint_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 `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET pluginid=2 WHERE pluginclass='getConnectionTab'
SQL = 
UPDATE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_members` ADD `reason` MEDIUMTEXT default NULL AFTER `membersince`
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_tabs` SET `pluginclass`=NULL, `pluginid`=NULL WHERE `pluginclass` != 'getContactTab' AND `fields` = 1
SQL = 
UPDATE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` CHANGE `default` `default` MEDIUMTEXT DEFAULT NULL;
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` CHANGE `tabid` `tabid` int(11) DEFAULT NULL;
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_users` SET usertype='Registered' WHERE usertype='';
SQL = 
UPDATE `#__users` SET usertype='Registered' WHERE usertype='';

1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_fields` SET `table`='jjint_users' WHERE name='email';
SQL = 
UPDATE `#__comprofiler_fields` SET `table`='#__users' WHERE name='email';

1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_fields` SET `table`='jjint_users' WHERE name='lastvisitDate';
SQL = 
UPDATE `#__comprofiler_fields` SET `table`='#__users' WHERE name='lastvisitDate';

1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler_fields` SET `table`='jjint_users' WHERE name='registerDate';
SQL = 
UPDATE `#__comprofiler_fields` SET `table`='#__users' WHERE name='registerDate';

1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE jjint_comprofiler ADD `registeripaddr` VARCHAR( 50 ) DEFAULT '' NOT NULL AFTER `lastupdatedate`;
SQL = 
ALTER TABLE #__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE jjint_comprofiler ADD `cbactivation` VARCHAR( 50 ) DEFAULT '' NOT NULL AFTER `registeripaddr`;
SQL = 
ALTER TABLE #__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE jjint_comprofiler ADD `message_last_sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `hits`;
SQL = 
ALTER TABLE #__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE jjint_comprofiler ADD `message_number_sent` INT( 11 ) DEFAULT 0 NOT NULL AFTER `message_last_sent`;
SQL = 
ALTER TABLE #__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_field_values` ADD INDEX fieldid_ordering (`fieldid`, `ordering` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` ADD INDEX `tabid_pub_prof_order` ( `tabid` , `published` , `profile` , `ordering` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` ADD INDEX `readonly_published_tabid` ( `readonly` , `published` , `tabid` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_fields` ADD INDEX `registration_published_order` ( `registration` , `published` , `ordering` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_plugin` ADD INDEX `type_pub_order` ( `type` , `published` , `ordering` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD INDEX `enabled_position_ordering` ( `enabled` , `position` , `ordering` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_lists` ADD INDEX `pub_ordering` ( `published` , `ordering` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_lists` ADD INDEX `default_published` ( `default` , `published` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_userreports` ADD INDEX `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_userreports` ADD INDEX `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_views` ADD INDEX `lastview` ( `lastview` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_views` ADD INDEX `profile_id_lastview` (`profile_id`,`lastview`);
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=UPDATE `jjint_comprofiler` SET `user_id`=`id` WHERE 1>0;
SQL = 
UPDATE `#__comprofiler` SET `user_id`=`id` WHERE 1>0;

1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD UNIQUE KEY user_id (`user_id`);
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD INDEX `apprconfbanid` ( `approved` , `confirmed` , `banned` , `id` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD INDEX `avatappr_apr_conf_ban_avatar` ( `avatarapproved` , `approved` , `confirmed` , `banned` , `avatar` );
SQL = 
ALTER TABLE `#__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 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD INDEX `lastupdatedate` ( `lastupdatedate` );
SQL = 
ALTER TABLE `#__comprofiler` ADD INDEX `lastupdatedate` ( `lastupdatedate` );

1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 Upgrade Applied Successfully.
1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_plugin` ADD `backend_menu` VARCHAR(255) NOT NULL DEFAULT '' AFTER `folder`;
SQL = 
ALTER TABLE `#__comprofiler_plugin` ADD `backend_menu` VARCHAR(255) NOT NULL DEFAULT '' AFTER `folder`;

1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD `ordering_register` int(11) NOT NULL DEFAULT 10 AFTER `ordering`;
SQL = 
ALTER TABLE `#__comprofiler_tabs` ADD `ordering_register` int(11) NOT NULL DEFAULT 10 AFTER `ordering`;

1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD `useraccessgroupid` int(9) DEFAULT -2 NOT NULL AFTER `position`;
SQL = 
ALTER TABLE `#__comprofiler_tabs` ADD `useraccessgroupid` int(9) DEFAULT -2 NOT NULL AFTER `position`;

1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_tabs` ADD INDEX `orderreg_enabled_pos_order` ( `enabled` , `ordering_register` , `position` , `ordering` );
SQL = 
ALTER TABLE `#__comprofiler_tabs` ADD INDEX `orderreg_enabled_pos_order` ( `enabled` , `ordering_register` , `position` , `ordering` );

1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD `unbannedby` int(11) default NULL AFTER `bannedby`;
SQL = 
ALTER TABLE `#__comprofiler` ADD `unbannedby` int(11) default NULL AFTER `bannedby`;

1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler` ADD `unbanneddate` datetime default NULL AFTER `banneddate`;
SQL = 
ALTER TABLE `#__comprofiler` ADD `unbanneddate` datetime default NULL AFTER `banneddate`;

1.0.2 to 1.1 failed! SQL error:DB function failed with error number 42000 
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=ALTER TABLE `jjint_comprofiler_field_values` CHANGE `fieldtitle` `fieldtitle` VARCHAR(255) NOT NULL DEFAULT '';
SQL = 
ALTER TABLE `#__comprofiler_field_values` CHANGE `fieldtitle` `fieldtitle` VARCHAR(255) NOT NULL DEFAULT '';

1.0.2 to 1.1 Upgrade Applied Successfully.
Database fixing errors:
Tabs selection query error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=SELECT * FROM `jjint_comprofiler_tabs` ORDER BY `tabid` 
Database fixing errors:
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_comprofiler` ( `id` int(11) NOT NULL DEFAULT 0, `user_id` int(11) NOT NULL DEFAULT 0, `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL, `hits` int(11) NOT NULL DEFAULT 0, `message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `message_number_sent` int(11) NOT NULL DEFAULT 0, `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL 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', `registeripaddr` varchar(50) NOT NULL DEFAULT '', `cbactivation` varchar(50) NOT NULL DEFAULT '', `banned` tinyint(4) NOT NULL DEFAULT 0, `banneddate` datetime DEFAULT NULL, `unbanneddate` datetime DEFAULT NULL, `bannedby` int(11) DEFAULT NULL, `unbannedby` int(11) DEFAULT NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `apprconfbanid` (`approved`, `confirmed`, `banned`, `id`), KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`, `approved`, `confirmed`, `banned`, `avatar`), KEY `lastupdatedate` (`lastupdatedate`) )ENGINE=MyISAM 
CREATE TABLE `#__comprofiler` ( `id` int(11) NOT NULL DEFAULT 0, `user_id` int(11) NOT NULL DEFAULT 0, `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL, `hits` int(11) NOT NULL DEFAULT 0, `message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `message_number_sent` int(11) NOT NULL DEFAULT 0, `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL 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', `registeripaddr` varchar(50) NOT NULL DEFAULT '', `cbactivation` varchar(50) NOT NULL DEFAULT '', `banned` tinyint(4) NOT NULL DEFAULT 0, `banneddate` datetime DEFAULT NULL, `unbanneddate` datetime DEFAULT NULL, `bannedby` int(11) DEFAULT NULL, `unbannedby` int(11) DEFAULT NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `apprconfbanid` (`approved`, `confirmed`, `banned`, `id`), KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`, `approved`, `confirmed`, `banned`, `avatar`), KEY `lastupdatedate` (`lastupdatedate`) )ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_field_values failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_comprofiler_field_values` ( `fieldvalueid` int(11) NOT NULL auto_increment, `fieldid` int(11) NOT NULL DEFAULT 0, `fieldtitle` varchar(255) NOT NULL DEFAULT '', `ordering` int(11) NOT NULL DEFAULT 0, `sys` tinyint(4) NOT NULL DEFAULT 0, PRIMARY KEY (`fieldvalueid`), KEY `fieldid_ordering` (`fieldid`, `ordering`), KEY `fieldtitle_id` (`fieldtitle`, `fieldid`) )AUTO_INCREMENT=16, ENGINE=MyISAM 
CREATE TABLE `#__comprofiler_field_values` ( `fieldvalueid` int(11) NOT NULL auto_increment, `fieldid` int(11) NOT NULL DEFAULT 0, `fieldtitle` varchar(255) NOT NULL DEFAULT '', `ordering` int(11) NOT NULL DEFAULT 0, `sys` tinyint(4) NOT NULL DEFAULT 0, PRIMARY KEY (`fieldvalueid`), KEY `fieldid_ordering` (`fieldid`, `ordering`), KEY `fieldtitle_id` (`fieldtitle`, `fieldid`) )AUTO_INCREMENT=16, ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_fields failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL DEFAULT '', `tablecolumns` text NOT NULL, `table` varchar(50) NOT NULL DEFAULT 'jjint_comprofiler', `title` varchar(255) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `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, `published` tinyint(1) NOT NULL DEFAULT 1, `registration` tinyint(1) NOT NULL DEFAULT 0, `profile` tinyint(1) NOT NULL DEFAULT 1, `displaytitle` tinyint(1) NOT NULL DEFAULT 1, `readonly` tinyint(1) NOT NULL DEFAULT 0, `searchable` tinyint(1) NOT NULL DEFAULT 0, `calculated` tinyint(1) NOT NULL DEFAULT 0, `sys` tinyint(4) NOT NULL DEFAULT 0, `pluginid` int(11) NOT NULL DEFAULT 0, `params` mediumtext, PRIMARY KEY (`fieldid`), KEY `tabid_pub_prof_order` (`tabid`, `published`, `profile`, `ordering`), KEY `readonly_published_tabid` (`readonly`, `published`, `tabid`), KEY `registration_published_order` (`registration`, `published`, `ordering`) )AUTO_INCREMENT=54, ENGINE=MyISAM 
CREATE TABLE `#__comprofiler_fields` ( `fieldid` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL DEFAULT '', `tablecolumns` text NOT NULL, `table` varchar(50) NOT NULL DEFAULT '#__comprofiler', `title` varchar(255) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `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, `published` tinyint(1) NOT NULL DEFAULT 1, `registration` tinyint(1) NOT NULL DEFAULT 0, `profile` tinyint(1) NOT NULL DEFAULT 1, `displaytitle` tinyint(1) NOT NULL DEFAULT 1, `readonly` tinyint(1) NOT NULL DEFAULT 0, `searchable` tinyint(1) NOT NULL DEFAULT 0, `calculated` tinyint(1) NOT NULL DEFAULT 0, `sys` tinyint(4) NOT NULL DEFAULT 0, `pluginid` int(11) NOT NULL DEFAULT 0, `params` mediumtext, PRIMARY KEY (`fieldid`), KEY `tabid_pub_prof_order` (`tabid`, `published`, `profile`, `ordering`), KEY `readonly_published_tabid` (`readonly`, `published`, `tabid`), KEY `registration_published_order` (`registration`, `published`, `ordering`) )AUTO_INCREMENT=54, ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_lists failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_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) NOT NULL DEFAULT 0, `usergroupids` varchar(255) DEFAULT NULL, `useraccessgroupid` int(9) NOT NULL DEFAULT 18, `sortfields` varchar(255) DEFAULT NULL, `filterfields` mediumtext, `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, `params` mediumtext, PRIMARY KEY (`listid`), KEY `pub_ordering` (`published`, `ordering`), KEY `default_published` (`default`, `published`) )AUTO_INCREMENT=4, ENGINE=MyISAM 
CREATE TABLE `#__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) NOT NULL DEFAULT 0, `usergroupids` varchar(255) DEFAULT NULL, `useraccessgroupid` int(9) NOT NULL DEFAULT 18, `sortfields` varchar(255) DEFAULT NULL, `filterfields` mediumtext, `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, `params` mediumtext, PRIMARY KEY (`listid`), KEY `pub_ordering` (`published`, `ordering`), KEY `default_published` (`default`, `published`) )AUTO_INCREMENT=4, ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_members failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_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', `reason` mediumtext, `description` varchar(255) DEFAULT NULL, `type` mediumtext, PRIMARY KEY (`referenceid`, `memberid`), KEY `pamr` (`pending`, `accepted`, `memberid`, `referenceid`), KEY `aprm` (`accepted`, `pending`, `referenceid`, `memberid`), KEY `membrefid` (`memberid`, `referenceid`) )ENGINE=MyISAM 
CREATE TABLE `#__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', `reason` mediumtext, `description` varchar(255) DEFAULT NULL, `type` mediumtext, PRIMARY KEY (`referenceid`, `memberid`), KEY `pamr` (`pending`, `accepted`, `memberid`, `referenceid`), KEY `aprm` (`accepted`, `pending`, `referenceid`, `memberid`), KEY `membrefid` (`memberid`, `referenceid`) )ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_plugin failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_comprofiler_plugin` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL DEFAULT '', `element` varchar(100) NOT NULL DEFAULT '', `type` varchar(100) DEFAULT '', `folder` varchar(100) DEFAULT '', `backend_menu` varchar(255) NOT 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`), KEY `type_pub_order` (`type`, `published`, `ordering`) )AUTO_INCREMENT=500, ENGINE=MyISAM 
CREATE TABLE `#__comprofiler_plugin` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL DEFAULT '', `element` varchar(100) NOT NULL DEFAULT '', `type` varchar(100) DEFAULT '', `folder` varchar(100) DEFAULT '', `backend_menu` varchar(255) NOT 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`), KEY `type_pub_order` (`type`, `published`, `ordering`) )AUTO_INCREMENT=500, ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_tabs failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_comprofiler_tabs` ( `tabid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL DEFAULT '', `description` text, `ordering` int(11) NOT NULL DEFAULT 0, `ordering_register` int(11) NOT NULL DEFAULT 10, `width` varchar(10) NOT NULL DEFAULT '.5', `enabled` tinyint(1) NOT NULL DEFAULT 1, `pluginclass` varchar(255) DEFAULT NULL, `pluginid` int(11) DEFAULT NULL, `fields` tinyint(1) NOT NULL DEFAULT 1, `params` mediumtext, `sys` tinyint(4) NOT NULL DEFAULT 0, `displaytype` varchar(255) NOT NULL DEFAULT '', `position` varchar(255) NOT NULL DEFAULT '', `useraccessgroupid` int(9) NOT NULL DEFAULT -2, PRIMARY KEY (`tabid`), KEY `enabled_position_ordering` (`enabled`, `position`, `ordering`), KEY `orderreg_enabled_pos_order` (`enabled`, `ordering_register`, `position`, `ordering`) )AUTO_INCREMENT=23, ENGINE=MyISAM 
CREATE TABLE `#__comprofiler_tabs` ( `tabid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL DEFAULT '', `description` text, `ordering` int(11) NOT NULL DEFAULT 0, `ordering_register` int(11) NOT NULL DEFAULT 10, `width` varchar(10) NOT NULL DEFAULT '.5', `enabled` tinyint(1) NOT NULL DEFAULT 1, `pluginclass` varchar(255) DEFAULT NULL, `pluginid` int(11) DEFAULT NULL, `fields` tinyint(1) NOT NULL DEFAULT 1, `params` mediumtext, `sys` tinyint(4) NOT NULL DEFAULT 0, `displaytype` varchar(255) NOT NULL DEFAULT '', `position` varchar(255) NOT NULL DEFAULT '', `useraccessgroupid` int(9) NOT NULL DEFAULT -2, PRIMARY KEY (`tabid`), KEY `enabled_position_ordering` (`enabled`, `position`, `ordering`), KEY `orderreg_enabled_pos_order` (`enabled`, `ordering_register`, `position`, `ordering`) )AUTO_INCREMENT=23, ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_userreports failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_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`), KEY `status_user_date` (`reportedstatus`, `reporteduser`, `reportedondate`), KEY `reportedbyuser_ondate` (`reportedbyuser`, `reportedondate`) )AUTO_INCREMENT=11, ENGINE=MyISAM 
CREATE TABLE `#__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`), KEY `status_user_date` (`reportedstatus`, `reporteduser`, `reportedondate`), KEY `reportedbyuser_ondate` (`reportedbyuser`, `reportedondate`) )AUTO_INCREMENT=11, ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_views failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_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`), KEY `lastview` (`lastview`), KEY `profile_id_lastview` (`profile_id`, `lastview`, `viewer_id`) )ENGINE=MyISAM 
CREATE TABLE `#__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`), KEY `lastview` (`lastview`), KEY `profile_id_lastview` (`profile_id`, `lastview`, `viewer_id`) )ENGINE=MyISAM 
CBSQLupgrader::createTableof Table #__comprofiler_sessions failed with SQL error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '`'.SQL=CREATE TABLE `jjint_comprofiler_sessions` ( `username` varchar(50) NOT NULL DEFAULT '', `userid` int(11) unsigned NOT NULL DEFAULT 0, `ui` tinyint(4) NOT NULL DEFAULT 0, `incoming_ip` varchar(39) NOT NULL DEFAULT '', `client_ip` varchar(39) NOT NULL DEFAULT '', `session_id` varchar(33) NOT NULL DEFAULT '', `session_data` mediumtext NOT NULL, `expiry_time` int(14) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`session_id`), KEY `expiry_time` (`expiry_time`), KEY `userid` (`userid`) )ENGINE=MyISAM 
CREATE TABLE `#__comprofiler_sessions` ( `username` varchar(50) NOT NULL DEFAULT '', `userid` int(11) unsigned NOT NULL DEFAULT 0, `ui` tinyint(4) NOT NULL DEFAULT 0, `incoming_ip` varchar(39) NOT NULL DEFAULT '', `client_ip` varchar(39) NOT NULL DEFAULT '', `session_id` varchar(33) NOT NULL DEFAULT '', `session_data` mediumtext NOT NULL, `expiry_time` int(14) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`session_id`), KEY `expiry_time` (`expiry_time`), KEY `userid` (`userid`) )ENGINE=MyISAM 
Core CB database upgrades done. If all lines above are in green, database upgrade completed successfully. Otherwise, please report exact errors and queries to forum, and try checking database again in components : community builder : tools : check database.

C:\JJ Intranet/images/comprofiler/ Successfully added.
C:\JJ Intranet/images/comprofiler/gallery/ Successfully added.


Second and last installation step of Community Builder Component (comprofiler) done successfully.
Installation finished. Important: Please read README.TXT and installation manual for further settings. 

We also have a PDF installation guide as well as a complete documentation available on www.joomlapolis.com which will help you making the most out of your Community Builder installation, while supporting this project, as well as plugins and templates.