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 (Moderator: Dave Greenberg) »
  • Export MySQL error: table doesn't exist
Pages: [1]

Author Topic: Export MySQL error: table doesn't exist  (Read 748 times)

dbenton

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5.2
Export MySQL error: table doesn't exist
May 04, 2012, 02:09:09 pm
I originally posted this to the CiviMember forum, but now that I think about it, the error is probably not specific to CiviMember.

==

Hello,

I'm running into some strange behavior, and I can't find anything matching it in the forum or issue tracker. I'm running CiviCRM 4.0.3 and Drupal 7. I'm trying to export all memberships, with the intention of making changes and reimporting (and overwriting existing memberships).

When I try to export, there is some error information appended to the bottom of the exported .xls file (below many rows of correctly formatted data). The error information is in the form of HTML (including doctype, etc.), so it's obviously meant to be rendered to the browser. Rather than include all of the HTML, I'll just post the error. Please let me know if I can provide additional information. My export includes some custom fields, if that makes a difference.

Code: [Select]
[nativecode=1146 ** Table 'civicrm.civicrm_export_temp_3e43aa1e3faf28e6e7b822ec4c552295' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="

What might cause this? How can I verify that all of my data is exported? Do I need to be concerned about other database operations failing?

Thanks,
David

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: Export MySQL error: table doesn't exist
May 04, 2012, 06:51:41 pm

might want to upgrade to the latest 4.0.x version or better yet, 4.1.2 and see if u still get the 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

dbenton

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5.2
Re: Export MySQL error: table doesn't exist
May 11, 2012, 01:59:18 pm
Finally got everything upgraded and that took care of the problem. Thanks, Lobo!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Export MySQL error: table doesn't exist

This forum was archived on 2017-11-26.