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 »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't export-get white screen of death
Pages: [1]

Author Topic: Can't export-get white screen of death  (Read 830 times)

bcarney

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
Can't export-get white screen of death
May 24, 2014, 07:17:52 am
I'm helping out a guy that is using CiviCRM/WordPress on an Amazon m3.large instance.  He needs to export his 60,000 Records to send to a mail vendor.  When I try to export his data, I continually get the "White screen of death" - nothing will export.  I've gone as far as editing his php.ini file and changing the memory_limit to 2048M and that didn't make a difference. How can I export his data other than doing a couple hundred records at a time? 

If it cannot be done in CiviCRM, does anyone have a SQL command that can be run in phpMyAdmin?

Thanks all in advance.

bcarney

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
Re: Can't export-get white screen of death
May 24, 2014, 07:36:46 am
Oh, I should note it's running on WordPress 3.9.1 and CiviCRM 4.4.0.  I'm doing a basic Find Contacts to select the 60,000 for export, and then selecting 'Export PRIMARY fields', everything else is left as default settings.

I've even edited civicrm.settings.php ini_set('memory_limit', '2048M') to no avail.  All I get is a white screen when attempting an export.

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Can't export-get white screen of death
May 24, 2014, 04:30:41 pm
It may not be memory that's giving you WSoD.

https://drupal.stackexchange.com/questions/7560/how-to-see-the-error-messages-when-i-get-the-white-screen-of-death may be helpful? In short - turn on display of error messages, OR use your webserver logs to identify the issue.
@xurizaemon ● www.fuzion.co.nz

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Can't export-get white screen of death
May 25, 2014, 08:02:01 am
Yes, always check the server logs for WSOD--could well be a CPU timeout.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

bcarney

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
Re: Can't export-get white screen of death
May 25, 2014, 09:47:26 am
Found the solution - I had to change the max_execution_time in php.ini to a crazy big number in order to let it run.  Any ideas on what would be a good value to set this to?  It's a server with a bunch go Wordpress sites on it so I'm a bit reluctant to jack it up too high...

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Can't export-get white screen of death
May 25, 2014, 09:54:09 am
This is a conundrum. You (apparently) need it high for exports but yet don't want it high because that can cause instability. Do you need to do exports all the time?

Regarding how high to set it, can you check the logs and see how long that export job did run? Or run it again and see?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Can't export-get white screen of death
May 26, 2014, 07:30:20 pm
You can conditionally set max_execution_time somewhere that only affects the exporter, so that piece of code is granted more time to do its job.
@xurizaemon ● www.fuzion.co.nz
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't export-get white screen of death

This forum was archived on 2017-11-26.