Answers.Body: <p>Following on from the comments:</p>
  
  <p>Sorry I don't speak Turkish but I put your comment into Bing translate and the short answer is "yes". The error happens when you have <strong>changed a relationship type</strong> (which happens automatically if you change the language) and you're using CiviCase in non-english. So the temporary options are:</p>
  
  <ul>
  <li>Disable civicase or only use english. (Not the best option.)</li>
  <li>Put the relationship type back to the english version. (Also not good.)</li>
  <li>If you don't have many relationships entered yet you can delete all the relationships, delete the relationship type and recreate a new one, then update your case types, then add your relationships again.</li>
  <li>Wait until 5.20.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-20T07:50:22.847Z
Answers.Text: Sorry. As a result of a thoughtfulness I wrote in Turkish. I just updated the comment in English. :)
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-20T07:51:32.283Z
Answers.Text: There are over 400 thousand events. Updating them and using the language in English are not suitable for me. It's best to wait at 5.20. :)
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-20T08:17:15.007Z
Answers.Text: Did you try disabling the standard core case types? If you are lucky that might fix the immediate DB error showing up.....
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-20T09:22:27.030Z
Answers.Text: Hi Erik. I made the language again in English to implement the proposal. Disable Medical Examination, Mental Health Examination, Safe Temporary Shelter, Income and Benefit Balance,
  Long Term Shelter Plan
  I have disabled the standardized case types. Other than these cannot be disabled already. Then I activated the CiviCase component. I did the Cleanup Caches and Update Paths and I got the same error when I tried. So did not solve the problem. So I get this error as long as CiviCase is active.
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-20T06:56:58.397Z
Answers.LastActivityDate: 2019-11-20T06:56:58.397Z
Answers.UserDisplayName: Demerit
Body: <p><a href="https://civicrm.stackexchange.com/questions/33765/civicrm-api3-exception-db-error-constraint-violation">CiviCRM_API3_Exception: &quot;DB Error: constraint violation&quot;</a> I have fixed these problem by updating one by one from 5.14.1 to 5.19.1 but now I have got new problem :) In the new version I cant install/uninstall and update any extention. I got the following error on screen:</p>
  
  <p><a href="https://kvk.cagrikaydi.net/images/15742291695532737200066310331317.jpg" rel="nofollow noreferrer"><img src="https://kvk.cagrikaydi.net/images/15742291695532737200066310331317.jpg" alt="enter image description here"></a></p>
  
  <p>But I realised when I click back than is the update or install/uninstall is done. But everytime when I try I get the same error. Anybody who knows the reason of the error showing ?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-19T21:29:40.233Z
Comments.Text: Based on the other post there could be multiple problems, but if you have CiviCase enabled then this might be the same as https://lab.civicrm.org/dev/core/issues/329 which can happen if the site is non-english. If so, that will be fixed in 5.20.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-20T07:47:00.507Z
Comments.Text: Hi Demerit. I use the system in Turkish language. I did the language in English, then I disabled CiviCase. Caches and Update Paths cleaned up. I received no errors when I update, uninstall, or install any plug-ins. Then the Turkish language investment. I didn't get the error again. Finally I've activated CiviCase. When I checked, I saw that the error continued in the same way. Is this a problem with the CiviCase?
Comments.UserDisplayName: Fatih ATEŞ
Tags: <extension><joomla><error><install>
Title: CiviCRM_API3_Exception: "API error: DB Error: already exists"
ThreadText: # CiviCRM_API3_Exception: "API error: DB Error: already exists"
  
  (Asked by: username_0 on 2019-11-19)
  
  [CiviCRM\_API3\_Exception: "DB Error: constraint violation"](https://civicrm.stackexchange.com/questions/33765/civicrm-api3-exception-db-error-constraint-violation) I have fixed these problem by updating one by one from 5.14.1 to 5.19.1 but now I have got new problem :) In the new version I cant install/uninstall and update any extention. I got the following error on screen:
  
  [![enter image description here](https://kvk.cagrikaydi.net/images/15742291695532737200066310331317.jpg)](https://kvk.cagrikaydi.net/images/15742291695532737200066310331317.jpg)
  
  But I realised when I click back than is the update or install/uninstall is done. But everytime when I try I get the same error. Anybody who knows the reason of the error showing ?
  
  **Tags:** extension, joomla, error, install
  
  > **Comments:**
  > **username_1**: Based on the other post there could be multiple problems, but if you have CiviCase enabled then this might be the same as https://lab.civicrm.org/dev/core/issues/329 which can happen if the site is non-english. If so, that will be fixed in 5.20.  
  > **username_0**: Hi username_1. I use the system in Turkish language. I did the language in English, then I disabled CiviCase. Caches and Update Paths cleaned up. I received no errors when I update, uninstall, or install any plug-ins. Then the Turkish language investment. I didn't get the error again. Finally I've activated CiviCase. When I checked, I saw that the error continued in the same way. Is this a problem with the CiviCase?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-11-20. Score: 2
  
  Following on from the comments:
  
  Sorry I don't speak Turkish but I put your comment into Bing translate and the short answer is "yes". The error happens when you have **changed a relationship type** (which happens automatically if you change the language) and you're using CiviCase in non-english. So the temporary options are:
  
  * Disable civicase or only use english. (Not the best option.)
  * Put the relationship type back to the english version. (Also not good.)
  * If you don't have many relationships entered yet you can delete all the relationships, delete the relationship type and recreate a new one, then update your case types, then add your relationships again.
  * Wait until 5.20.
  
  > **Comments:**
  > **username_0**: Sorry. As a result of a thoughtfulness I wrote in Turkish. I just updated the comment in English. :)  
  > **username_0**: There are over 400 thousand events. Updating them and using the language in English are not suitable for me. It's best to wait at 5.20. :)  
  > **username_2**: Did you try disabling the standard core case types? If you are lucky that might fix the immediate DB error showing up.....  
  > **username_0**: Hi Erik. I made the language again in English to implement the proposal. Disable Medical Examination, Mental Health Examination, Safe Temporary Shelter, Income and Benefit Balance, Long Term Shelter Plan I have disabled the standardized case types. Other than these cannot be disabled already. Then I activated the CiviCase component. I did the Cleanup Caches and Update Paths and I got the same error when I tried. So did not solve the problem. So I get this error as long as CiviCase is active.  
  
  ---
  
  