Answers.Body: <p>I recommend you take smaller steps, starting with 4.2. You can download the latest version of 4.2 from <a href="http://sourceforge.net/projects/civicrm/files/civicrm-stable/" rel="nofollow">sourceforge</a> (the latest in that series is currently <a href="http://sourceforge.net/projects/civicrm/files/civicrm-stable/4.2.20/" rel="nofollow">4.2.20</a>).</p>
  
  <p>If that upgrade goes ok, then you could proceed to 4.4 (the current LTS) and then up to 4.6.</p>
  
  <p>Remember to backup your database before upgrading, and if the upgrade fails, restore from the backup before trying again.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-25T03:38:34.967Z
Answers.Text: I have treid to update to 4.2.20. from 4.1.5. I immediately get an error that a table exits. I've attached the screen shot to the original question
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-25T14:20:25.687Z
Answers.Text: Are you sure you are starting with a 4.1 db that hasn't already been partially upgraded?
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-26T03:09:32.293Z
Answers.Text: That should not be the case. It is a mysqldump of the current production database.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T02:36:44.837Z
Answers.LastActivityDate: 2015-05-15T02:36:44.837Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>You may not care to keep all the log info in your live database so long as you have a backup. If so, run</p>
  
  <pre><code>TRUNCATE civicrm_log;
  </code></pre>
  
  <p>on your sql db before running the upgrade.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T19:56:54.270Z
Answers.LastActivityDate: 2015-05-15T22:14:07.147Z
Answers.LastEditDate: 2015-05-15T22:14:07.147Z
Answers.UserDisplayName: Joe Murray
Body: <p>Trying to upgrade a 4.1.5 database to 4.2.6. I am getting a constraint violation. See the screenshot.</p>
  
  <p><img src="https://i.sstatic.net/OwThP.png" alt="CiviCRM upgrade tasks"></p>
  
  <p><img src="https://i.sstatic.net/fXWyM.png" alt="Attempted upgrade from 4.1.5 to 4.2.20"></p>
  
Tags: <upgrade>
Title: Upgrading from 4.1.5 database to 4.6.2 failing with constraint violation
ThreadText: # Upgrading from 4.1.5 database to 4.6.2 failing with constraint violation
  
  (Asked by: username_0 on 2015-05-15)
  
  Trying to upgrade a 4.1.5 database to 4.2.6. I am getting a constraint violation. See the screenshot.
  
  ![CiviCRM upgrade tasks](https://i.sstatic.net/OwThP.png)
  
  ![Attempted upgrade from 4.1.5 to 4.2.20](https://i.sstatic.net/fXWyM.png)
  
  **Tags:** upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-05-15. Score: 1
  
  I recommend you take smaller steps, starting with 4.2. You can download the latest version of 4.2 from [sourceforge](http://sourceforge.net/projects/civicrm/files/civicrm-stable/) (the latest in that series is currently [4.2.20](http://sourceforge.net/projects/civicrm/files/civicrm-stable/4.2.20/)).
  
  If that upgrade goes ok, then you could proceed to 4.4 (the current LTS) and then up to 4.6.
  
  Remember to backup your database before upgrading, and if the upgrade fails, restore from the backup before trying again.
  
  > **Comments:**
  > **username_0**: I have treid to update to 4.2.20. from 4.1.5. I immediately get an error that a table exits. I've attached the screen shot to the original question  
  > **username_1**: Are you sure you are starting with a 4.1 db that hasn't already been partially upgraded?  
  > **username_0**: That should not be the case. It is a mysqldump of the current production database.  
  
  ---
  
  ### Answer by username_2 on 2015-05-15. Score: 0
  
  You may not care to keep all the log info in your live database so long as you have a backup. If so, run
  
  ```
  TRUNCATE civicrm_log;
  
  ```
  
  on your sql db before running the upgrade.
  
  
  ---
  
  