Skip to content

Instantly share code, notes, and snippets.

@Edzelopez

Edzelopez/DB Error

Created March 17, 2020 10:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Edzelopez/2306b9c797c2ea24af0ef1202ffb2fa8 to your computer and use it in GitHub Desktop.
Save Edzelopez/2306b9c797c2ea24af0ef1202ffb2fa8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DB Error
Database Error Code: Unknown column 'civicrm_contribution_soft.soft_credit_type_id' in 'on clause', 1054
Additional 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.contact_type as `contact_type`, contact_a.contact_sub_type as `contact_sub_type`, contact_a.sort_name as `sort_name`, contribution_softcredit_type.id as tion_softcredit_type_id, (CASE
WHEN contact_a.id = 36 THEN 0
WHEN contact_a.id = 131 THEN 1
WHEN contact_a.id = 97 THEN 2
WHEN contact_a.id = 202 THEN 3
WHEN contact_a.id = 51 THEN 4
WHEN contact_a.id = 113 THEN 5
WHEN contact_a.id = 45 THEN 6
WHEN contact_a.id = 106 THEN 7
WHEN contact_a.id = 167 THEN 8
WHEN contact_a.id = 104 THEN 9
WHEN contact_a.id = 116 THEN 10
WHEN contact_a.id = 198 THEN 11
WHEN contact_a.id = 41 THEN 12
WHEN contact_a.id = 138 THEN 13
WHEN contact_a.id = 19 THEN 14
WHEN contact_a.id = 16 THEN 15
WHEN contact_a.id = 91 THEN 16
WHEN contact_a.id = 15 THEN 17
WHEN contact_a.id = 35 THEN 18
WHEN contact_a.id = 204 THEN 19
WHEN contact_a.id = 187 THEN 20
WHEN contact_a.id = 152 THEN 21
WHEN contact_a.id = 28 THEN 22
WHEN contact_a.id = 154 THEN 23
WHEN contact_a.id = 24 THEN 24
WHEN contact_a.id = 26 THEN 25
WHEN contact_a.id = 163 THEN 26
WHEN contact_a.id = 105 THEN 27
WHEN contact_a.id = 110 THEN 28
WHEN contact_a.id = 4 THEN 29
WHEN contact_a.id = 52 THEN 30
WHEN contact_a.id = 176 THEN 31
WHEN contact_a.id = 121 THEN 32
WHEN contact_a.id = 64 THEN 33
WHEN contact_a.id = 114 THEN 34
WHEN contact_a.id = 126 THEN 35
WHEN contact_a.id = 1 THEN 36
WHEN contact_a.id = 77 THEN 37
WHEN contact_a.id = 66 THEN 38
WHEN contact_a.id = 194 THEN 39
WHEN contact_a.id = 71 THEN 40
WHEN contact_a.id = 38 THEN 41
WHEN contact_a.id = 199 THEN 42
WHEN contact_a.id = 203 THEN 43
WHEN contact_a.id = 25 THEN 44
WHEN contact_a.id = 2 THEN 45
WHEN contact_a.id = 206 THEN 46
WHEN contact_a.id = 208 THEN 47
WHEN contact_a.id = 207 THEN 48
WHEN contact_a.id = 205 THEN 49
END
) AS _wgt FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id LEFT JOIN civicrm_option_group option_group_contribution_softcredit_type ON
(option_group_contribution_softcredit_type.name = 'soft_credit_type') LEFT JOIN civicrm_option_value contribution_softcredit_type ON
( civicrm_contribution_soft.soft_credit_type_id = contribution_softcredit_type.value
AND option_group_contribution_softcredit_type.id = contribution_softcredit_type.option_group_id ) WHERE (contact_a.is_deleted = 0) AND contact_a.id IN (36,131,97,202,51,113,45,106,167,104,116,198,41,138,19,16,91,15,35,204,187,152,28,154,24,26,163,105,110,4,52,176,121,64,114,126,1,77,66,194,71,38,199,203,25,2,206,208,207,205) GROUP BY contact_a.id ORDER BY _wgt [nativecode=1054 ** Unknown column 'civicrm_contribution_soft.soft_credit_type_id' in 'on clause']
[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`, contribution_softcredit_type.id as tion_softcredit_type_id, (CASE
WHEN contact_a.id = 36 THEN 0
WHEN contact_a.id = 131 THEN 1
WHEN contact_a.id = 97 THEN 2
WHEN contact_a.id = 202 THEN 3
WHEN contact_a.id = 51 THEN 4
WHEN contact_a.id = 113 THEN 5
WHEN contact_a.id = 45 THEN 6
WHEN contact_a.id = 106 THEN 7
WHEN contact_a.id = 167 THEN 8
WHEN contact_a.id = 104 THEN 9
WHEN contact_a.id = 116 THEN 10
WHEN contact_a.id = 198 THEN 11
WHEN contact_a.id = 41 THEN 12
WHEN contact_a.id = 138 THEN 13
WHEN contact_a.id = 19 THEN 14
WHEN contact_a.id = 16 THEN 15
WHEN contact_a.id = 91 THEN 16
WHEN contact_a.id = 15 THEN 17
WHEN contact_a.id = 35 THEN 18
WHEN contact_a.id = 204 THEN 19
WHEN contact_a.id = 187 THEN 20
WHEN contact_a.id = 152 THEN 21
WHEN contact_a.id = 28 THEN 22
WHEN contact_a.id = 154 THEN 23
WHEN contact_a.id = 24 THEN 24
WHEN contact_a.id = 26 THEN 25
WHEN contact_a.id = 163 THEN 26
WHEN contact_a.id = 105 THEN 27
WHEN contact_a.id = 110 THEN 28
WHEN contact_a.id = 4 THEN 29
WHEN contact_a.id = 52 THEN 30
WHEN contact_a.id = 176 THEN 31
WHEN contact_a.id = 121 THEN 32
WHEN contact_a.id = 64 THEN 33
WHEN contact_a.id = 114 THEN 34
WHEN contact_a.id = 126 THEN 35
WHEN contact_a.id = 1 THEN 36
WHEN contact_a.id = 77 THEN 37
WHEN contact_a.id = 66 THEN 38
WHEN contact_a.id = 194 THEN 39
WHEN contact_a.id = 71 THEN 40
WHEN contact_a.id = 38 THEN 41
WHEN contact_a.id = 199 THEN 42
WHEN contact_a.id = 203 THEN 43
WHEN contact_a.id = 25 THEN 44
WHEN contact_a.id = 2 THEN 45
WHEN contact_a.id = 206 THEN 46
WHEN contact_a.id = 208 THEN 47
WHEN contact_a.id = 207 THEN 48
WHEN contact_a.id = 205 THEN 49
END
) AS _wgt FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id LEFT JOIN civicrm_option_group option_group_contribution_softcredit_type ON
(option_group_contribution_softcredit_type.name = 'soft_credit_type') LEFT JOIN civicrm_option_value contribution_softcredit_type ON
( civicrm_contribution_soft.soft_credit_type_id = contribution_softcredit_type.value
AND option_group_contribution_softcredit_type.id = contribution_softcredit_type.option_group_id ) WHERE (contact_a.is_deleted = 0) AND contact_a.id IN (36,131,97,202,51,113,45,106,167,104,116,198,41,138,19,16,91,15,35,204,187,152,28,154,24,26,163,105,110,4,52,176,121,64,114,126,1,77,66,194,71,38,199,203,25,2,206,208,207,205) GROUP BY contact_a.id ORDER BY _wgt [nativecode=1054 ** Unknown column 'civicrm_contribution_soft.soft_credit_type_id' in 'on 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.contact_type as `contact_type`, contact_a.contact_sub_type as `contact_sub_type`, contact_a.sort_name as `sort_name`, contribution_softcredit_type.id as tion_softcredit_type_id, (CASE
WHEN contact_a.id = 36 THEN 0
WHEN contact_a.id = 131 THEN 1
WHEN contact_a.id = 97 THEN 2
WHEN contact_a.id = 202 THEN 3
WHEN contact_a.id = 51 THEN 4
WHEN contact_a.id = 113 THEN 5
WHEN contact_a.id = 45 THEN 6
WHEN contact_a.id = 106 THEN 7
WHEN contact_a.id = 167 THEN 8
WHEN contact_a.id = 104 THEN 9
WHEN contact_a.id = 116 THEN 10
WHEN contact_a.id = 198 THEN 11
WHEN contact_a.id = 41 THEN 12
WHEN contact_a.id = 138 THEN 13
WHEN contact_a.id = 19 THEN 14
WHEN contact_a.id = 16 THEN 15
WHEN contact_a.id = 91 THEN 16
WHEN contact_a.id = 15 THEN 17
WHEN contact_a.id = 35 THEN 18
WHEN contact_a.id = 204 THEN 19
WHEN contact_a.id = 187 THEN 20
WHEN contact_a.id = 152 THEN 21
WHEN contact_a.id = 28 THEN 22
WHEN contact_a.id = 154 THEN 23
WHEN contact_a.id = 24 THEN 24
WHEN contact_a.id = 26 THEN 25
WHEN contact_a.id = 163 THEN 26
WHEN contact_a.id = 105 THEN 27
WHEN contact_a.id = 110 THEN 28
WHEN contact_a.id = 4 THEN 29
WHEN contact_a.id = 52 THEN 30
WHEN contact_a.id = 176 THEN 31
WHEN contact_a.id = 121 THEN 32
WHEN contact_a.id = 64 THEN 33
WHEN contact_a.id = 114 THEN 34
WHEN contact_a.id = 126 THEN 35
WHEN contact_a.id = 1 THEN 36
WHEN contact_a.id = 77 THEN 37
WHEN contact_a.id = 66 THEN 38
WHEN contact_a.id = 194 THEN 39
WHEN contact_a.id = 71 THEN 40
WHEN contact_a.id = 38 THEN 41
WHEN contact_a.id = 199 THEN 42
WHEN contact_a.id = 203 THEN 43
WHEN contact_a.id = 25 THEN 44
WHEN contact_a.id = 2 THEN 45
WHEN contact_a.id = 206 THEN 46
WHEN contact_a.id = 208 THEN 47
WHEN contact_a.id = 207 THEN 48
WHEN contact_a.id = 205 THEN 49
END
) AS _wgt FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id LEFT JOIN civicrm_option_group option_group_contribution_softcredit_type ON
(option_group_contribution_softcredit_type.name = 'soft_credit_type') LEFT JOIN civicrm_option_value contribution_softcredit_type ON
( civicrm_contribution_soft.soft_credit_type_id = contribution_softcredit_type.value
AND option_group_contribution_softcredit_type.id = contribution_softcredit_type.option_group_id ) WHERE (contact_a.is_deleted = 0) AND contact_a.id IN (36,131,97,202,51,113,45,106,167,104,116,198,41,138,19,16,91,15,35,204,187,152,28,154,24,26,163,105,110,4,52,176,121,64,114,126,1,77,66,194,71,38,199,203,25,2,206,208,207,205) GROUP BY contact_a.id ORDER BY _wgt [nativecode=1054 ** Unknown column 'civicrm_contribution_soft.soft_credit_type_id' in 'on clause']"]
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment