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) »
  • Export Failing as Non-Recoverable Error
Pages: [1]

Author Topic: Export Failing as Non-Recoverable Error  (Read 845 times)

gsd

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
  • CiviCRM version: 3.45
  • CMS version: Joomla
  • MySQL version: 5.19
  • PHP version: 5.29
Export Failing as Non-Recoverable Error
November 02, 2011, 12:03:13 pm
I keep getting the following error when I try to export...

Sorry. A non-recoverable error has occurred
DB Error: value count on row

The full backtrace looks like this
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2424
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1610
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 152
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 879
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Export/BAO/Export.php, executeQuery, 1202
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Export/BAO/Export.php, writeDetailsToTable, 903
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Export/Form/Map.php, exportComponents, 239
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 250
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, mainProcess, 167
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/ks/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 284
/home/ks/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 223
/home/ks/public_html/administrator/components/com_civicrm/admin.civicrm.php, invoke, 85
/home/ks/public_html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/home/ks/public_html/libraries/joomla/application/component/helper.php, require_once, 162
/home/ks/public_html/administrator/includes/application.php, renderComponent, 136
/home/ks/public_html/administrator/index.php, dispatch, 67
/home/ks/public_html/administrator/index2.php, include, 14

I cannot figure this out at all. I am lost. Please Help

SNtialMKB

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
    • SNtial Technologies
  • CiviCRM version: clients on 2.2.8 to 3.4.8
  • CMS version: Drupal 6
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Export Failing as Non-Recoverable Error
November 02, 2011, 12:07:15 pm
We just resolved a similar problem by increasing .tmp space on the server.

gsd

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
  • CiviCRM version: 3.45
  • CMS version: Joomla
  • MySQL version: 5.19
  • PHP version: 5.29
Re: Export Failing as Non-Recoverable Error
November 02, 2011, 12:11:31 pm
Oh. How did you do that?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Export Failing as Non-Recoverable Error
November 02, 2011, 12:52:31 pm
gsd, does a small export work?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

gsd

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
  • CiviCRM version: 3.45
  • CMS version: Joomla
  • MySQL version: 5.19
  • PHP version: 5.29
Re: Export Failing as Non-Recoverable Error
November 02, 2011, 01:29:00 pm
Export works without marking Merge Contacts with the Same Address Merge Household Members into their Households When you select those options it times out.

SNtialMKB

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
    • SNtial Technologies
  • CiviCRM version: clients on 2.2.8 to 3.4.8
  • CMS version: Drupal 6
  • MySQL version: 5.x
  • PHP version: 5.x
Re: Export Failing as Non-Recoverable Error
November 02, 2011, 04:12:38 pm
GSD: Our server admin tells me our error was different, and so increasing tmp space may not solve your problem, but if you choose to try it, these are the steps:

(a) create/find a disk partition/directory with sufficient desired space,
(b) edit MySQL's /etc/my.cnf and specify new directory using tmpdir=/path/to/new/directory [just Google MySQL tmpdir] and
(c) restart MySQL server.
There is no hard and fast rule as to what's sufficiently large, one increases it till it is big enough because SQL queries vary in size on multiple criteria.

If you are not able to export a small file with the same household merge settings, then the temp file increase probably is not the solution to your problem.
-Mary Kay

rbrinson

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.6
  • CMS version: 6.22
  • MySQL version: 5.1.54
  • PHP version: 5.3.6
Re: Export Failing as Non-Recoverable Error
November 08, 2011, 11:45:34 am
We ran across the same issue, I think. We've reported it as a bug; issue no. CRM-8971 in the Civi issue tracker.

It works if you select ONLY "merge contacts with same address" but not "merge contacts into households." That's a poor solution, though, because it essentially deletes the secondary contact and retains only the name of the head of household.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Export Failing as Non-Recoverable Error

This forum was archived on 2017-11-26.