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 Import (Moderator: Yashodha Chaku) »
  • Getting "Error 500: Internal Server Error" when trying to import
Pages: [1]

Author Topic: Getting "Error 500: Internal Server Error" when trying to import  (Read 4475 times)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Getting "Error 500: Internal Server Error" when trying to import
February 21, 2010, 07:22:51 am
I get a "Error 500: Internal Server Error" when I try to import more than 20 records from a CSV file. I have already turned on debugging and backtrace in the CiviCRM global settings.  

The failing file is attached.

I am using Joomla 1.5.11 and CiviCRM version 3.1.2
« Last Edit: February 21, 2010, 07:35:24 am by sgladstone »
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Getting "Error 500: Internal Server Error" when trying to import
February 21, 2010, 08:59:43 am

check the apache error logs for more detailed info on the 500 error

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Getting "Error 500: Internal Server Error" when trying to import
February 21, 2010, 10:28:46 am
The entries in the Apache error log are:

[Sun Feb 21 13:26:22 2010] [error] [client 76.214.206.81] FastCGI: comm with (dynamic) server "/hsphere/shared/php5/bin/php" aborted: (first read) idle timeout (30 sec), referer: http://uscj.myhostname.com/administrator/index2.php?option=com_civicrm&task=civicrm/import/contact&&_qf_Preview_display=true&qfKey=9fa57029542a9c5e0540a457a45d75e7

[Sun Feb 21 13:26:22 2010] [error] [client 76.214.206.81] FastCGI: incomplete headers (0 bytes) received from server "/hsphere/shared/php5/bin/php", referer: http://uscj.myhostname.com/administrator/index2.php?option=com_civicrm&task=civicrm/import/contact&&_qf_Preview_display=true&qfKey=9fa57029542a9c5e0540a457a45d75e7
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Getting "Error 500: Internal Server Error" when trying to import
March 18, 2010, 04:00:32 am
... FastCGI ...

I have configured my test server (aka laptop!) so that Apache invokes PHP via mod_fcgid rather than mod_php (which we use in production). And I'm getting 500 errors plus SSL timeout messages during imports (which we don't get ini production). I couldn't find anything on the web to describe how to configure mod_fcgid, so I'm in the dark.

One suggestion for sgladstone is to use mod_php rather than FastCGI. Another is to tune FastCGI (if you find resources. let me know!).

Ken

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Getting "Error 500: Internal Server Error" when trying to import
March 18, 2010, 09:52:27 am
I will give this a try and post my results.
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Getting "Error 500: Internal Server Error" when trying to import
March 18, 2010, 09:58:47 pm
I'm still learning, but I've managed to avoid timeouts with mod_fcgid via the following settings in /etc/apache2/mods-available/fcgid.conf ...

Code: [Select]
<IfModule mod_fcgid.c>
  AddHandler fcgid-script .fcgi
  IPCConnectTimeout 60
  IPCCommTimeout 600
  BusyTimeout 600
</IfModule>

I think that increasing the IPCCommTimeout setting will stop sgladstone's "idle timeout" error,

Ken
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Getting "Error 500: Internal Server Error" when trying to import

This forum was archived on 2017-11-26.