CiviCRM Community Forums (archive)

I have  a relatively small Joomla site. I am trying to add CiviCRM on a testing site, and everything went smooth until I tried to synchronize users to contacts. I have 2808 users.


Fatal error: Out of memory (allocated 14680064) (tried to allocate 76 bytes) in /path/to/web/root/public_html/administrator/components/com_civicrm/civicrm/CRM/Mailing/Event/BAO/Subscribe.php on line 47

Trying again yielded this result:

Fatal error: Out of memory (allocated 14680064) (tried to allocate 4864 bytes) in /path/to/web/root/public_html/administrator/components/com_civicrm/civicrm/CRM/Mailing/Event/BAO/Subscribe.php on line 61


After those errors, I noticed that 1108 contacts were created.

CiviCRM  2.1.4
Joomla 1.5.9
PHP 5.2.8
MySQL 5.0.67

I have increased the memory_limit to 128M using php.ini in the webroot and administration directories, to no avail. Any guidance would be greatly appreciated.

Thanks for replying. 

Subsequent runs yield no more contacts.

Your best bet would be:

1. Increase your php execution limit (to 3600 seconds or so)

2. Modify the query at: CRM/Core/BAO/CMSUser.php, line 75

        $sql   = "SELECT $id, $mail, $name FROM {$config->userFrameworkUsersTableName} where $mail != ''";

TO

        $sql   = "SELECT $id, $mail, $name FROM {$config->userFrameworkUsersTableName} where $mail != '' LIMIT OFFSET,COUNT";

and change OFFSET and COUNT on every run till u process all your contacts. You'll have to tweak these two numbers based on your machine speed etc. I would probably do 200 or so at a time

lobo

Multiple places

1. tweak the script at CMSUser.php to take the offset from the calling function. return a complete code when no more records left

2. make that call an ajax call that makes an http request with a new offset when the previous request completes. do this till no more records

i suspect item 2 will be the issue and figuring out how to fit that into the framework. take a look at some jQuery stuff and see if there is a helper method u can potentially use

lobo