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) »
  • Error message on export using Primary fields
Pages: [1]

Author Topic: Error message on export using Primary fields  (Read 647 times)

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Error message on export using Primary fields
March 02, 2010, 01:09:03 pm
I get the following error message when trying to do a 600 record export of primary fields only:

Code: [Select]
Sorry. A non-recoverable error has occurred.


DB Error: unknown error

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

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    (code) => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT contact_a.id as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, contact_a.display_name  as `display_name`, contact_a.do_not_email  as `do_not_email`, contact_a.do_not_phone  as `do_not_phone`, contact_a.do_not_mail  as `do_not_mail`, contact_a.do_not_sms  as `do_not_sms`, contact_a.do_not_trade  as `do_not_trade`, contact_a.is_opt_out  as `is_opt_out`, contact_a.legal_identifier  as `legal_identifier`, contact_a.external_identifier  as `external_identifier`, contact_a.nick_name  as `nick_name`, contact_a.legal_name  as `legal_name`, contact_a.home_URL  as `home_URL`, contact_a.image_URL  as `image_URL`, contact_a.preferred_communication_method  as `preferred_communication_method`,

(long section deleted to keep this post within required length)
 

_a.id IN ( 333,334,335,243,232,136,295,336,337,338,339,340,341,342,343,344,345,1736,347,348,349,350,116,351,352,353,354,52,355,356,357,114,359,149,70,361,362,363,364,365,366,367,223,368,369,370,371,159,97,373,304,375,376,377,249,378,379,380,381,189,382,383,384,385,386,387,388,389,390,391,257,393,394,173,396,96,398,399,400,332,401,402,403,404,157,103,407,408,409,410,411,412,82,414,415,416,417,418,419,420,421,422,423,35,424,425,426,427,428,429,430,431,432,433,3,435,436,137,438,439,440,441,442,443,444,445,105,139,447,448,449,193,450,451,214,452,453,201,454,455,456,457,458,459,460,461,462,276,115,323,464,33,465,466,467,468,250,469,470,471,472,239,474,202,475,478,122,477,479,231,480,207,481,482,483,320,28,58,644,645,646,647,100,649,650,493,494,51,654,497,498,499,500,501,660,661,1187,662,505,506,109,666,225,667,74,510,107,512,513,106,514,63,283,674,675,676,129,677,678,679,680,49,682,683,684,199,685,528,134,688,531,690,691,692,693,217,694,695,538,697,212,698,699,44,701,702,545,704,547,221,127,124,220,708,709,102,711,40,554,555,714,151,715,558,717,37,560,55,720,227,721,1738,722,723,566,567,568,174,728,571,729,730,573,574,733,322,321,735,736,204,737,738,739,67,104,584,9,744,745,588,746,747,590,195,54,749,263,593,178,1188,192,301,754,755,598,599,600,601,760,603,762,763,269,764,65,766,186,610,769,770,613,772,615,774,775,270,69,776,619,778,621,29,781,782,783,17,246,627,628,629,788,631,177,791,792,793,133,795,796,639,120,93,800,801,802,803,266,805,806,94,808,809,810,140,233,811,286,812,813,20,815,205,816,817,818,819,820,821,822,119,824,825,826,827,828,829,830,72,831,832,833,834,835,836,837,839,840,260,45,998,36,1001,1002,23,248,130,850,851,1007,853,1009,197,1,855,2,4,30,89,41,312,1014,1015,77,863,862,864,152,138,1021,867,868,219,869,870,871,872,873,874,875,876,91,1032,16,1034,880,881,882,1584,75,143,884,1040,1041,887,1189,1044,1045,1046,1047,292,1049,1050,896,1052,1053,99,900,901,1057,903,1059,8,906,1062,908,1064,210,208,203,1065,146,148,90,913,1069,150,915,27,916,1072,918,305,1190,920,921,19,1078,924,1084,111,926,1082,1083,330,1085,931,932,194,1088,934,1090,1091,62,938,939,940,941,1097,943,1099,1100,1101,1102,1103,1104,950,951,1107,64,5,230,1110,956,957,147,958,142,290,255,1115,961,962,963,76,965,1121,1122,968,1124,1125,1126,1127,973,974,1130,976,324,1132,176,79,1135,222,1136,1137,983,271,108,1139,1140,31,1142,80,50,1191,989,1694,1146,992,198,57,1149,1150,1151,1152,71,1154,1155,1156,1157,1158,1159,187,1160,1161,1162,1163,1164,1168,1169,1165,1166,175,228,46,211,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,85,1182,226,1183,1184,156,1185,1186 )  GROUP BY contact_a.id ORDER BY sort_name asc [nativecode=1104 ** 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]
    [type] => DB_Error
    [user_info] => SELECT contact_a.id as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, contact_a.display_name  as `display_name`, contact_a.do_not_email  as `do_not_email`, contact_a.do_not_phone  as `do_not_phone`, contact_a.do_not_mail  as `do_not_mail`, contact_a.do_not_sms  as `do_not_sms`, contact_a.do_not_trade  as `do_not_trade`, contact_a.is_opt_out  as `is_opt_out`, contact_a.legal_identifier  as `legal_identifier`, contact_a.external_identifier  as `external_identifier`, contact_a.nick_name  as `nick_name`,

(long section deleted for length)

 (contact_a.prefix_id = individual_prefix.value AND option_group_prefix.id = individual_prefix.option_group_id )  LEFT JOIN civicrm_option_group option_group_suffix ON (option_group_suffix.name = 'individual_suffix') LEFT JOIN civicrm_option_value individual_suffix ON (contact_a.suffix_id = individual_suffix.value AND option_group_suffix.id = individual_suffix.option_group_id )  LEFT JOIN civicrm_option_group option_group_postal_greeting ON (option_group_postal_greeting.name = 'postal_greeting') LEFT JOIN civicrm_option_value postal_greeting ON (contact_a.postal_greeting_id = postal_greeting.value AND option_group_postal_greeting.id = postal_greeting.option_group_id )  WHERE  contact_a.id IN ( 333,334,335,243,232,136,295,336,337,338,339,340,341,342,343,344,345,1736,347,348,349,350,116,351,352,353,354,52,355,356,357,114,359,149,70,361,362,363,364,365,366,367,223,368,369,370,371,159,97,373,304,375,376,377,249,378,379,380,381,189,382,383,384,385,386,387,388,389,390,391,257,393,394,173,396,96,398,399,400,332,401,402,403,404,157,103,407,408,409,410,411,412,82,414,415,416,417,418,419,420,421,422,423,35,424,425,426,427,428,429,430,431,432,433,3,435,436,137,438,439,440,441,442,443,444,445,105,139,447,448,449,193,450,451,214,452,453,201,454,455,456,457,458,459,460,461,462,276,115,323,464,33,465,466,467,468,250,469,470,471,472,239,474,202,475,478,122,477,479,231,480,207,481,482,483,320,28,58,644,645,646,647,100,649,650,493,494,51,654,497,498,499,500,501,660,661,1187,662,505,506,109,666,225,667,74,510,107,512,513,106,514,63,283,674,675,676,129,677,678,679,680,49,682,683,684,199,685,528,134,688,531,690,691,692,693,217,694,695,538,697,212,698,699,44,701,702,545,704,547,221,127,124,220,708,709,102,711,40,554,555,714,151,715,558,717,37,560,55,720,227,721,1738,722,723,566,567,568,174,728,571,729,730,573,574,733,322,321,735,736,204,737,738,739,67,104,584,9,744,745,588,746,747,590,195,54,749,263,593,178,1188,192,301,754,755,598,599,600,601,760,603,762,763,269,764,65,766,186,610,769,770,613,772,615,774,775,270,69,776,619,778,621,29,781,782,783,17,246,627,628,629,788,631,177,791,792,793,133,795,796,639,120,93,800,801,802,803,266,805,806,94,808,809,810,140,233,811,286,812,813,20,815,205,816,817,818,819,820,821,822,119,824,825,826,827,828,829,830,72,831,832,833,834,835,836,837,839,840,260,45,998,36,1001,1002,23,248,130,850,851,1007,853,1009,197,1,855,2,4,30,89,41,312,1014,1015,77,863,862,864,152,138,1021,867,868,219,869,870,871,872,873,874,875,876,91,1032,16,1034,880,881,882,1584,75,143,884,1040,1041,887,1189,1044,1045,1046,1047,292,1049,1050,896,1052,1053,99,900,901,1057,903,1059,8,906,1062,908,1064,210,208,203,1065,146,148,90,913,1069,150,915,27,916,1072,918,305,1190,920,921,19,1078,924,1084,111,926,1082,1083,330,1085,931,932,194,1088,934,1090,1091,62,938,939,940,941,1097,943,1099,1100,1101,1102,1103,1104,950,951,1107,64,5,230,1110,956,957,147,958,142,290,255,1115,961,962,963,76,965,1121,1122,968,1124,1125,1126,1127,973,974,1130,976,324,1132,176,79,1135,222,1136,1137,983,271,108,1139,1140,31,1142,80,50,1191,989,1694,1146,992,198,57,1149,1150,1151,1152,71,1154,1155,1156,1157,1158,1159,187,1160,1161,1162,1163,1164,1168,1169,1165,1166,175,228,46,211,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,85,1182,226,1183,1184,156,1185,1186 )  GROUP BY contact_a.id ORDER BY sort_name asc [nativecode=1104 ** 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]"]
)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Error message on export using Primary fields

This forum was archived on 2017-11-26.