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) »
  • Importing Issues
Pages: [1]

Author Topic: Importing Issues  (Read 1129 times)

jtattersall

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: drupal 7
  • MySQL version: 5.1.70-cll
  • PHP version: 5.3.26
Importing Issues
September 25, 2014, 06:41:52 am
I have a csv file  of the sample data when i try and install it it  says  2,400 records ready to import clilk on import then this message happens.

backTrace

#0 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/Error.php(380): CRM_Core_Error::backtrace()
#1 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Utils/Type.php(347): CRM_Core_Error::fatal("One of parameters  (value: Array) is not of the type Integer")
#2 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/DAO.php(1183): CRM_Utils_Type::validate("Array", "Integer")
#3 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/DAO.php(1149): CRM_Core_DAO::composeQuery("\n                        SELECT v.label\n                        FROM   civi...", (Array:2), TRUE)
#4 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/OptionGroup.php(312): CRM_Core_DAO::singleValueQuery("\n                        SELECT v.label\n                        FROM   civi...", (Array:2))
#5 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(2458): CRM_Core_OptionGroup::lookupValues((Array:1), (Array:1), FALSE)
#6 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(708): CRM_Contact_BAO_Contact::getValues((Array:2), (Array:28))
#7 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/Import/Parser/Contact.php(1673): CRM_Contact_BAO_Contact::retrieve((Array:2), (Array:28))
#8 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/Import/Parser/Contact.php(658): CRM_Contact_Import_Parser_Contact->createContact((Array:31), (Array:35), "16", NULL, TRUE, "")
#9 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/Import/Parser.php(225): CRM_Contact_Import_Parser_Contact->import("16", (Array:71), NULL)
#10 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/Import/ImportJob.php(299): CRM_Contact_Import_Parser->run("civicrm_import_job_3c2d87e507cd04e251e60a4c79301aef", (Array:68), 8, 1, "_id", "_status", "16", "a2bf3679c030ea680f50ca933fba2076", 2400, NULL, 30, NULL, "")
#11 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Contact/Import/Form/Preview.php(285): CRM_Contact_Import_ImportJob->runImport(Object(CRM_Contact_Import_Form_Preview))
#12 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/Form.php(328): CRM_Contact_Import_Form_Preview->postProcess()
#13 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/StateMachine.php(162): CRM_Core_Form->mainProcess()
#14 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Import_Form_Preview), "next", "Next")
#15 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Import_Form_Preview), "next")
#16 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Import_Form_Preview), "next")
#17 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/Controller.php(356): HTML_QuickForm_Page->handle("next")
#18 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/Invoke.php(331): CRM_Core_Controller->run((Array:3), NULL)
#19 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:13))
#20 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#21 /home/fsserver/public_html/DCMS/sites/all/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:3))
#22 [internal function](): civicrm_invoke("import", "contact")
#23 /home/fsserver/public_html/DCMS/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#24 /home/fsserver/public_html/DCMS/index.php(21): menu_execute_active_handler()
#25 {main}

Sorry but we are not able to provide this at the moment.
One of parameters (value: Array) is not of the type Integer
Return to home page.
« Last Edit: September 25, 2014, 06:43:30 am by jtattersall »

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Importing Issues
September 25, 2014, 09:08:51 am
Does this happen even if you try to import only one record?  It could be good to separate out whether the problem is in the data or not.

The backtrace lines 3 and 4 seem to suggest it's trying to import a column called "label\n".  The "\n" indicates a new line.  That whole section ("\n                        SELECT v.label\n" is pretty shady.  Can you share the CSV you're using?  And please confirm this is Civi 4.5?

Thanks,
Jon
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

jtattersall

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: drupal 7
  • MySQL version: 5.1.70-cll
  • PHP version: 5.3.26
Re: Importing Issues
September 25, 2014, 11:29:50 am
I am Using 4.5 Stable version of civicrm. I Have Tried just importing one line but the same error.  I Have also used a diffrent set of data but the same issues.

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Importing Issues
September 25, 2014, 11:41:47 am
That sounds like a bug then!  This is a pretty large number of columns to import - so my thinking is that either a) the bug is with importing a specific column, or b) importing is just totally broken.

Are you able to import with just a few columns?  If you can narrow it down to a column (or columns), and can replicate the problem on the demo server, then I'd open a bug on issues.civicrm.org listing the steps to take to replicate the problem.  This would be considered a regression (i.e. something that worked in 4.4 is broken in 4.5) and those are getting top priority.

Of course, if importing is totally broken, that's also bug-worthy!
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Importing Issues
September 25, 2014, 02:37:15 pm
I'm guessing a particular column is problematic
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Importing Issues
March 20, 2016, 02:53:28 pm
actually i think this isn't related to the import per se - but a corrupted bit of data on some of the contacts - in my example we were not touching the affected field, but i figured that actually the contacts involved could not be 'viewed' without generating an error like the above.

in my case was /sites/all/modules/civicrm/CRM/Utils/Type.php(362): CRM_Core_Error::fatal("One of parameters  (value: Array) is not of the type Integer")

which didn't help, but by luck i spotted that some contacts who were affected had 'array' in the Communication Preferences field, not sure how, but removing that via db sorted the problem.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Issues

This forum was archived on 2017-11-26.