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) »
  • Import CSV not working as expected, Fatal error deleting imported records
Pages: [1]

Author Topic: Import CSV not working as expected, Fatal error deleting imported records  (Read 2014 times)

midloman

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 1
Import CSV not working as expected, Fatal error deleting imported records
April 08, 2009, 08:19:35 pm
I'm stumped. 

I have a .csv file with 6170 records in it.
When I go to import this file, Civicrm tells me in step 3 that I have 5503 total rows and 5503 valid rows, no errors.
It seems to stop and exit at about 7%, in less then 2 minutes.

Step 4 tells me I've imported 5503 rows and have 5503 Contacts.
Then I go to Find Contacts with no search parameters, it tells me I have 587 Results.
I select all contact and "delete" option and get this error message:

Fatal error: Out of memory (allocated 40894464) (tried to allocate 7680 bytes) in /home/pmicvcte/public_html/drupal61/sites/all/modules/civicrm/CRM/Utils/Hook.php(61) : eval()'d code on line 1.


All but 198 records have been deleted.
The next delete attempt removes 197 records as expected, no error messages.

I'm on BlueHost, have single php.ini turned on

I have these settings in the php.ini
max_execution_time = 600     
max_input_time = 600   
memory_limit = 128M   

I've been twiddling with these numbers all evening, and none of them change.
I've also tried putting the php.ini file everywhere - no change.

Any ideas?

ParkHill

  • Guest
Re: Import CSV not working as expected, Fatal error deleting imported records
April 15, 2009, 04:13:10 pm
Although you can set php.ini to 128M, Bluehost like other shared hosts, limits memory usage to 64M. Your hitting a memory limit lower than that, so perhaps there is another setting. Use the following code (in a drupal node with php settings on) to read your php settings:

Code: [Select]
<?php
phpinfo();  
?>

midloman

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 1
Re: Import CSV not working as expected, Fatal error deleting imported records
April 16, 2009, 07:53:38 am
OK, I've done that and It reports 128M.   ???

Many of the problems I complained about have decreased because I was doing stupid things on my import, but the memory failure on deleting records is still there.

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: Import CSV not working as expected, Fatal error deleting imported records
April 16, 2009, 11:58:03 am

can you apply this patch and see if it fixes the issue:

http://fisheye.civicrm.org/rdiff/CiviCRM?csid=20696&u&N

If you are not familiar with applying patches, this fix will be part of 2.2.3

thanx

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

midloman

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 1
Re: Import CSV not working as expected, Fatal error deleting imported records
April 16, 2009, 12:01:51 pm
I don't know how to apply a patch.  :-[

midloman

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 1
Re: Import CSV not working as expected, Fatal error deleting imported records
April 16, 2009, 12:16:59 pm
I figured out the patch process, and applied it.  That worked.  Thanks!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import CSV not working as expected, Fatal error deleting imported records

This forum was archived on 2017-11-26.