This section describes normal upgrade process for those that are upgrading on a Joomla 1.5 site [This looks like my section.] ------------------------------------------------------------------- FOLLOWING APPLIES FOR UPGRADES FROM CB 1.2 releases on Joomla 1.5: SUMMARY OVERVIEW OF CB UPGRADE ON JOOMLA 1.5 ENVIRONMENT -------------------------------------------------------- 1) Install new CB component from your CB 1.2.2 distribution package. There is no need to previously unistall component - code will upgrade automatically. [com_comprofiler.zip] Installation Process: Administrator and frontend menus corrected. Automatic database upgrade to current version applied successfully. Click to Show details (there was a huge list of things, all were in green, showing they were all up to date. 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. 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. 2) Install new CB Login module from your CB 1.2.2 distribution package. [mod_cblogin.zip] Install Module Success Login module to be used with Community Builder instead of the Login module. 3) Install new CB Workflow module from your CB 1.2.2 distibution package.[mod_comprofilerModerator.zip] Install Module Success Displays Notifications of pending actions for the moderator and connections functionality of Community Builder. 4) Install new CB Online module from your CB 1.2.2 distribution package. [mod_comprofilerOnline.zip] Install Module Success Displays a list of users logged in with a link to their profile. 5) Run CB Tool checks on CB database. 6) Done! Once the CB expert update files have been uploaded, you should immediately visit the CB Tools backend (see chapter 9) and run all the CB Tools checks. Specifically, you should execute: • Check Community Builder Database This will identify any database upgrades that must take place and will prompt you to upgrade. Checking Community Builder Datbase: All Community Builder comprofiler_field_values table fieldid rows all match existing fields. All Community Builder comprofiler_field_values table rows link to correct fieldtype fields in comprofiler_field table. All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table. Checking Community Builder folders: Avatars and thumbnails folder is Writeable. All Core CB mandatory basics Database is up to date. Core CB mandatory basics database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red. All Core CB Database is up to date. Click here to Show details (Huge list, all in green, all up to date) Core CB database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red. • Check Community Builder User Fields Database This will identify any needed database upgrades related with your user fields and will prompt you to upgrade. CB fields data storage Database structure differences: Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist Table jos_comprofiler does not exist The CB fields data storage database structure differences can be fixed (adjusted) by clicking here: Click here to Fix (adjust) all CB fields data storage database differences listed above (you can also Click here to preview fixing (adjusting) queries in a dry-run), but in all cases you need to backup database first as this adjustment is changing the database structure to match the needed structure for the installed version. Click here to Show details Table #__comprofiler Column avatar structure is up-to-date. Table #__comprofiler Column avatarapproved structure is up-to-date. Table #__comprofiler Column hits structure is up-to-date. Table #__users Column registerDate structure is up-to-date. Table #__users Column lastvisitDate structure is up-to-date. Table #__comprofiler Column lastupdatedate structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column params exists but is not of strict type, so not checked. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column email exists but is not of strict type, so not checked. Table #__users Column password structure is up-to-date. Table #__comprofiler Column cb_streetaddress exists but is not of strict type, so not checked. Table #__comprofiler Column cb_postalcode exists but is not of strict type, so not checked. Table #__comprofiler Column cb_contactphone exists but is not of strict type, so not checked. Table #__comprofiler Column cb_mywebsite structure is up-to-date. Table #__comprofiler Column cb_twitter structure is up-to-date. CB fields data storage database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red. ...Hmmm...I have php 5.1.4...CB appears to create new fields in the table jos_comprofiler...I have that database file. I can see it, using PHP MyAdmin...think I did use Joomlapack to upgrade to Joomla 1.5.15...might have something to do with it (prefixes?)... Well, I'll try the "dry run" --- CB Tools: Fix CB fields data storage database: Dry-run: Results CB fields data storage Database adjustments dryrun is successful, see results below Click here to Show details Table #__comprofiler Column avatar structure is up-to-date. Table #__comprofiler Column avatarapproved structure is up-to-date. Table #__comprofiler Column hits structure is up-to-date. Table #__users Column registerDate structure is up-to-date. Table #__users Column lastvisitDate structure is up-to-date. Table #__comprofiler Column lastupdatedate structure is up-to-date. Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_expirationdate` date DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_chartermember` tinyint(3) unsigned DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_membershiptype` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column params exists but is not of strict type, so not checked. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column username exists but is not of strict type, so not checked. Table #__users Column name exists but is not of strict type, so not checked. Table #__comprofiler Column firstname structure is up-to-date. Table #__comprofiler Column middlename structure is up-to-date. Table #__comprofiler Column lastname structure is up-to-date. Table #__users Column email exists but is not of strict type, so not checked. Table #__users Column password structure is up-to-date. Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_favoritecomposers` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table #__comprofiler Column cb_streetaddress exists but is not of strict type, so not checked. Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_recordingsilove` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_geographicalarea` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_mystyles` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_state` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_myinstrument` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_country` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_technologyiuse` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table #__comprofiler Column cb_postalcode exists but is not of strict type, so not checked. Table #__comprofiler Column cb_contactphone exists but is not of strict type, so not checked. Table #__comprofiler Column cb_mywebsite structure is up-to-date. Table #__comprofiler Column cb_twitter structure is up-to-date. Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_professionalaffiliations` varchar(255) DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_mtnacertification` tinyint(3) unsigned DEFAULT NULL ) ENGINE=MyISAM Table jos_comprofiler successfully created CREATE TABLE `jos_comprofiler` ( `cb_mybiography` mediumtext ) ENGINE=MyISAM Dry-run of CB fields data storage database adjustments done. None of the queries listed in details have been performed.