Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-6347

Error while register an participant for a payed event.

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.1, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 3.1.5
    • Fix Version/s: 3.1.6
    • Component/s: CiviEvent
    • Labels:
      None

      Description

      @me is german. so our prices/fees are formatted by other rules than the standard american/us.
      The american '5.49' is in german '5,49' - you see the difference? it's the comma for decimal instead of an point.

      When register an new participant an the summary event-fee is with decimal characters i get the following error:

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

      [code] => -22
      [message] => DB Error: value count on row
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_participant (contact_id , event_id , status_id , role_id , register_date , source , fee_level , is_test , is_pay_later , fee_amount , discount_id , fee_currency ) VALUES ( 1 , 2 , 5 , 1 , 20100611195625 , 'Online Veranstaltungs Anmeldung: Blutgier - Mit Nachtgestalten unterwegs' , 'Normalpreis - 2Ermäßigt - 1' , 1 , 1 , 39,5 , NULL , 'EUR' ) [nativecode=1136 ** Column count doesn't match value count at row 1]
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_participant (contact_id , event_id , status_id , role_id , register_date , source , fee_level , is_test , is_pay_later , fee_amount , discount_id , fee_currency ) VALUES ( 1 , 2 , 5 , 1 , 20100611195625 , blablabla' , 'Normalprice - 2cheaper - 1' , 1 , 1 , 39,5 , NULL , 'EUR' ) [nativecode=1136 ** Column count doesn't match value count at row 1]
      [to_string] => [db_error: message="DB Error: value count on row" code=22 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_participant (contact_id , event_id , status_id , role_id , register_date , source , fee_level , is_test , is_pay_later , fee_amount , discount_id , fee_currency ) VALUES ( 1 , 2 , 5 , 1 , 20100611195625 , 'blablabla' , 'Normalprice 2cheaper - 1' , 1 , 1 , 39,5 , NULL , 'EUR' ) [nativecode=1136 ** Column count doesn't match value count at row 1]"]
      )

      The error comes from an insert-sql-command. the event-fee is formated in german while the insert is running. but a comma is the sql seperator for parameters. so the solution is realy simple: i only have to change the decimal-sign in the fee_amount parameter.

      But i don't know
      a) why here doesn't comes the language transformation
      b) where to fix that

      And like all the other bug's i need an fast workaround - please

      Greetings

      BannZoid

        Attachments

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              bannzoid Felix Staab
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 55 minutes
                55m
                Remaining:
                Remaining Estimate - 55 minutes
                55m
                Logged:
                Time Spent - Not Specified
                Not Specified