Author Topic: 500 Errors during failed contact import (Read 3651 times)

AJA · July 27, 2008, 05:44:22 pm

Hello,

I'm setting up civicrm on a joomla 1.5.4 (legacy mode) install on a 1&1 shared host (business package).

When I try to import contacts I get a 500 Error every time. I started with 3000 contacts, then used "split -l 100" to break it into 100 line segments. The same error results for each one.

I have placed php.ini files in all directories (php over cgi) that set the max_exicution time to 3600, the memory to 256M and all the other relevent settings are at very high levels, still no dice. This is all verified working with phpinfo();

I have reinstalled both Joomla! and civicrm 3 times, with differing methods, it still fails in this manner, thereby rendering it impossible to use.

Does anyone have any ideas? I'm at a loss.

speleo · July 27, 2008, 11:29:34 pm

Can you check your apache error_log to see what the specific error was?

AJA · July 28, 2008, 12:31:00 am

I really wish I could, but 1&1 don't allow people access to the apache error logs on their shared servers. I was rather bummed to find this out.

Is there another way that I can find out what's going on? The people at 1&1 are about as helpful in this regard as a family of orangutans.

speleo · July 28, 2008, 01:10:03 am

Hmm, that doesn't give you much to go on. I presume that you've got php and mysql 5 running and verified on phpinfo.

You're not the first to have problems on a 1and1 platform. Also you can't believe everything you see in phpinfo with 1and1.

http://faq.1and1.com/scripting_languages_supported/php/16.html
Can the memory usage limit be increased on shared hosting with a php.ini file?

Due to resource limits on our Shared Hosting machines, it is not possible to allocate more than 20M
of memory to PHP, although phpinfo() may report a higher number. You will be unable to increase
the memory usage limit with a php.ini file.

You may want to look at http://wiki.civicrm.org/confluence/display/CRM/Hosting+provider+information

lcdweb · July 28, 2008, 05:55:17 am

Try to import a file with one or two records, to rule out any script bug (vs. a hosting problem). If that works, try larger blocks, like 50, but pull from the middle of your list (import the records to a group if you want to later delete them and process imports in a systematic way). A 500 error suggests something actually went wrong with the script, not that there was a timeout issue. That could be due to bad data, or a server issue (like what Henry suggested -- check whether php5 and mysql5 are running).

-Brian

AJA · August 01, 2008, 07:55:42 pm

Hey there, thank you for the response.

I got it to work finally, and here's what I did:

I installed a mirror version of the system on my server at home, then, after importing the contact data csv, I ran a mysqldump (not with phpMyAdmin, or any of those things, just a real cli command, because 1&1 refused to accept any other type due to foreign key constraints - which are overridden by default on a cli dump) of the entire database. From there, I logged into the 1and1 server over SSH and, after uploading the .sql result of the dump, I dropped and reloaded the whole table structure by importing the sql. I had to switch to the drupal version before doing this because the Joomla installer creates its tables in the Joomla database, but in order to make this work with 1&1's limitations I needed another schema. The only change I needed to make was setting a field to NULL so that civicrm could reinit, and it told me how to do it after I loaded the schema. I am pleased.

Thanks guys.

CiviCRM Community Forums (archive)

News:

Author Topic: 500 Errors during failed contact import (Read 3651 times)

AJA

500 Errors during failed contact import

speleo

Re: 500 Errors during failed contact import

AJA

Re: 500 Errors during failed contact import

speleo

Re: 500 Errors during failed contact import

lcdweb

Re: 500 Errors during failed contact import

AJA

Re: 500 Errors during failed contact import