Adding 'Money' type Custom Field after Some contacts imported crashes DB set.

[Richard416282]

Hi All:

Had a strange problem crop up.

Am using a New Installation of CiviCRM (release 4.4.2), on a Drupal (Bitnami) implementation on a WAMP stack.

Create a NEW Customized Data Field , and SubFields of the Name 'Salary', with the type as 'Money' and 'Text'. as a supplement to Individuals.

The Create New Field, only has the subtype as 'Text'. Not Numeric or Currency ie $xxx [comma]yyy[point]zz

But DB crashes when attempting to view a NEW Individual with the error message

Sorry, we are not able to provide this at the moment.
DB Error:no such field

- - -
Stymied Temporary fix was to go to

Administer >> Adminstrator Console >> Config Checklist

Click on

'Custom Fields',

Select New Custom Field Type,

Click on 'Field Name', where field name(s) were 'Money' type fields, and

DISABLE
field type.

Failed also in sandbox DB (4.5 Sandbox)

http://drupal.sandbox.civicrm.org/civicrm/contact/view?reset=1&cid=298


...over to you to the Bugs team?
-Richard

[Dave Greenberg]

I just added another Money field on the sandbox and it's working fine. I suspect the problem with your fields is that they were created with parenthesis characters in the field label and this seems to have caused a problem in the column name assignment. Can you verify this on your site (i.e. delete your original money fields and add new ones w/o the parenthesis).

If verified, this is definitely a bug (the form rule should prevent assigning a field name with problematic characters) - so please file an issue in the issue tracker - and ideally research a patch for this.

[Richard416282]

Yep. that was it.

The Label name(s) had Parenthesis as part of the label names. [And Square Brackets].

Tried it without Parenthesis, and it worked fine.

Now, the question is, should it allow parenthesis, or give an error, that the user has a no-no character in the field name? instead of a crash of the DB.

Mind you this was with Ver 4.4.2... by now the latest may have fixed the stumble.

[Richard416282]

Yep, In 4.4 it gives the error  , but in the Current Sandbox (4.5 alpha.2) it does not corrupt the database to have a Money Field with Parenthisis in the Name. Not sure about [] Square brackets. though..