CiviCRM Community Forums (archive)

I have previously successfully set up 12 users aligned with 4 user roles in Civi with no problems. Now I have added a new user but when the user tries to log in Civi returns the error message pasted below. I followed the same steps for this user as with the other users (which are still operating with no problems) and can't figure out what the problem is.

Error message
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
 
Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
SELECT count(DISTINCT contact_a.id)
        FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_group_contact `civicrm_group_contact-39` ON contact_a.id = `civicrm_group_contact-39`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-42` ON contact_a.id = `civicrm_group_contact-42`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_g
roup_contact-43` ON contact_a.id = `civicrm_group_contact-43`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-44` ON contact_a.id = `civicrm_group_contact-44`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-48` ON contact_a.id = `civicrm_group_contact-48`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-49` ON contact_a.id = `civicrm_group_contact-49`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-50` ON contact_a.id = `civicrm_group_contact-50`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-51` ON contact_a.id = `civicrm_group_contact-51`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-54` ON contact_a.id = `civicrm_group_contact-54`.contact_id   LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender' AND option_group_gender.domain_id = 1 ) LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value
 AND option_group_gender.id = gender.option_group_id)
WHERE contact_a.id = 2338 AND  (  ( `civicrm_group_contact-39`.group_id IN (39) AND `civicrm_group_contact-39`.status IN ("Added") )  OR  ( `civicrm_group_contact-42`.group_id IN (42) AND `civicrm_group_contact-42`.status IN ("Added") )  OR  ( `civicrm_group_contact-43`.group_id IN (43) AND `civicrm_group_contact-43`.status IN ("Added") )  OR  ( `civicrm_group_contact-44`.group_id IN (44) AND `civicrm_group_contact-44`.status IN ("Added") )  OR  ( `civicrm_group_contact-48`.group_id IN (48) AND `civicrm_group_contact-48`.status IN ("Added") )  OR  ( `civicrm_group_contact-49`.group_id IN (49) AND `civicrm_group_contact-49`.status IN ("Added") )  OR  ( `civicrm_group_contact-50`.group_id IN (50) AND `civicrm_group_contact-50`.status IN ("Added") )  OR  ( `civicrm_group_contact-51`.group_id IN (51) AND `civicrm_group_contact-51`.status IN ("Added") )  OR  ( `civicrm_group_contact-54`.group_id IN (54) AND `civicrm_group_contact-54`.status IN ("Added") )  )  [nativecode=1104 ** T
he 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 count(DISTINCT contact_a.id)
        FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_group_contact `civicrm_group_contact-39` ON contact_a.id = `civicrm_group_contact-39`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-42` ON contact_a.id = `civicrm_group_contact-42`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_g
roup_contact-43` ON contact_a.id = `civicrm_group_contact-43`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-44` ON contact_a.id = `civicrm_group_contact-44`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-48` ON contact_a.id = `civicrm_group_contact-48`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-49` ON contact_a.id = `civicrm_group_contact-49`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-50` ON contact_a.id = `civicrm_group_contact-50`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-51` ON contact_a.id = `civicrm_group_contact-51`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-54` ON contact_a.id = `civicrm_group_contact-54`.contact_id   LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender' AND option_group_gender.domain_id = 1 ) LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value
 AND option_group_gender.id = gender.option_group_id)
WHERE contact_a.id = 2338 AND  (  ( `civicrm_group_contact-39`.group_id IN (39) AND `civicrm_group_contact-39`.status IN ("Added") )  OR  ( `civicrm_group_contact-42`.group_id IN (42) AND `civicrm_group_contact-42`.status IN ("Added") )  OR  ( `civicrm_group_contact-43`.group_id IN (43) AND `civicrm_group_contact-43`.status IN ("Added") )  OR  ( `civicrm_group_contact-44`.group_id IN (44) AND `civicrm_group_contact-44`.status IN ("Added") )  OR  ( `civicrm_group_contact-48`.group_id IN (48) AND `civicrm_group_contact-48`.status IN ("Added") )  OR  ( `civicrm_group_contact-49`.group_id IN (49) AND `civicrm_group_contact-49`.status IN ("Added") )  OR  ( `civicrm_group_contact-50`.group_id IN (50) AND `civicrm_group_contact-50`.status IN ("Added") )  OR  ( `civicrm_group_contact-51`.group_id IN (51) AND `civicrm_group_contact-51`.status IN ("Added") )  OR  ( `civicrm_group_contact-54`.group_id IN (54) AND `civicrm_group_contact-54`.status IN ("Added") )  )  [nativecode=1104 ** T
he 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]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT count(DISTINCT contact_a.id)
        FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_group_contact `civicrm_group_contact-39` ON contact_a.id = `civicrm_group_contact-39`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-42` ON contact_a.id = `civicrm_group_contact-42`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_g
roup_contact-43` ON contact_a.id = `civicrm_group_contact-43`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-44` ON contact_a.id = `civicrm_group_contact-44`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-48` ON contact_a.id = `civicrm_group_contact-48`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-49` ON contact_a.id = `civicrm_group_contact-49`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-50` ON contact_a.id = `civicrm_group_contact-50`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-51` ON contact_a.id = `civicrm_group_contact-51`.contact_id    LEFT JOIN civicrm_group_contact `civicrm_group_contact-54` ON contact_a.id = `civicrm_group_contact-54`.contact_id   LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender' AND option_group_gender.domain_id = 1 ) LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value
 AND option_group_gender.id = gender.option_group_id)
WHERE contact_a.id = 2338 AND  (  ( `civicrm_group_contact-39`.group_id IN (39) AND `civicrm_group_contact-39`.status IN ("Added") )  OR  ( `civicrm_group_contact-42`.group_id IN (42) AND `civicrm_group_contact-42`.status IN ("Added") )  OR  ( `civicrm_group_contact-43`.group_id IN (43) AND `civicrm_group_contact-43`.status IN ("Added") )  OR  ( `civicrm_group_contact-44`.group_id IN (44) AND `civicrm_group_contact-44`.status IN ("Added") )  OR  ( `civicrm_group_contact-48`.group_id IN (48) AND `civicrm_group_contact-48`.status IN ("Added") )  OR  ( `civicrm_group_contact-49`.group_id IN (49) AND `civicrm_group_contact-49`.status IN ("Added") )  OR  ( `civicrm_group_contact-50`.group_id IN (50) AND `civicrm_group_contact-50`.status IN ("Added") )  OR  ( `civicrm_group_contact-51`.group_id IN (51) AND `civicrm_group_contact-51`.status IN ("Added") )  OR  ( `civicrm_group_contact-54`.group_id IN (54) AND `civicrm_group_contact-54`.status IN ("Added") )  )  [nativecode=1104 ** T
he 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]"]
)