CiviCRM Community Forums (archive)

Hard to set up on Sandbox. This problem has occured twice, though the first one seems to have resolved itself overnight. No idea what is going on.

We have a checkbox field in a profile in a Contribution page. Since adding this field (it only has a single checkbox) we are getting an error when it we move to the third step ie Processing. When I disable the field, or replace it with a radio button I have no problems. Just the single checkbox seems to throw it. Maybe it is how I am holding my tongue? Maybe it will have sorted itself overnight again. Here is the report in case it makes sense to anyone.

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO custom_value_1_Special_Data  SET `supporter_enquiry` = '', domain_id = 1, entity_id = 13242  [nativecode=1062 ** Duplicate entry '1-13242' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO custom_value_1_Special_Data  SET `supporter_enquiry` = '', domain_id = 1, entity_id = 13242  [nativecode=1062 ** Duplicate entry '1-13242' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO custom_value_1_Special_Data  SET `supporter_enquiry` = '', domain_id = 1, entity_id = 13242  [nativecode=1062 ** Duplicate entry '1-13242' for key 2]"]
)

Actually the problem is that when using a single checkbox and then filling out the profile as a non-logged in user, it throws a wobbly. Again not sure if i can replicate in Sandbox.
Okay I tried but having a single checkbox in a profile in which I also had Email First + Last I was able to update that data.

Can anyone offer any advice based on the error report above?