1. Forums
  3. Community Discussions
  5. Community Builder
  7. How to auto synchronize core joomla users to CB users

How to auto synchronize core joomla users to CB users

7 years 10 months ago #281760 by davidjosue007
How to auto synchronize core joomla users to CB users was created by davidjosue007
Unfortunately, for some reasons, I MUST use core joomla registration form for registration in my website. For this reason my users remaining out of community builder until I use synchronization tool.
Please , is there anyway to simply auto synchronize users.

Thans for your help

Community Builder 2.0.14
Joomla 3.5.1

Please Log in to join the conversation.

7 years 10 months ago #281815 by mjl1817
Replied by mjl1817 on topic How to auto synchronize core joomla users to CB users
The answer seems to be no.. I have been trying to make a cronjob to do this but have not had any success as of yet. The command you need to invoke is
// A hack to force Community Builder to syncUsers and set confirmed and approved to true
$sql_sync = "INSERT IGNORE INTO #__comprofiler(id,user_id) SELECT id,id FROM #__users";
$database->setQuery($sql_sync);
$database->query();
THAT IS JUST THE ONE LINE NOT THE ENTIRE CRONJOB

also been trying to make it work via an autoaction but so far with no sucess using the following
UPDATE `#__comprofiler` SET `approved`= '1' WHERE `user_id` = '[user_id]'
using autoaction but still no success

Anyine have any ideas?
I wish I knew, Then we would both know.

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Community Discussions
  5. Community Builder
  7. How to auto synchronize core joomla users to CB users
Time to create page: 0.224 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Community Discussions
  4. Community Builder
  5. How to auto synchronize core joomla users to CB users

Search

Login / Logout

User Menu