Author Topic: Unable to export contacts -- NEED to recover 3,385 contacts. (Read 564 times)

ToddFur · January 25, 2011, 10:38:41 am

Hi, I'm unable to export 3,385 contacts from CiviCRM (on an older server). I however was able to export the mySQL database and it seems I was only able to recover about 2,000 contacts. I'm not sure why I can't find the remaining 1,300. I can see their contact info but it is kind of scattered all over the database.... searching for all contacts does show 3,385 contacts on my CiviCRM but I just can't export them due to this error:

"Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

Database Error Code: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay, 1104"

I need those 3,385 contacts to import back onto a new CiviCRM (clean install) -- I have no interest in pointing the new CiviCRM to the old database. I want to start clean.

How can I fix the export problem or at least recover all 3,385 addresses from mySQL???

CiviTeacher.com · January 26, 2011, 06:43:03 am

Take a deep breath.

Two approaches might work:

1. increase max join size, that is what the error is telling you is wrong, isn't it?

a. go into mySQL and run this query

Code: [Select]

show global variables like 'max_join_size';

Update your MySQL config file called my.cnf (usually found in the /etc or /var directory of a Linux server)

Add this to my.cnf

max_join_size = (twice the number of whatever it was before)

2. The other option is to look in the MySQL database and run this query:

Code: [Select]

select count(*) from civicrm_contacts

That is the number of contacts truly in your database.

CiviCRM Community Forums (archive)

News:

Author Topic: Unable to export contacts -- NEED to recover 3,385 contacts. (Read 564 times)

ToddFur

Unable to export contacts -- NEED to recover 3,385 contacts.

CiviTeacher.com

Re: Unable to export contacts -- NEED to recover 3,385 contacts.