CiviCRM Community Forums (archive)

Hi! I'm trying to migrate from an older civirm version 3.4.5 on Joomla to civicrm version 4.3.7 on Wordpress. A direct upgrade would not work, there was no upgrade path for 3.4.5 to 4.3.7... because it is an older version Joomla. So, I've got a clean install on wordpress and have been exporting and importing, using the built-in Civicrm ui to do it.

I've managed to import 100,000 records from our email list by splitting them up in 20k chunks.

Now I'm working on moving over contributions but have to import the contacts from the contributions export, about 2000 records. Thats because not all contributors were on our 100k email list.

This is the part where I'm getting the following error:

backTrace

#0 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(308): CRM_Core_Error::backtrace()
#1 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Type.php(326): CRM_Core_Error::fatal("One of parameters  (value: Array) is not of the type Integer")
#2 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(977): CRM_Utils_Type::validate("Array", "Integer")
#3 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(951): CRM_Core_DAO::composeQuery("\n                        SELECT v.label\n                        FROM   civi...", (Array:2), TRUE)
#4 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/OptionGroup.php(287): CRM_Core_DAO::singleValueQuery("\n                        SELECT v.label\n                        FROM   civi...", (Array:2))
#5 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(2286): CRM_Core_OptionGroup::lookupValues((Array:1), (Array:1), FALSE)
#6 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(655): CRM_Contact_BAO_Contact::getValues((Array:2), (Array:22))
#7 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Import/Parser/Contact.php(1706): CRM_Contact_BAO_Contact::retrieve((Array:2), (Array:22))
#8 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Import/Parser/Contact.php(1657): CRM_Import_Parser_Contact->formatParams((Array:6), "8", 93700)
#9 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Import/Parser/Contact.php(586): CRM_Import_Parser_Contact->createContact((Array:6), (Array:31), "8", "93700", FALSE, "4")
#10 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Import/Parser.php(358): CRM_Import_Parser_Contact->import("8", (Array:108), "1")
#11 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Import/ImportJob.php(275): CRM_Import_Parser->run("civicrm_import_job_07c9f1bb476a85fd0df7dd85618f1477", (Array:105), 8, 1, "_id", "_status", "8", "150020eb5962886b7aee72b6fa41a4de", 1994, "1", 30, NULL, "4")
#12 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Import/Form/Preview.php(288): CRM_Import_ImportJob->runImport(Object(CRM_Import_Form_Preview))
#13 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(246): CRM_Import_Form_Preview->postProcess()
#14 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#15 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Import_Form_Preview), "next", "Next")
#16 /var/www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Import_Form_Preview), "next")
#17 /var/www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Import_Form_Preview), "next")
#18 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("next")
#19 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(292): CRM_Core_Controller->run((Array:3), NULL)
#20 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#21 /var/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#22 /var/www/wp-content/plugins/civicrm/civicrm.php(344): CRM_Core_Invoke::invoke((Array:3))
#23 [internal function](): civicrm_wp_invoke("")
#24 /var/www/wp-includes/plugin.php(406): call_user_func_array("civicrm_wp_invoke", (Array:1))
#25 /var/www/wp-admin/admin.php(149): do_action("toplevel_page_CiviCRM")
#26 {main}


So, I figured maybe I had some custom fields or something not moving over right. So I got my import down to a BARE minimum, just first name, last name and email and that still gave the exact same error.

Anybody experience issues like this? Does my contributions export need to be bare minimum fields as well? shouldn't it ignore fields I mark as "- do not import -"?

Whats weird is that my contact export in 20k chunks works just fine.

I'm getting the same error message when attempting to update about 600 records. The import/update worked yesterday, today just trying to update the same records with new phone numbers. I'll try to replicate on the demo site and do a bug tracker if one does not yet exist.
Running CiviCRM version 4.2.14, Drupal.