Author Topic: Adding 'Money' type Custom Field after Some contacts imported crashes DB set. (Read 504 times)

Richard416282 · April 17, 2014, 02:42:27 pm

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 · April 17, 2014, 03:30:33 pm

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 · June 07, 2014, 05:33:04 am

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 · June 07, 2014, 01:11:43 pm

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..

CiviCRM Community Forums (archive)

News:

Poll

Did you get a 'DB Error:no such field' as well?

Author Topic: Adding 'Money' type Custom Field after Some contacts imported crashes DB set. (Read 504 times)

Richard416282

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

Dave Greenberg

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

Richard416282

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

Richard416282

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