TOPIC: Community Builder Synch

ameridane, I too HAD no sync between CB and DTRegister, despite setting the profile sync in the Config, despite the settings in individual events, and many reads of the forum hunting for a solution. The sync worked between DTR 2.69, but not after the upgrade to 2.7xx. I kept thinking the next upgrade would correct the issue -- but the problem remained. Here's how I finally got it to work.

My trial and error attempts at changing settings in CB and DTR started producing an error message that said E_NOLOGIN_ACCESS whenever I tried a "dummy registrant". I turned on the "Debug" feature in Joomla and I received a detailed message that said the php collation field in the php ACL tables did not match (three tables were involved). One had utf8_general_ci, while the other two had utf8_unicode_ci. Using phpMyAdmin I changed the two "unicodes" to utf8_general_ci so all three matched. My very next attempt to make a "dummy registration" for a DTR event worked perfectly! It sync'd all the fields I had to CB user list and to the Joomla user list (basic fields).

The three involved user tables in phpMyAdmin were:

jos_core_acl_aro
jos_core_acl_aro_groups
jos_core_acl_groups_aro_map

I don't know if this will help you, but it is a summary of my problem and how I corrected it.

Dennis . . .

Dennis,

thx for a very insightful post w/ an actual suggestion for something that can be tried to remedy the situation. I'm in the middle of upgrading the database on the site anyway, so the timing is perfect -- there's definitely something funky w/ both utf-8 and latin1 collation across table (notably, all the DT tables are latin1 in my install, while the core jos_ tables are all utf-. I'll post back here w/ an update when I see if this is the solution to my issue.

Update: Nope, that wasn't it, either. Back to waiting for tech support to take a look. I guess my setup is uniquely screwed up -- but it's not clear to me how, since I've followed the instructions for CB Sync as it's described, and it used to work until the last updates of 2.71x.

Hi ameridane,

Just for additional information (not advising you to change anything).

After reading your post about the DTR tables having Latin1 collation I looked at the collations in all my tables and everything was utf8 (some utf8_general_ci and others utf8_unicode_ci) including the DTR tables. NONE of the tables had Latin1.

Dennis . . .