Details
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