CB Tools: Check Core CB database: Results
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 comprofiler table rows have links to user table.

All users table rows have links to comprofiler table.

All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table, but comprofiler_fields table is not yet upgraded to CB 1.2 table structure. You can do this by clicking on the upgrade link below.

users table has no zero id row.

comprofiler table has no zero id row.

All rows in comprofiler table have user_id columns identical to id columns.

Checking Community Builder folders:

Avatars and thumbnails folder is Writeable.
Warning: 7 entries in the users table without corresponding core_acl_aro table rows.

user id: 9543, 9544, 9545, 9546, 9547, 9548, 9549 are missing in core_acl_aro table

This one can be fixed in SQL using a tool like phpMyAdmin.

Warning: 81 entries in the core_acl_aro table without corresponding users table rows.

Following entries of core_acl_aro table are missing in users table: user id=66 (aro_id=14), user id=222 (aro_id=170), user id=225 (aro_id=173), user id=237 (aro_id=185), user id=238 (aro_id=186), user id=239 (aro_id=187), user id=240 (aro_id=188), user id=241 (aro_id=189), user id=242 (aro_id=190), user id=243 (aro_id=191), user id=244 (aro_id=192), user id=245 (aro_id=193), user id=246 (aro_id=194), user id=247 (aro_id=195), user id=248 (aro_id=196), user id=249 (aro_id=197), user id=250 (aro_id=198), user id=283 (aro_id=231), user id=303 (aro_id=251), user id=351 (aro_id=299), user id=780 (aro_id=728), user id=816 (aro_id=764), user id=845 (aro_id=793), user id=1011 (aro_id=959), user id=1199 (aro_id=1147), user id=1236 (aro_id=1184), user id=1301 (aro_id=1249), user id=1510 (aro_id=1458), user id=1587 (aro_id=1535), user id=1794 (aro_id=1742), user id=1859 (aro_id=1807), user id=1896 (aro_id=1844), user id=2006 (aro_id=1954), user id=2082 (aro_id=2030), user id=2100 (aro_id=2048), user id=2183 (aro_id=2131), user id=2245 (aro_id=2193), user id=2332 (aro_id=2280), user id=2373 (aro_id=2321), user id=2379 (aro_id=2327), user id=2450 (aro_id=2398), user id=2611 (aro_id=2559), user id=2728 (aro_id=2676), user id=2729 (aro_id=2677), user id=2860 (aro_id=2808), user id=2861 (aro_id=2809), user id=2862 (aro_id=2810), user id=2936 (aro_id=2884), user id=2962 (aro_id=2910), user id=2963 (aro_id=2911), user id=3029 (aro_id=2977), user id=3055 (aro_id=3003), user id=3056 (aro_id=3004), user id=3145 (aro_id=3093), user id=3224 (aro_id=3172), user id=3456 (aro_id=3404), user id=3667 (aro_id=3615), user id=3885 (aro_id=3833), user id=4074 (aro_id=4022), user id=4158 (aro_id=4106), user id=4352 (aro_id=4300), user id=4446 (aro_id=4394), user id=4472 (aro_id=4420), user id=4582 (aro_id=4530), user id=4583 (aro_id=4531), user id=4584 (aro_id=4532), user id=4587 (aro_id=4535), user id=4589 (aro_id=4537), user id=4591 (aro_id=4539), user id=4883 (aro_id=4831), user id=4891 (aro_id=4839), user id=4913 (aro_id=4861), user id=4994 (aro_id=4942), user id=5004 (aro_id=4952), user id=5071 (aro_id=5019), user id=5212 (aro_id=5160), user id=5300 (aro_id=5248), user id=5321 (aro_id=5269), user id=5911 (aro_id=5859), user id=7775 (aro_id=7723), user id=7831 (aro_id=7779).

This one can be fixed in SQL using a tool like phpMyAdmin.

All core_acl_aro table rows have ACL entries in core_acl_groups_aro_map table.

All core_acl_aro table rows have ACL entries in core_acl_groups_aro_map table.

Core CB Database structure differences:
Table #__comprofiler Column avatarapproved NULL attribute is YES instead of NO
Table #__comprofiler_field_values Index fieldtitle_id does not exist
Table #__comprofiler_fields Column tablecolumns does not exist
Table #__comprofiler_fields Column displaytitle does not exist
Table #__comprofiler_fields Column searchable does not exist
Table #__comprofiler_fields Column pluginid NULL attribute is YES instead of NO
Table #__comprofiler_fields Rows fieldid = 41 : Field tablecolumns = "" instead of 'name', Field tabid = "" instead of 11, Field ordering = "" instead of -51, Field displaytitle = "" instead of 1, Field searchable = "" instead of 1, Field pluginid = "" instead of 1, Field description = instead of '_UE_REGWARN_NAME', Field required = 0 instead of 1, Field registration = 0 instead of 1, Field profile = 1 instead of 0
Table #__comprofiler_fields Rows fieldid = 26 : Field name = NA instead of 'onlinestatus', Field tablecolumns = "" instead of '', Field tabid = "" instead of 21, Field ordering = "" instead of -21, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1
Table #__comprofiler_fields Rows fieldid = 25 do not exist
Table #__comprofiler_fields Rows fieldid = 27 : Field tablecolumns = "" instead of 'lastvisitDate', Field tabid = "" instead of 21, Field ordering = "" instead of -19, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field readonly = 0 instead of 1, Field params = "" instead of 'field_display_by=2'
Table #__comprofiler_fields Rows fieldid = 28 : Field tablecolumns = "" instead of 'registerDate', Field tabid = "" instead of 21, Field ordering = "" instead of -20, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field readonly = 0 instead of 1, Field params = "" instead of 'field_display_by=2'
Table #__comprofiler_fields Rows fieldid = 29 : Field tablecolumns = "" instead of 'avatar,avatarapproved', Field tabid = "" instead of 20, Field displaytitle = "" instead of 0, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field profile = 1 instead of 1
Table #__comprofiler_fields Rows fieldid = 42 : Field tablecolumns = "" instead of 'username', Field tabid = "" instead of 11, Field ordering = "" instead of -46, Field displaytitle = "" instead of 1, Field searchable = "" instead of 1, Field pluginid = "" instead of 1, Field description = instead of '_UE_VALID_UNAME', Field required = 0 instead of 1, Field registration = 0 instead of 1, Field profile = 1 instead of 0
Table #__comprofiler_fields Rows fieldid = 45 : Field name = NA instead of 'formatname', Field tablecolumns = "" instead of '', Field tabid = "" instead of 11, Field ordering = "" instead of -52, Field displaytitle = "" instead of 0, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field readonly = 0 instead of 1
Table #__comprofiler_fields Rows fieldid = 46 : Field tablecolumns = "" instead of 'firstname', Field tabid = "" instead of 11, Field ordering = "" instead of -50, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field description = instead of '_UE_REGWARN_FNAME', Field required = 0 instead of 1, Field registration = 0 instead of 1, Field profile = 1 instead of 0
Table #__comprofiler_fields Rows fieldid = 47 : Field tablecolumns = "" instead of 'middlename', Field tabid = "" instead of 11, Field ordering = "" instead of -49, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field description = instead of '_UE_REGWARN_MNAME', Field registration = 0 instead of 1, Field profile = 1 instead of 0
Table #__comprofiler_fields Rows fieldid = 48 : Field tablecolumns = "" instead of 'lastname', Field tabid = "" instead of 11, Field ordering = "" instead of -48, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field description = instead of '_UE_REGWARN_LNAME', Field required = 0 instead of 1, Field registration = 0 instead of 1, Field profile = 1 instead of 0
Table #__comprofiler_fields Rows fieldid = 49 : Field tablecolumns = "" instead of 'lastupdatedate', Field tabid = "" instead of 21, Field ordering = "" instead of -18, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field readonly = 0 instead of 1, Field params = "" instead of 'field_display_by=2'
Table #__comprofiler_fields Rows fieldid = 50 : Field tablecolumns = "" instead of 'email', Field tabid = "" instead of 11, Field ordering = "" instead of -47, Field displaytitle = "" instead of 1, Field searchable = "" instead of 0, Field pluginid = "" instead of 1, Field description = instead of '_UE_REGWARN_MAIL', Field required = 0 instead of 1, Field registration = 0 instead of 1, Field profile = 1 instead of 0
Table #__comprofiler_fields Rows fieldid = 51 do not exist
Table #__comprofiler_fields Rows fieldid = 52 do not exist
Table #__comprofiler_fields Rows fieldid = 24 do not exist
Table #__comprofiler_fields Rows fieldid = 23 do not exist
Table #__comprofiler_fields Rows fieldid = 22 do not exist
Table #__comprofiler_fields Rows fieldid = 21 do not exist
Table #__comprofiler_lists Column params does not exist
Table #__comprofiler_plugin Rows id = 4 : Field name = Simpleboard Forum instead of 'Fireboard Forum'
Table #__comprofiler_plugin Rows id = 15 : Field name = PMS MyPMS and Pro instead of 'Private Message System'
Table #__comprofiler_tabs Rows tabid = 11 : Field pluginclass = "" instead of 'getContactTab', Field pluginid = "" instead of 1, Field sys = 0 instead of 2
Table #__comprofiler_tabs Rows tabid = 12 : Field pluginclass = "" instead of 'getAuthorTab', Field pluginid = "" instead of 3, Field sys = 0 instead of 1
Table #__comprofiler_tabs Rows tabid = 13 : Field pluginclass = "" instead of 'getForumTab', Field pluginid = "" instead of 4, Field sys = 0 instead of 1
Table #__comprofiler_tabs Rows tabid = 14 do not exist
Table #__comprofiler_tabs Rows tabid = 15 do not exist
Table #__comprofiler_tabs Rows tabid = 16 do not exist
Table #__comprofiler_tabs Rows tabid = 17 do not exist
Table #__comprofiler_tabs Rows tabid = 18 do not exist
Table #__comprofiler_tabs Rows tabid = 19 : Field pluginclass = "" instead of 'getPageTitleTab', Field pluginid = "" instead of 1, Field sys = 0 instead of 1
Table #__comprofiler_tabs Rows tabid = 20 : Field pluginclass = getConnectionTab instead of 'getPortraitTab', Field pluginid = 2 instead of 1, Field fields = 0 instead of 1
Table #__comprofiler_tabs Rows tabid = 21 : Field pluginclass = getNewslettersTab instead of 'getStatusTab', Field pluginid = 6 instead of 14, Field fields = 0 instead of 1
Table #__comprofiler_tabs Rows tabid = 22 : Field pluginclass = getMenuTab instead of 'getmypmsproTab', Field pluginid = 14 instead of 15
Table #__comprofiler_views Index profile_id_lastview Column viewer_id is missing in index
Table #__comprofiler_sessions does not exist
The Core CB database structure differences can be fixed (adjusted) by clicking here: Click here to Fix (adjust) all Core CB 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 database and is a new feature.

Click here to Show details
Table #__comprofiler Column id structure is up-to-date.
Table #__comprofiler Column user_id structure is up-to-date.
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 #__comprofiler Column hits structure is up-to-date.
Table #__comprofiler Column message_last_sent structure is up-to-date.
Table #__comprofiler Column message_number_sent structure is up-to-date.
Table #__comprofiler Column avatar structure is up-to-date.
Table #__comprofiler Column approved structure is up-to-date.
Table #__comprofiler Column confirmed structure is up-to-date.
Table #__comprofiler Column lastupdatedate structure is up-to-date.
Table #__comprofiler Column registeripaddr structure is up-to-date.
Table #__comprofiler Column cbactivation structure is up-to-date.
Table #__comprofiler Column banned structure is up-to-date.
Table #__comprofiler Column banneddate structure is up-to-date.
Table #__comprofiler Column unbanneddate structure is up-to-date.
Table #__comprofiler Column bannedby structure is up-to-date.
Table #__comprofiler Column unbannedby structure is up-to-date.
Table #__comprofiler Column bannedreason structure is up-to-date.
Table #__comprofiler Column acceptedterms structure is up-to-date.
Table #__comprofiler Index PRIMARY is up-to-date.
Table #__comprofiler Index user_id is up-to-date.
Table #__comprofiler Index apprconfbanid is up-to-date.
Table #__comprofiler Index avatappr_apr_conf_ban_avatar is up-to-date.
Table #__comprofiler Index lastupdatedate is up-to-date.
Table #__comprofiler_field_values Column fieldvalueid structure is up-to-date.
Table #__comprofiler_field_values Column fieldid structure is up-to-date.
Table #__comprofiler_field_values Column fieldtitle structure is up-to-date.
Table #__comprofiler_field_values Column ordering structure is up-to-date.
Table #__comprofiler_field_values Column sys structure is up-to-date.
Table #__comprofiler_field_values has no unneeded columns.
Table #__comprofiler_field_values Index PRIMARY is up-to-date.
Table #__comprofiler_field_values Index fieldid_ordering is up-to-date.
Table #__comprofiler_field_values has no unneeded indexes.
Table #__comprofiler_fields Column fieldid structure is up-to-date.
Table #__comprofiler_fields Column name structure is up-to-date.
Table #__comprofiler_fields Column table structure is up-to-date.
Table #__comprofiler_fields Column title structure is up-to-date.
Table #__comprofiler_fields Column description structure is up-to-date.
Table #__comprofiler_fields Column type structure is up-to-date.
Table #__comprofiler_fields Column maxlength structure is up-to-date.
Table #__comprofiler_fields Column size structure is up-to-date.
Table #__comprofiler_fields Column required structure is up-to-date.
Table #__comprofiler_fields Column tabid structure is up-to-date.
Table #__comprofiler_fields Column ordering structure is up-to-date.
Table #__comprofiler_fields Column cols structure is up-to-date.
Table #__comprofiler_fields Column rows structure is up-to-date.
Table #__comprofiler_fields Column value structure is up-to-date.
Table #__comprofiler_fields Column default structure is up-to-date.
Table #__comprofiler_fields Column published structure is up-to-date.
Table #__comprofiler_fields Column registration structure is up-to-date.
Table #__comprofiler_fields Column profile structure is up-to-date.
Table #__comprofiler_fields Column readonly structure is up-to-date.
Table #__comprofiler_fields Column calculated structure is up-to-date.
Table #__comprofiler_fields Column sys structure is up-to-date.
Table #__comprofiler_fields Column params structure is up-to-date.
Table #__comprofiler_fields has no unneeded columns.
Table #__comprofiler_fields Index PRIMARY is up-to-date.
Table #__comprofiler_fields Index tabid_pub_prof_order is up-to-date.
Table #__comprofiler_fields Index readonly_published_tabid is up-to-date.
Table #__comprofiler_fields Index registration_published_order is up-to-date.
Table #__comprofiler_fields has no unneeded indexes.
Table #__comprofiler_lists Column listid structure is up-to-date.
Table #__comprofiler_lists Column title structure is up-to-date.
Table #__comprofiler_lists Column description structure is up-to-date.
Table #__comprofiler_lists Column published structure is up-to-date.
Table #__comprofiler_lists Column default structure is up-to-date.
Table #__comprofiler_lists Column usergroupids structure is up-to-date.
Table #__comprofiler_lists Column useraccessgroupid structure is up-to-date.
Table #__comprofiler_lists Column sortfields structure is up-to-date.
Table #__comprofiler_lists Column filterfields structure is up-to-date.
Table #__comprofiler_lists Column ordering structure is up-to-date.
Table #__comprofiler_lists Column col1title structure is up-to-date.
Table #__comprofiler_lists Column col1enabled structure is up-to-date.
Table #__comprofiler_lists Column col1fields structure is up-to-date.
Table #__comprofiler_lists Column col2title structure is up-to-date.
Table #__comprofiler_lists Column col2enabled structure is up-to-date.
Table #__comprofiler_lists Column col1captions structure is up-to-date.
Table #__comprofiler_lists Column col2fields structure is up-to-date.
Table #__comprofiler_lists Column col2captions structure is up-to-date.
Table #__comprofiler_lists Column col3title structure is up-to-date.
Table #__comprofiler_lists Column col3enabled structure is up-to-date.
Table #__comprofiler_lists Column col3fields structure is up-to-date.
Table #__comprofiler_lists Column col3captions structure is up-to-date.
Table #__comprofiler_lists Column col4title structure is up-to-date.
Table #__comprofiler_lists Column col4enabled structure is up-to-date.
Table #__comprofiler_lists Column col4fields structure is up-to-date.
Table #__comprofiler_lists Column col4captions structure is up-to-date.
Table #__comprofiler_lists has no unneeded columns.
Table #__comprofiler_lists Index PRIMARY is up-to-date.
Table #__comprofiler_lists Index pub_ordering is up-to-date.
Table #__comprofiler_lists Index default_published is up-to-date.
Table #__comprofiler_lists has no unneeded indexes.
Table #__comprofiler_members Column referenceid structure is up-to-date.
Table #__comprofiler_members Column memberid structure is up-to-date.
Table #__comprofiler_members Column accepted structure is up-to-date.
Table #__comprofiler_members Column pending structure is up-to-date.
Table #__comprofiler_members Column membersince structure is up-to-date.
Table #__comprofiler_members Column reason structure is up-to-date.
Table #__comprofiler_members Column description structure is up-to-date.
Table #__comprofiler_members Column type structure is up-to-date.
Table #__comprofiler_members has no unneeded columns.
Table #__comprofiler_members Index PRIMARY is up-to-date.
Table #__comprofiler_members Index pamr is up-to-date.
Table #__comprofiler_members Index aprm is up-to-date.
Table #__comprofiler_members Index membrefid is up-to-date.
Table #__comprofiler_members has no unneeded indexes.
Table #__comprofiler_plugin Column id structure is up-to-date.
Table #__comprofiler_plugin Column name structure is up-to-date.
Table #__comprofiler_plugin Column element structure is up-to-date.
Table #__comprofiler_plugin Column type structure is up-to-date.
Table #__comprofiler_plugin Column folder structure is up-to-date.
Table #__comprofiler_plugin Column backend_menu structure is up-to-date.
Table #__comprofiler_plugin Column access structure is up-to-date.
Table #__comprofiler_plugin Column ordering structure is up-to-date.
Table #__comprofiler_plugin Column published structure is up-to-date.
Table #__comprofiler_plugin Column iscore structure is up-to-date.
Table #__comprofiler_plugin Column client_id structure is up-to-date.
Table #__comprofiler_plugin Column checked_out structure is up-to-date.
Table #__comprofiler_plugin Column checked_out_time structure is up-to-date.
Table #__comprofiler_plugin Column params structure is up-to-date.
Table #__comprofiler_plugin has no unneeded columns.
Table #__comprofiler_plugin Index PRIMARY is up-to-date.
Table #__comprofiler_plugin Index idx_folder is up-to-date.
Table #__comprofiler_plugin Index type_pub_order is up-to-date.
Table #__comprofiler_plugin has no unneeded indexes.
Table #__comprofiler_plugin Rows id = 1 are up-to-date.
Table #__comprofiler_plugin Rows id = 2 are up-to-date.
Table #__comprofiler_plugin Rows id = 3 are up-to-date.
Table #__comprofiler_plugin Rows id = 5 are up-to-date.
Table #__comprofiler_plugin Rows id = 6 are up-to-date.
Table #__comprofiler_plugin Rows id = 7 are up-to-date.
Table #__comprofiler_plugin Rows id = 8 are up-to-date.
Table #__comprofiler_plugin Rows id = 9 are up-to-date.
Table #__comprofiler_plugin Rows id = 10 are up-to-date.
Table #__comprofiler_plugin Rows id = 11 are up-to-date.
Table #__comprofiler_plugin Rows id = 12 are up-to-date.
Table #__comprofiler_plugin Rows id = 13 are up-to-date.
Table #__comprofiler_plugin Rows id = 14 are up-to-date.
Table #__comprofiler_tabs Column tabid structure is up-to-date.
Table #__comprofiler_tabs Column title structure is up-to-date.
Table #__comprofiler_tabs Column description structure is up-to-date.
Table #__comprofiler_tabs Column ordering structure is up-to-date.
Table #__comprofiler_tabs Column ordering_register structure is up-to-date.
Table #__comprofiler_tabs Column width structure is up-to-date.
Table #__comprofiler_tabs Column enabled structure is up-to-date.
Table #__comprofiler_tabs Column pluginclass structure is up-to-date.
Table #__comprofiler_tabs Column pluginid structure is up-to-date.
Table #__comprofiler_tabs Column fields structure is up-to-date.
Table #__comprofiler_tabs Column params structure is up-to-date.
Table #__comprofiler_tabs Column sys structure is up-to-date.
Table #__comprofiler_tabs Column displaytype structure is up-to-date.
Table #__comprofiler_tabs Column position structure is up-to-date.
Table #__comprofiler_tabs Column useraccessgroupid structure is up-to-date.
Table #__comprofiler_tabs has no unneeded columns.
Table #__comprofiler_tabs Index PRIMARY is up-to-date.
Table #__comprofiler_tabs Index enabled_position_ordering is up-to-date.
Table #__comprofiler_tabs Index orderreg_enabled_pos_order is up-to-date.
Table #__comprofiler_tabs has no unneeded indexes.
Table #__comprofiler_userreports Column reportid structure is up-to-date.
Table #__comprofiler_userreports Column reporteduser structure is up-to-date.
Table #__comprofiler_userreports Column reportedbyuser structure is up-to-date.
Table #__comprofiler_userreports Column reportedondate structure is up-to-date.
Table #__comprofiler_userreports Column reportexplaination structure is up-to-date.
Table #__comprofiler_userreports Column reportedstatus structure is up-to-date.
Table #__comprofiler_userreports has no unneeded columns.
Table #__comprofiler_userreports Index PRIMARY is up-to-date.
Table #__comprofiler_userreports Index status_user_date is up-to-date.
Table #__comprofiler_userreports Index reportedbyuser_ondate is up-to-date.
Table #__comprofiler_userreports has no unneeded indexes.
Table #__comprofiler_views Column viewer_id structure is up-to-date.
Table #__comprofiler_views Column profile_id structure is up-to-date.
Table #__comprofiler_views Column lastip structure is up-to-date.
Table #__comprofiler_views Column lastview structure is up-to-date.
Table #__comprofiler_views Column viewscount structure is up-to-date.
Table #__comprofiler_views Column vote structure is up-to-date.
Table #__comprofiler_views Column lastvote structure is up-to-date.
Table #__comprofiler_views has no unneeded columns.
Table #__comprofiler_views Index PRIMARY is up-to-date.
Table #__comprofiler_views Index lastview is up-to-date.
Table #__comprofiler_views has no unneeded indexes.
Core CB database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red.

Joomla! is Free Software released under the GNU/GPL License. 
Joomla! 1.0.15 Stable [ Daytime ] 22 February 2008 23:00 UTC 
Check for latest Version