Tools Section

I went into Community Builder>Tools>Sync Users and got this message:

Removing 178 entries from Community Builder missing in users Table.

User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found. User not found.

Joomla User Table and Joomla Community Builder User Table now in sync!

AND THEN Community Builder>Tools>Check Users Database and got this:


Checking Users Database:

Warning: 178 entries in Community Builder comprofiler table without corresponding user table rows.

Following comprofiler id: 19, 22, 25, 26, 29, 30, 31, 32, 34, 36, 37, 38, 39, 41, 42, 44, 45, 47, 48, 49, 53, 54, 55, 56, 57, 61, 62, 65, 66, 67, 68, 69, 71, 73, 75, 76, 77, 79, 80, 81, 84, 85, 87, 94, 95, 96, 101, 102, 103, 106, 110, 111, 113, 115, 116, 117, 120, 121, 124, 125, 127, 129, 131, 132, 133, 134, 135, 137, 138, 139, 140, 142, 147, 149, 150, 153, 154, 155, 156, 158, 160, 166, 168, 170, 172, 174, 175, 180, 183, 184, 186, 187, 188, 189, 190, 192, 199, 200, 204, 207, 211, 214, 217, 218, 222, 230, 231, 233, 235, 236, 237, 238, 240, 243, 244, 245, 250, 251, 252, 253, 254, 259, 265, 272, 279, 283, 299, 301, 303, 305, 317, 319, 320, 323, 326, 329, 335, 341, 342, 344, 345, 346, 347, 349, 350, 351, 353, 354, 355, 356, 357, 358, 360, 362, 363, 364, 365, 366, 367, 374, 376, 377, 378, 379, 380, 382, 383, 384, 385, 386, 388, 389, 391, 393, 394, 398, 406, 407 are missing in user table

This one can be fixed using menu Components / Community Builder / tools and then click "Synchronize users".

All users table rows have links to comprofiler table.

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.

All users table rows have ACL entries in user_usergroup_map table.

All ACL user_usergroup_map table rows have corresponding entries in users table.

CB version?

The new one 2.0

Sounds like your database was out of sync. You had users that existed in CB, but not in Joomla. Then had users existing in Joomla, but not in CB. My guess is you're not using CB registration or you've some other 3rd party registration process going on. You should've got this same issue with CB 1.x if tools were ran. Please be sure you're using latest nightly found below as we've fixed some known issues already.

www.joomlapolis.com/downloads/doc_details/640-community-builder-nightly-build

OK I have that nightly installed and it did not clear up the issue----

when I check the user database it still says--

Warning: 178 entries in Community Builder comprofiler table without corresponding user table rows.
This one can be fixed using menu Components / Community Builder / tools and then click "Synchronize users".

When I go in to sync users it still says Removing 178 entries from Community Builder missing in users Table.

I used this several times before I did the upgrade and it always synced...I am not using any third party registration and am using the community builder registration and have the joomla registration turned off

Ok, was able to confirm your issue. This happens when users exist in CB, but don't in Joomla. In this case the user sync tool would delete those CB users. However, there's a check going on to see if they exist in Joomla and if they don't it'll throw an error and not be able to delete them. We're fixing for next release.