CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Issues with Custom Data Date Fields
Pages: [1] 2

Author Topic: Issues with Custom Data Date Fields  (Read 2804 times)

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Issues with Custom Data Date Fields
May 06, 2012, 06:51:00 pm
Hey Guys, we're doing a pretty massive dbase installation with many "individual custom data fields date fields" however we seem to be bumping into some sort of mySQL limit where each additional field throws an error that is of the type "Sorry. A non-recoverable error has occurred.
DB Error: unknown error" and you can't click to see the details. When clicking view page source, we see things along the lines of "Database Error Code: Too many keys specified; max 64 keys allowed, 1069" it seems this occurs even more when we use the "Save and New" key. Overall, there's probably 30 or so custom data date fields. Weirder still, even tho it throws the error, it actually places the field in the data set visible on the front end at /civicrm/admin/custom/group?reset=1 -- anyone have any clue what's up? at this point we're wondering if there;s some general weirdness with save and new function or if we somehow corrupted the install? Any help greatly appreciated!

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Re: Issues with Custom Data Date Fields
May 06, 2012, 06:53:00 pm
btw, we are using civi 4.0.5

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Issues with Custom Data Date Fields
May 07, 2012, 07:19:32 am

You might want to rethink your custom groups and probably create multiple custom groups with fields split across the various custom groups.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issues with Custom Data Date Fields
May 07, 2012, 07:32:17 am
I do have a site with over 100 custom fields in one group and a total of nearly 1000 custom fields spread over 20+ groups. But not many are date fields.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Re: Issues with Custom Data Date Fields
May 07, 2012, 12:03:59 pm
we'll try creating a new custom data field set as you advised here and report the results back ...H

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Re: Issues with Custom Data Date Fields
May 09, 2012, 02:11:08 pm
Reporting back on this...we haven't had any luck with it...is there something inherently larger/bigger about calls for date fields? thanks guys!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Issues with Custom Data Date Fields
May 09, 2012, 03:06:10 pm

Might want to give more details on what u tried.

How big does the custom group get before it starts failing?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Issues with Custom Data Date Fields
May 09, 2012, 03:10:09 pm
we had an issue where we had a lot of fields and were hitting limits - see here - http://forum.civicrm.org/index.php/topic,23112.msg97435.html#msg97435
In the end i moved the fields so instead of 150 or so in one group, i had no more than 12 which seemed to be the limit at which I could still throw as much text as i liked in to each field and it didn't collapse under the weight.

So our problem had no relation to 'date' fields.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Re: Issues with Custom Data Date Fields
May 09, 2012, 03:20:53 pm
this helps...thanks Peter...we're going to try breaking them out into separate custom data sets...an added complication is that it isn't letting us delete the fields as we go, deleting simply throws errors of the non-recoverable variety...so it's a bit of a loop. you create the date fields, hit a certain mysql limit, get an error messge pertaining to the keys, go to delete, then get the same error. thanks for the help we're working on it...H

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Issues with Custom Data Date Fields
May 09, 2012, 03:23:21 pm
why delete - why not just 'move' the fields to the new group?

as suggested on skype
- create new field Group
- add a data field
- test
- add another
- test
- repeat till you get to the 'limit
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Re: Issues with Custom Data Date Fields
May 09, 2012, 03:43:52 pm
hmmm. Actually, unless we disable entirely the troubled set of existing "members" custom data fields, civi stops functioning, that is doing a routine search, then clicking any civi record will throw the error,  most recently we get things like unknown column and col exceeded limit...so we're not sure how to add or move the fields into a different custom grouping without deleting them as for each field it says its already in the database (even if we delete) and we can't add it -- there's probably an easy way to move custom data fields between groups as Lobo suggests, above, but we're not seeing it. Are we missing something obvious?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Issues with Custom Data Date Fields
May 09, 2012, 04:18:42 pm
what version are you on - oh 4.0.5 - upgrade upgrade upgrade - then you can move fields between groups with more ease
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Issues with Custom Data Date Fields
May 09, 2012, 07:45:01 pm

Your best bet would be to do into the DB and delete the database entries and values for the offending table.

I suspect once a table is broken, we cant really recover from the broken state :(

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Hardwick

  • I post frequently
  • ***
  • Posts: 124
  • Karma: 1
  • CiviCRM version: 4.0.5
Re: Issues with Custom Data Date Fields
May 09, 2012, 08:04:12 pm
We managed to get to approx 60 custom data fields before we saw the issue. We were just powering through, hitting the "save and new " button when we saw it, which suggests the limitation. Our only hesitation in simply starting over is the lost time creating the existing fields (10 or so hrs)  i should add some of them have up to 70 multiple choice options, for example a "county" field, and the reservation that we would hit the same limitation again, having started over. manually deleting them in the dbase, tho it cleared things up in the short-temr doesnt seem to provide long term relief. H

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issues with Custom Data Date Fields
May 10, 2012, 05:04:53 am
Quote from: Donald Lobo on May 09, 2012, 07:45:01 pm
I suspect once a table is broken, we cant really recover from the broken state :(

That's right. I have had this problem--where a field create attempt fails. The field record may be created in civicrm_custom_field but the actual field wasn't made in the custom table. In such cases, or similar cases, manual intervention is the only way.

Hardwick, just to mention, had you created new fields in a new Custom Data Group, you could assign to those an existing option list without having to recreate that list.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Issues with Custom Data Date Fields

This forum was archived on 2017-11-26.