Details
Description
When we try to edit the help_text of a price field in a multi lingual setting with English and German, we can't use the Dialog.tpl generated Dual Language popup, as it we get an error:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT help_post_en_US en_US, help_post_de_DE de_DE FROM civicrm_price_field WHERE id = [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
[type] => DB_Error
[user_info] => SELECT help_post_en_US en_US, help_post_de_DE de_DE FROM civicrm_price_field WHERE id = [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT help_post_en_US en_US, help_post_de_DE de_DE FROM civicrm_price_field WHERE id = [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]"]
)
Sadly I am not knowledgable enough to debug this myself, hence my posting without a patch.