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 an "Internal Server Error" when trying to import contacts
Pages: [1]

Author Topic: Getting an "Internal Server Error" when trying to import contacts  (Read 5353 times)

matthewdnye

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Getting an "Internal Server Error" when trying to import contacts
November 01, 2009, 03:22:49 am
I am running CiviCRM 3.0 on a shared Linux hosting account on GoDaddy. I have successfully imported a batch of 250 contacts and am now trying to import a batch of 1800. When I get to the final step, I get this:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, support@supportwebsite.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.33 Server at mattnye.com Port 80

I turned on the error logs, and this is what it shows:

PHP:  Error parsing /home/content/b/r/e/brep50/html/php5.ini on line 1
Failed loading /home/content/b/r/e/brep50/html/ioncube/ioncube_loader_lin_5.2.sorg_emulation:  /home/content/b/r/e/brep50/html/ioncube/ioncube_loader_lin_5.2.sorg_emulation: cannot open shared object file: No such file or directory
PHP:  Error parsing /home/content/b/r/e/brep50/html/php5.ini on line 1
Failed loading /home/content/b/r/e/brep50/html/ioncube/ioncube_loader_lin_5.2.sorg_emulation:  /home/content/b/r/e/brep50/html/ioncube/ioncube_loader_lin_5.2.sorg_emulation: cannot open shared object file: No such file or directory
[Sun Nov  1 04:07:32 2009] [error] [client 68.157.37.197] File does not exist: /var/chroot/home/content/b/r/e/brep50/html/nyem50/templati class=
[Sun Nov  1 04:07:32 2009] [error] [client 68.157.37.197] File does not exist: /var/chroot/home/content/b/r/e/brep50/html/nyem50/missing.html

Any suggestions?

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 an "Internal Server Error" when trying to import contacts
November 01, 2009, 06:56:52 am

this seems like an hosting issue problem. please contact your hosting provider

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

matthewdnye

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: Getting an "Internal Server Error" when trying to import contacts
November 01, 2009, 07:54:16 am
Quote from: Donald Lobo on November 01, 2009, 06:56:52 am

this seems like an hosting issue problem. please contact your hosting provider

lobo

Did that before I posted - support guy seemed pretty knowledgable, checked things on his side and concluded it was something in my CiviCRM installation :>(

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 an "Internal Server Error" when trying to import contacts
November 01, 2009, 07:56:36 am

sorry, no idea :(

if u figure it out, please update the forums and let us know what the issue was

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

Keith

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: Getting an "Internal Server Error" when trying to import contacts
August 05, 2010, 07:32:20 pm
Probably a server time out or memory exceeded problem

Christopher Wilde

  • Guest
Re: Getting an "Internal Server Error" when trying to import contacts
August 13, 2010, 03:50:39 pm
Having the same issue with a new civi install I'm busy with for a friend of mine....

on godaddy hosting, have another install on godaddy that I'm using personally and its works great so dunno that its a hosting issue.... 

the working install was earlier this year so wonder if it could be something to do with the newer version....

any thought?

Christopher Wilde

  • Guest
Re: Getting an "Internal Server Error" when trying to import contacts
August 13, 2010, 03:53:45 pm
oh and the update of drupal.....

just remebered....

:(

jimmyjam

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
Re: Getting an "Internal Server Error" when trying to import contacts
September 08, 2010, 10:55:22 pm
I'm having the same problem on a GoDaddy Virtual Dedicated Server w/ 1GB RAM. The sever is generally fast and stable, but the imports all time out when I use the 'Update" option.

"500 Internal Server Error". See attached for a screenshot.

Thanks,
James

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Getting an "Internal Server Error" when trying to import contacts
September 12, 2010, 01:52:40 pm
James, please don't post issues more than once.

The answer anyhow is that we would need to see the error logs of your server to determine what the issue is.

Thanks.
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.

Erich

  • I post occasionally
  • **
  • Posts: 84
  • Karma: 1
Re: Getting an "Internal Server Error" when trying to import contacts
September 19, 2010, 09:37:21 pm
Wow, a CiviCRM newbie gets to answer someone else's question!

I've gotten the "500 Internal Server Error" also, while trying to import a file with over 1000 records... but I also noticed (though I don't remember what prompted me to check) that the temporary table that was created in CiviCRM for the import job was still there (i.e. it was not dropped, like it would have been had the import completed successfully).

I browsed the table and didn't see anything unusual... the import just seemed to stop mid-stream!

So, on a whim, I just pressed the back button on my browser and re-clicked the Import Now button (and confirming that I really did want to import now).  The import just picked up where it left off, and eventually completed successfully.  The only thing was, the "N" (in the "N records imported" success message) didn't match the number of records in the file... rather, it was just the number of records in the last import batch.  But, a query of the database showed *all* records to have been imported.

I should add that this "if at first you don't succeed, try again" method even worked for an import file with well over 5000 records... I just had to hit the browser's back button a total of 5 times (since only about a thousand records, give or take a hundred, got imported at a time).
« Last Edit: September 19, 2010, 09:40:20 pm by Erich »

Erich

  • I post occasionally
  • **
  • Posts: 84
  • Karma: 1
Re: Getting an "Internal Server Error" when trying to import contacts
September 19, 2010, 10:00:05 pm
Just a WAG, but...

Is there a way to specify something like an "import commit count" parameter (i.e. commit what you have so far when you get to N records, then continue with the next N, until you get to the end of the import file)? 

My (limited) experience with CiviCRM imports would seem to indicate that CiviCRM is trying to import everything in an "all or nothing" operation, and using up memory and/or processing time in the process.  Maybe all that's needed is a periodic "buffer flush" to "clean out the pipes" and allow CiviCRM to continue without getting the 500 error.

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 an "Internal Server Error" when trying to import contacts
September 20, 2010, 04:29:26 am

Yes, ideally we should be able to periodically do a page refresh and start off from where we last synched the db. Import does need some work to clean it up and make it scale more.

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Getting an "Internal Server Error" when trying to import contacts

This forum was archived on 2017-11-26.