Author Topic: Database Error Code: Unknown column 'contribution.honor_contact_id' (Read 462 times)

stigmil · September 18, 2014, 11:00:52 am

Database error after upgrading Joomla Civi from 4.4.6 to 4.4.7. Upgrade all seemed to go fine. But now the quicksearch box on the Civi Home Page doesn't return any search results. When I use the search tab, it finds records as expected but when I click on a contact to see the detailed record I get this error:

Code: [Select]

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'contribution.honor_contact_id' in 'where 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 count( x.id ) count FROM ( 
      SELECT contribution.id AS id
      FROM civicrm_contribution contribution
      WHERE contribution.is_test = 0 AND contribution.contact_id = 49  UNION 
      SELECT contribution.id
      FROM civicrm_contribution contribution INNER JOIN civicrm_contribution_soft softContribution
      ON ( contribution.id = softContribution.contribution_id )
      WHERE contribution.is_test = 0 AND softContribution.contact_id = 49  UNION 
      SELECT contribution.id
      FROM civicrm_contribution contribution
      WHERE contribution.is_test = 0 AND contribution.honor_contact_id = 49 ) x [nativecode=1054 ** Unknown column 'contribution.honor_contact_id' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT count( x.id ) count FROM ( 
      SELECT contribution.id AS id
      FROM civicrm_contribution contribution
      WHERE contribution.is_test = 0 AND contribution.contact_id = 49  UNION 
      SELECT contribution.id
      FROM civicrm_contribution contribution INNER JOIN civicrm_contribution_soft softContribution
      ON ( contribution.id = softContribution.contribution_id )
      WHERE contribution.is_test = 0 AND softContribution.contact_id = 49  UNION 
      SELECT contribution.id
      FROM civicrm_contribution contribution
      WHERE contribution.is_test = 0 AND contribution.honor_contact_id = 49 ) x [nativecode=1054 ** Unknown column 'contribution.honor_contact_id' 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 count( x.id ) count FROM ( 
      SELECT contribution.id AS id
      FROM civicrm_contribution contribution
      WHERE contribution.is_test = 0 AND contribution.contact_id = 49  UNION 
      SELECT contribution.id
      FROM civicrm_contribution contribution INNER JOIN civicrm_contribution_soft softContribution
      ON ( contribution.id = softContribution.contribution_id )
      WHERE contribution.is_test = 0 AND softContribution.contact_id = 49  UNION 
      SELECT contribution.id
      FROM civicrm_contribution contribution
      WHERE contribution.is_test = 0 AND contribution.honor_contact_id = 49 ) x [nativecode=1054 ** Unknown column 'contribution.honor_contact_id' in 'where clause']"]
)

Any ideas?

Pre-history: I had previously tried to upgrade from 4.4.6 to 4.5.0 but the upgrade failed so I restored the whole site (including database) from a backup made immediately before the failed upgrade.

redgar · September 18, 2014, 02:00:53 pm

I'm at 4.4.6 and my contribution table has an honor_contact_id column. My guess is that a previous upgrade went sour and your database didn't have that column added and it hasn't caused any troubles until now.

Here is what I have for that table at 4.4.6:

#	Name	Type	Collation	Attributes	Null	Default	Extra
1	id	int(10)		UNSIGNED	No	None	AUTO_INCREMENT
2	contact_id	int(10)		UNSIGNED	No	None
3	financial_type_id	int(10)		UNSIGNED	Yes	NULL
4	contribution_page_id	int(10)		UNSIGNED	Yes	NULL
5	payment_instrument_id	int(10)		UNSIGNED	Yes	NULL
6	receive_date	datetime			Yes	NULL
7	non_deductible_amount	decimal(20,2)			Yes	0.00
8	total_amount	decimal(20,2)			No	None
9	fee_amount	decimal(20,2)			Yes	NULL
10	net_amount	decimal(20,2)			Yes	NULL
11	trxn_id	varchar(255)	latin1_swedish_ci		Yes	NULL
12	invoice_id	varchar(255)	latin1_swedish_ci		Yes	NULL
13	currency	varchar(3)	utf8_unicode_ci		Yes	NULL
14	cancel_date	datetime			Yes	NULL
15	cancel_reason	text	latin1_swedish_ci		Yes	NULL
16	receipt_date	datetime			Yes	NULL
17	thankyou_date	datetime			Yes	NULL
18	source	varchar(255)	latin1_swedish_ci		Yes	NULL
19	amount_level	text	latin1_swedish_ci		Yes	NULL
20	contribution_recur_id	int(10)		UNSIGNED	Yes	NULL
21	honor_contact_id	int(10)		UNSIGNED	Yes	NULL
22	is_test	tinyint(4)			Yes	0
23	is_pay_later	tinyint(4)			Yes	0
24	contribution_status_id	int(10)		UNSIGNED	Yes	1
25	honor_type_id	int(10)		UNSIGNED	Yes	NULL
26	address_id	int(10)		UNSIGNED	Yes	NULL
27	check_number	varchar(255)	latin1_swedish_ci		Yes	NULL
28	campaign_id	int(10)		UNSIGNED	Yes	NULL

stigmil · September 18, 2014, 03:01:56 pm

Thanks - I've rolled back to 4.4.6 and my contribution table has the same structure as yours - including the 'honor_contact_id' column. So now I'm even more confused!

CiviCRM Community Forums (archive)

News:

Author Topic: Database Error Code: Unknown column 'contribution.honor_contact_id' (Read 462 times)

stigmil

Database Error Code: Unknown column 'contribution.honor_contact_id'

redgar

Re: Database Error Code: Unknown column 'contribution.honor_contact_id'

stigmil

Re: Database Error Code: Unknown column 'contribution.honor_contact_id'