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

Total Amount of CiviEvent Registrations are stored incorrectly with Localization pt-BR (and others)

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 3.0, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.0.5, 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

      Using the localization pt-BR:
      I created a event with a value like "0,50" (note, R$ 0,50 = US$ 0.50) and values are correctly showed in Event configuration page.
      But when a user made a registration to this event the payment processor inform a value amount error...
      I verified that the amount received from payment processor is "0,50", which is correct, but the payment processor value amount verification claim that the value must be "5,00" (0,50 x 10).
      So I looked at database and discovered that the value amount (of event) stored at database table "civicrm_contribution" in field "total_amount" is incorrect.
      Is a conversion problem that multiplies the original value by 10 on internationalized instalations of CiviCRM.
      Please see these references for guidance:

      -http://issues.civicrm.org/jira/browse/CRM-4038?focusedCommentId=26829&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_26829

      -http://issues.civicrm.org/jira/browse/CRM-6112

      I tested this with versions 2.2.9, 3.0 and 3.1.5 and all versions have this issue so I suggest a backporting of the solution to all prior versions until 2.2.9, in wich was applied the correction for http://issues.civicrm.org/jira/browse/CRM-4038.

      Thanks

        Attachments

          Activity

            People

            • Assignee:
              shot Piotr Szotkowski
              Reporter:
              fsoares Fernando Soares
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: