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 »
  • Using CiviCase (Moderator: Dave Greenberg) »
  • CiviCase assign new follow up bd error : already exists
Pages: [1]

Author Topic: CiviCase assign new follow up bd error : already exists  (Read 3063 times)

phillipclarke29

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal
  • MySQL version: 5.6
  • PHP version: 5.4.11
CiviCase assign new follow up bd error : already exists
April 24, 2013, 02:49:12 am
Hi everybody

A fairly newbie question here - we have got CiviCase up and running and are tweaking it for our needs.  I was trying to assign a new follow up in a case to somebody else  - so it was open the case - new activity follow up then in the "assign to" box add an individual and I get a

DB Error: already exists

error

I can add a new activity without assign it to somebody else but not with anybody assigned the follow up.

It is a fairly new instance so I imagine it is a problem with initial configuration somewhere but I cannot find any info in the documentation or on this forum

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: CiviCase assign new follow up bd error : already exists
April 24, 2013, 05:54:29 pm
Does the log in sites/default/files/civicrm/ConfigAndLog give any more info?

phillipclarke29

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal
  • MySQL version: 5.6
  • PHP version: 5.4.11
Re: CiviCase assign new follow up bd error : already exists
April 30, 2013, 02:49:02 am
Yes

I have attached the log

I imagine it might be something to do with my xml - will have a further dig

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: CiviCase assign new follow up bd error : already exists
April 30, 2013, 11:05:42 am
Doesn't sound like an xml problem. Does it only happen with case activities or all activities?
What's the actual civicrm version - your profile just lists "4"?
Are there any old entries in the civicrm_activity_assignee table maybe left over from earlier testing?

dips1111

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.31
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.31
  • PHP version: 3.4.10.1deb1
Re: CiviCase assign new follow up bd error : already exists
May 01, 2013, 06:48:53 pm
I am having a similar problem. Shows the above mentioned error when using the field assigned to. Log file attached for info.
Please help
Version details:

CiviCRM version:
    4.31
CMS version:
    Drupal 7.22
MySQL version:
    5.5.31
PHP version:
    3.4.10.1deb1

dips1111

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.31
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.31
  • PHP version: 3.4.10.1deb1
Re: CiviCase assign new follow up bd error : already exists
May 01, 2013, 07:17:00 pm
I would like to confirm that error shows in "out of the box" civicase with standard "housing support' casetype.

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: CiviCase assign new follow up bd error : already exists
May 02, 2013, 08:24:02 am
The stack trace is helpful but I don't see anything obvious. Can you file an issue at issues.civicrm.org and include a link to this thread.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviCase assign new follow up bd error : already exists
May 07, 2013, 07:02:10 pm
For tracking purpose: http://issues.civicrm.org/jira/browse/CRM-12512

Can you try the below patch for the above issue:

https://github.com/civicrm/civicrm-core/pull/680.patch

Kurund
« Last Edit: May 08, 2013, 10:55:12 am by Kurund Jalmi »
Found this reply helpful? Support CiviCRM

phillipclarke29

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal
  • MySQL version: 5.6
  • PHP version: 5.4.11
Re: CiviCase assign new follow up bd error : already exists
May 08, 2013, 05:06:21 am
will try the patch and get back

andyw

  • I post occasionally
  • **
  • Posts: 82
  • Karma: 4
  • CiviCRM version: 4.x
  • CMS version: Drupal, Joomla
Re: CiviCase assign new follow up bd error : already exists
May 16, 2013, 08:07:47 am
Hi Kurund,

We were having the same issue, and can confirm that patch fixes it.

That's using 4.3.2

Many thanks for that - that's totally saved our day!

Andy
Andrew Walker, Developer at Circle Interactive
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCase (Moderator: Dave Greenberg) »
  • CiviCase assign new follow up bd error : already exists

This forum was archived on 2017-11-26.