Skip to Content Skip to Menu

How to auto synchronize core joomla users to CB users

8 years 4 months ago #281760 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 or Create an account to join the conversation.

  • mjl1817
  • mjl1817
  • OFFLINE
  • Posts: 42
  • Thanks: 6
  • Karma: 1
8 years 3 months ago #281815 by mjl1817
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
Code:
// 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
Code:
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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum