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 CiviMember (Moderator: Deepak Srivastava) »
  • Price Set error - unknown column - contribution type id
Pages: [1]

Author Topic: Price Set error - unknown column - contribution type id  (Read 855 times)

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Price Set error - unknown column - contribution type id
October 14, 2011, 01:43:01 am
Not sure where this belongs - and I can't replicate on Demo - but trying to set up a new Price Set for Memberships using a custom Contribution Type I get this error

Database Error Code: Unknown column 'contribution_type_id' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_price_set (name , title , is_active , help_pre , help_post , extends , contribution_type_id ) VALUES ('Journal' , 'Journal' ,  1 ,  NULL ,  NULL , '3' ,  5 )  [nativecode=1054 ** Unknown column 'contribution_type_id' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_price_set (name , title , is_active , help_pre , help_post , extends , contribution_type_id ) VALUES ('Journal' , 'Journal' ,  1 ,  NULL ,  NULL , '3' ,  5 )  [nativecode=1054 ** Unknown column 'contribution_type_id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_price_set (name , title , is_active , help_pre , help_post , extends , contribution_type_id ) VALUES ('Journal' , 'Journal' ,  1 ,  NULL ,  NULL , '3' ,  5 )  [nativecode=1054 ** Unknown column 'contribution_type_id' in 'field list']"]
)

And indeed there is no 'contribution_type_id' field in civicrm_price_set'. This is on 3.4.6

I checked on JIRA but couldn't spot a fix that might explain why it is fine on demo.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Price Set error - unknown column - contribution type id

This forum was archived on 2017-11-26.