The best practice is to make a group and send a newsletter for large groups. But putting this error out there for tracking.

Find Contributions

unrecoverable error
Sorry. A non-recoverable error has occurred.

Array

DB Error: no such field

Database Error Code: Unknown column 'xt' in 'where clause', 1054

Return to home page.

Error Details:

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

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT contact_a.id as contact_id,
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.preferred_mail_format as `preferred_mail_format`,
civicrm_email.id as email_id, civicrm_email.email as `email`,
civicrm_email.on_hold as `on_hold` FROM civicrm_contact contact_a
LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id
AND civicrm_email.is_primary = 1) WHERE ( ( contact_a.id IN
(12046,8738,12116,12144,12194,12202,12276,7076,12290,12328,12336,12346,12358,1368,8702,12414,12426,12438,12464,12472,12478,12490,12496,12498,12500,12502,12508,12532,12548,12556,12558,12622,12622,12628,12630,12632,7596,12660,12674,12730,12794,12802,12816,12848,12856,12860,12880,12882,12950,13210,13210,13354,13356,13360,13362,13370,13416,13422,13454,13470,13470,13488,13516,13534,13540,4632,13649,13705,13733,13765,13851,14074,14166,13777,14282,14282,14328,14356,12026,14458,14492,14504,xt,14528,14576,14674,14678,14770,14778,8702,14998,15024,14656,15040,15086,671,15166,15170,15196,15300,15364,15406,15444,15458,15496,15526,15532,15556,15564,15586,15612,15556,2074,2074,15678,15706,15708,15712,15738,15706,15778,15192,15818,3890,1288,7848,7848,2074,15890,15944,2074,15444,777,3,16024,16028,16146,16154,15192,16188,16200,3,16264,16270,8702,16278,16294,3,3,16348,16426
) ) ) LIMIT 0, 151 [nativecode=1054 ** Unknown column 'xt' in
'where clause']
[type] => DB_Error
[user_info] => SELECT contact_a.id as contact_id,
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.preferred_mail_format as `preferred_mail_format`,
civicrm_email.id as email_id, civicrm_email.email as `email`,
civicrm_email.on_hold as `on_hold` FROM civicrm_contact contact_a
LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id
AND civicrm_email.is_primary = 1) WHERE ( ( contact_a.id IN
(12046,8738,12116,12144,12194,12202,12276,7076,12290,12328,12336,12346,12358,1368,8702,12414,12426,12438,12464,12472,12478,12490,12496,12498,12500,12502,12508,12532,12548,12556,12558,12622,12622,12628,12630,12632,7596,12660,12674,12730,12794,12802,12816,12848,12856,12860,12880,12882,12950,13210,13210,13354,13356,13360,13362,13370,13416,13422,13454,13470,13470,13488,13516,13534,13540,4632,13649,13705,13733,13765,13851,14074,14166,13777,14282,14282,14328,14356,12026,14458,14492,14504,xt,14528,14576,14674,14678,14770,14778,8702,14998,15024,14656,15040,15086,671,15166,15170,15196,15300,15364,15406,15444,15458,15496,15526,15532,15556,15564,15586,15612,15556,2074,2074,15678,15706,15708,15712,15738,15706,15778,15192,15818,3890,1288,7848,7848,2074,15890,15944,2074,15444,777,3,16024,16028,16146,16154,15192,16188,16200,3,16264,16270,8702,16278,16294,3,3,16348,16426
) ) ) LIMIT 0, 151 [nativecode=1054 ** Unknown column 'xt' in
'where clause']
[to_string] => [db_error: message="DB Error: no such field"
code=-19 mode=callback callback=CRM_Core_Error::handle prefix=""
info="SELECT contact_a.id as contact_id, 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.preferred_mail_format as `preferred_mail_format`,
civicrm_email.id as email_id, civicrm_email.email as `email`,
civicrm_email.on_hold as `on_hold` FROM civicrm_contact contact_a
LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id
AND civicrm_email.is_primary = 1) WHERE ( ( contact_a.id IN
(12046,8738,12116,12144,12194,12202,12276,7076,12290,12328,12336,12346,12358,1368,8702,12414,12426,12438,12464,12472,12478,12490,12496,12498,12500,12502,12508,12532,12548,12556,12558,12622,12622,12628,12630,12632,7596,12660,12674,12730,12794,12802,12816,12848,12856,12860,12880,12882,12950,13210,13210,13354,13356,13360,13362,13370,13416,13422,13454,13470,13470,13488,13516,13534,13540,4632,13649,13705,13733,13765,13851,14074,14166,13777,14282,14282,14328,14356,12026,14458,14492,14504,xt,14528,14576,14674,14678,14770,14778,8702,14998,15024,14656,15040,15086,671,15166,15170,15196,15300,15364,15406,15444,15458,15496,15526,15532,15556,15564,15586,15612,15556,2074,2074,15678,15706,15708,15712,15738,15706,15778,15192,15818,3890,1288,7848,7848,2074,15890,15944,2074,15444,777,3,16024,16028,16146,16154,15192,16188,16200,3,16264,16270,8702,16278,16294,3,3,16348,16426
) ) ) LIMIT 0, 151 [nativecode=1054 ** Unknown column 'xt' in
'where clause']"]
)

Comments

Amazon’s picture

Go to CiviMember, then select pending memberships. Then set the date range back to July 2009. Then select an action on the search results. Select action: send email to group.

deviantintegral’s picture

Status: Active » Fixed

This looks to have been fixed in a CiviCRM update as I can't replicate this any more.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Project: Drupal.org infrastructure » Drupal Association Project(s)
Component: association.drupal.org » Other