CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Export to CSV Fatal Error [SOLVED]
Pages: [1]

Author Topic: Export to CSV Fatal Error [SOLVED]  (Read 466 times)

Pamela

  • I’m new here
  • *
  • Posts: 23
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: WordPress 4.1
  • MySQL version: 5.5.40
  • PHP version: 5.3.27
Export to CSV Fatal Error [SOLVED]
October 14, 2014, 06:13:18 pm
When I try exporting all ~7500 of my contacts (Search -> Find Contacts) to CSV, after the page loading momentarily, I get this error:

Code: [Select]
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 71 bytes) in /home/pamela/public_html/civicrm/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php on line 559
It seems this is being caused by the large amount of contacts I'm trying to export, right? If so, is there a way to somehow get around this without having to increase the allowed memory? Or should I increase my memory size, and if so is there an optimal memory size for CiviCRM?

Thanks.
« Last Edit: December 19, 2014, 04:27:44 am by Pamela »

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Export to CSV Fatal Error
October 14, 2014, 11:46:06 pm
A way around might be to spilt your contacts into a couple of groups and export each group?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Export to CSV Fatal Error
October 15, 2014, 02:16:08 am
Quote
is there an optimal memory size for CiviCRM?

That totally depends on things like the total memory available on your server, and the size of your database, how much traffic you get on your CiviCRM installation and the associated website (if any) so not really possible to give a one size fits all answer.

Quote
should I increase my memory size

Bearing in mind the above, you could experiment with doubling to 256mb.  Or you could chat with your server administrator to get their thoughts.Or people here might be able to help if you give a few more details.

Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

Pamela

  • I’m new here
  • *
  • Posts: 23
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: WordPress 4.1
  • MySQL version: 5.5.40
  • PHP version: 5.3.27
Re: Export to CSV Fatal Error
October 15, 2014, 02:42:29 am
Thanks all!

I guess I will try copying the installation locally to see exactly what kind of memory limits are required.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Export to CSV Fatal Error [SOLVED]

This forum was archived on 2017-11-26.