default_amount_id error

[rrcjab]

Just installed 1.8 on drupal 5.2 and am getting the following error when I hit "submit" on the first (title and settings) page wihle trying to create a new contribution page.


     Sorry. A non-recoverable error has occurred.

    Database Error Code: Field 'default_amount_id' doesn't have a default value, 1364

    Return to home page.

Code: [Select]


Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contribution_page (domain_id , title , intro_text , contribution_type_id , is_credit_card_only , goal_amount , is_active , footer_text , is_thermometer , thermometer_title , honor_block_is_active , honor_block_title , honor_block_text ) VALUES ( 1 , 'Naming and Recognition Opportunities' , 'We offer a wide range of naming opportunities, which will allow donors to permanently associate his or  her own name, a corporate name, honour a family member, or a friend with a section of our new building. We would be pleased to discuss any of the following opportunities.' ,  1 ,  0 ,  NULL ,  1 , 'Thank you for considering these opportunities. Your gift may be made by a variety of terms including cash and/or credit card. Pledges may be made over a five year period. We appreciate your support of Dom Lipa.' ,  0 ,  NULL ,  1 , 'Honoree Informtaion' , 'If you would like to specify a person whom you are honoring with their gift, check this box. An optional Honoree section will be included in the form. Honoree information is automatically saved and linked with the contribution record.' )  [nativecode=1364 ** Field 'default_amount_id' doesn't have a default value]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contribution_page (domain_id , title , intro_text , contribution_type_id , is_credit_card_only , goal_amount , is_active , footer_text , is_thermometer , thermometer_title , honor_block_is_active , honor_block_title , honor_block_text ) VALUES ( 1 , 'Naming and Recognition Opportunities' , 'We offer a wide range of naming opportunities, which will allow donors to permanently associate his or  her own name, a corporate name, honour a family member, or a friend with a section of our new building. We would be pleased to discuss any of the following opportunities.' ,  1 ,  0 ,  NULL ,  1 , 'Thank you for considering these opportunities. Your gift may be made by a variety of terms including cash and/or credit card. Pledges may be made over a five year period. We appreciate your support of Dom Lipa.' ,  0 ,  NULL ,  1 , 'Honoree Informtaion' , 'If you would like to specify a person whom you are honoring with their gift, check this box. An optional Honoree section will be included in the form. Honoree information is automatically saved and linked with the contribution record.' )  [nativecode=1364 ** Field 'default_amount_id' doesn't have a default value]

    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contribution_page (domain_id , title , intro_text , contribution_type_id , is_credit_card_only , goal_amount , is_active , footer_text , is_thermometer , thermometer_title , honor_block_is_active , honor_block_title , honor_block_text ) VALUES ( 1 , 'Naming and Recognition Opportunities' , 'We offer a wide range of naming opportunities, which will allow donors to permanently associate his or  her own name, a corporate name, honour a family member, or a friend with a section of our new building. We would be pleased to discuss any of the following opportunities.' ,  1 ,  0 ,  NULL ,  1 , 'Thank you for considering these opportunities. Your gift may be made by a variety of terms including cash and/or credit card. Pledges may be made over a five year period. We appreciate your support of Dom Lipa.' ,  0 ,  NULL ,  1 , 'Honoree Informtaion' , 'If you would like to specify a person whom you are honoring with their gift, check this box. An optional Honoree section will be included in the form. Honoree information is automatically saved and linked with the contribution record.' )  [nativecode=1364 ** Field 'default_amount_id' doesn't have a default value]"]
)


thanks,
John
[/code]

[Donald Lobo]

This is a similar problem to:

http://forum.civicrm.org/index.php/topic,1083.msg4642.html#msg4642

and the solution is the same (set sql_mode to the null string). We'll fix these issues for the 2.0.

thanx

lobo

[rrcjab]

Thank you. (I did try to search before posting).

That worked perfectly.

John