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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Import issue using Drupal and CiviCRM version 1.9.13019 ...
Pages: [1]

Author Topic: Import issue using Drupal and CiviCRM version 1.9.13019 ...  (Read 1471 times)

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Import issue using Drupal and CiviCRM version 1.9.13019 ...
March 27, 2008, 08:20:20 am
Hello!  I'm experiencing issues with the import functionality with CiviCRM 1.9 and Drupal 5.6 running on PHP 5.25.  When I try importing it lets me upload the CSV file and map my data fields.  Then when I start the import, it gets to about 40% and then stops.  I get the following error:

We encountered an unknown error: [object Object]

I'm also getting memory limit errors, but I've tried increasing the memory limit to 100M in the PHP config and it doesn't fix the  issue.  Here are my PHP settings:

max_execution_time   3600   
max_input_nesting_level   64   
max_input_time   200
memory_limit   100M
post_max_size   8M

I'm running Drupal 5.6, MySQL 5.0.45, and PHP 5.25.

Now it's working for me on another site I'm running the following on (without issue):

Drupal 5.7, MySQL 4.1.22, PHP 5.0.5

On this site I don't get any memory limit issues.  When I look at the PHP info, I don't see memory_limit listed ono tihs one.  I've got the following listed:

max_execution_time   30   
max_input_time   0
post_max_size   8M


So this is weird! Is this a PHP or Drupal issue?  Do I need to change my version of PHP or Drupal on the site  I'm having issues with?  Not sure what else to do??

Please suggest!  Thanks!

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 issue using Drupal and CiviCRM version 1.9.13019 ...
March 27, 2008, 09:59:54 am

1. how large is the import file

2. any errors in the apache error log / drupal watchdog table?

3. is it consistent as to where the code encounters the unknown 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

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Re: Import issue using Drupal and CiviCRM version 1.9.13019 ...
March 27, 2008, 10:10:56 am
1) Files are approx. 448K, but I've split them up and imported a file as low as 14K and still have the same results.

2) I'll check the Apache log.  Where do I find the Drupal watchdog table?

3) The memory issue occurs when I try to browse and upload the CSV.  It doesn't occur every time on the browse/upload.  Sometimes I get as far as mapping the fields and then starting the import.  Then I get either the object error or the memory error again.

Sometimes it starts importing and then freezes at about 40% and I get the object 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: Import issue using Drupal and CiviCRM version 1.9.13019 ...
March 27, 2008, 11:15:39 am

the drupal watchdog table is in the drupal db, there is a table called watchdog. There is also an admin interface to this in the administer section

seems like your memory issue is a bit more than just the actual import process. You might want to ensure that your memory settings are being followed by the php server. A good way of doing it is by storing the below code ina  file and loading in the browser.

<?php

phpinfo( );

?>



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

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Re: Import issue using Drupal and CiviCRM version 1.9.13019 ...
March 27, 2008, 01:00:19 pm
My info.php file is there and this is the memory info via that file:

max_execution_time   3600   3600
max_input_nesting_level   64   64
max_input_time   200   200
memory_limit   100M   100M

So it looks like the memory limit is high enough? 


backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Re: Import issue using Drupal and CiviCRM version 1.9.13019 ...
March 27, 2008, 01:05:10 pm
Additionally, I checked my watchdog logs and there's no errors reported related to these issues.


Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Import issue using Drupal and CiviCRM version 1.9.13019 ...

This forum was archived on 2017-11-26.