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) »
  • Internal server error (500) when importing
Pages: [1]

Author Topic: Internal server error (500) when importing  (Read 3206 times)

mac

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
Internal server error (500) when importing
September 09, 2009, 11:09:00 am
I'm trying to import contacts from a .csv file and I keep running into internal server errors (500) all the time.

I read this thread, but I can't seem to get smarter out of it. I also can't reproduce the problem on the demo site.

What I tried so far with no result:
-) Smaller amount of records
-) Firefox and IE

The problem is also that goDaddy will show me the error logs from today only tomorrow, so I have to wait to see what kind of problem it is specifically.

Any ideas of what I might be doing wrong?

EDIT: I removed some custom data fields as well as the external identifier and tried to import again and it worked. I'm in the process of checking out what might be wrong there precisely.

EDIT II: I double-checked the fields that I checked off earlier. The external identifier was only varchar(32) (why?!). I extended it to 255 and tried again. Now I get the step 3, but then it gets stuck at 50 records:

Quote
50 of 100 records - 43 seconds remaining
We encountered an unknown error in setError: Error: Unable to load /civicrm/import/contact status:500

EDIT III: Today the import partially worked, but then I also get this problem:

Quote
[Thu Sep 10 11:21:39 2009] [error] (104)Connection reset by peer: FastCGI: comm with server "[..]/html-x-httpd-php5" aborted: read failed
[Thu Sep 10 11:21:39 2009] [error] FastCGI: incomplete headers (0 bytes) received from server "[..]/html-x-httpd-php5"

Any ideas?
« Last Edit: September 10, 2009, 11:24:16 am by mac »

mac

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
Re: Internal server error (500) when importing
September 11, 2009, 07:13:32 am
I figured out what the problem on goDaddy was. The script is just running too long and thus the 500 error. So I moved to my localhost and there (almost) everything seems to work.

I was able to import a few thousand contacts, but then I get this error (see attachment). How do I get the backtrace? The CiviCRM.log file is empty?

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Internal server error (500) when importing
September 11, 2009, 10:17:05 am
to turn on debugging and backtrace go to
Administer CiviCRM > Global Settings > Debugging

turn them both on, save, try your import again

mac

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
Re: Internal server error (500) when importing
September 14, 2009, 08:40:03 am
thanks. I actually called goDaddy support, and it turned out that with the shared hosting that we have, import of bigger amounts of contacts just won't work. The reason is that the script times out. :(

So now I'm in the process of importing all contact on my localhost and will then move them back to goDaddy. It's quite a pain, but I don't see a better solution.

Is there a better way than the "usual backend sql" way to move CiviCRM contacts from one server to the other?

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: Internal server error (500) when importing
September 14, 2009, 12:53:15 pm

in general if you are serious about using CiviCRM and trying to manage your organization's DB via CiviCRM, GoDaddy shared hosting is not your best option.

We do recommend that folks spend a bit more money on getting a VPS server and hosting on more powerful machines. CiviCRM does take a fair amount of resources

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

mac

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
Re: Internal server error (500) when importing
September 14, 2009, 01:04:31 pm
Lobo, thank you for the feedback.

We currently have ~30 visitors per day to our website and the CiviCRM problem seems to be the first one we encounter in this area. Switching to dedicated hosting (just for the CiviCRM) would cost us more than $100/month ...

So I wanted to ask: What kinds of problems do you foresee with CiviCRM if we stick to shared hosting?

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: Internal server error (500) when importing
September 14, 2009, 01:35:57 pm
basically slow response time, operations will time out etc. IMO, CiviCRM was not designed to run and work in a cheap shared hosting environment

I dont think VPS will cost you $100/month. I think there are quite a few cheaper VPS's around (but i dont know enuf about what your options are, so please do your own research)

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

mac

  • I post occasionally
  • **
  • Posts: 71
  • Karma: 0
Re: Internal server error (500) when importing
September 14, 2009, 01:37:24 pm
ok, thanks
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Internal server error (500) when importing

This forum was archived on 2017-11-26.