Answers.Body: <p>That looks very strange error, it appears to be complaining that the created_id column is being created twice, However looking through the upgrade sql files on the github repo, I can only see the one reference to creating created_id column on that table and that is in the 4.6alpha7.sql file. I do note that it came from this JIRA case <a href="https://issues.civicrm.org/jira/browse/CRM-15970" rel="nofollow">https://issues.civicrm.org/jira/browse/CRM-15970</a>. Perhaps you should raise it as a bug in the Jira system but also would recommend looking through the upgrade sql files on your system to see if they match what is in the git repo</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-21T23:29:12.447Z
Answers.LastActivityDate: 2015-04-21T23:29:12.447Z
Answers.UserDisplayName: Seamus Lee
Body: <p>Keep getting this error when Upgrading from 4.4.14 to 4.6.2 directly. I am upgrading based on the civicrm documentation.</p>
  <p>Seems like civicm_mailing_abtest has some error. But I have checked I did not have this table in 4.4 version and it was created during the upgrade process.</p>
  <p>How to deal with it?</p>
  <p><img src="https://i.sstatic.net/mRCGD.jpg" alt="enter image description here" /></p>
  <p>DB Error: unknown error in unknown on line unknown
  nativecode=1060 ** Duplicate column name 'created_id'
  ALTER TABLE civicrm_mailing_abtest ADD COLUMN <code>created_id</code> int unsigned</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-22T16:21:32.193Z
Comments.Text: Did you somehow try to run the upgrade multiple times? Do you have a backup of the original database?
Comments.UserDisplayName: Laryn
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-22T20:20:02.480Z
Comments.Text: Yes, I have backup of original civi db. I tried to installed on multiple instances from backup plus on a brand new install. It always fails! Upgrading from 4.4.14!!
Comments.UserDisplayName: Tapash
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-24T05:17:45.440Z
Comments.Text: Tapash - can you confirm whether you used a MySQL 'DROP DATABASE cividatabasename' and 'CREATE DATABASE cividatabasename' between installs?
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-24T20:35:21.227Z
Comments.Text: I tried upgrade by the civicrm book, nothing otherwise.
Comments.UserDisplayName: Tapash
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-03-28T04:44:07.967Z
Comments.Text: just got exact same on site upgrading from 4.4.19. Same spot 4.6.alpha7 - i didn't set this running so not sure if sql backup had any special treatment. tapash do you recall anything more about getting past this? it is odd since we had done a test upgrade for them many many months ago and i don't see any record of hitting this that time
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-03-28T04:49:38.457Z
Comments.Text: ok. so yep seems to be the case that DROP database didn't happen and yes this was a db that had an upgrade on it over 9 months ago.
Comments.UserDisplayName: petednz - fuzion
Tags: <upgrade><civicrm-home>
Title: "nativecode=1060 ** Duplicate column name 'created_id'" when upgrading from 4.4.14 to 4.6.2
ThreadText: # "nativecode=1060 ** Duplicate column name 'created_id'" when upgrading from 4.4.14 to 4.6.2
  
  (Asked by: username_0 on 2015-04-21)
  
  Keep getting this error when Upgrading from 4.4.14 to 4.6.2 directly. I am upgrading based on the civicrm documentation.
  
  Seems like civicm\_mailing\_abtest has some error. But I have checked I did not have this table in 4.4 version and it was created during the upgrade process.
  
  How to deal with it?
  
  ![enter image description here](https://i.sstatic.net/mRCGD.jpg)
  
  DB Error: unknown error in unknown on line unknown
  nativecode=1060 \*\* Duplicate column name 'created\_id'
  ALTER TABLE civicrm\_mailing\_abtest ADD COLUMN `created_id` int unsigned
  
  **Tags:** upgrade, civicrm-home
  
  > **Comments:**
  > **username_1**: Did you somehow try to run the upgrade multiple times? Do you have a backup of the original database?  
  > **username_0**: Yes, I have backup of original civi db. I tried to installed on multiple instances from backup plus on a brand new install. It always fails! Upgrading from 4.4.14!!  
  > **username_2**: username_0 - can you confirm whether you used a MySQL 'DROP DATABASE cividatabasename' and 'CREATE DATABASE cividatabasename' between installs?  
  > **username_0**: I tried upgrade by the civicrm book, nothing otherwise.  
  > **username_3**: just got exact same on site upgrading from 4.4.19. Same spot 4.6.alpha7 - i didn't set this running so not sure if sql backup had any special treatment. tapash do you recall anything more about getting past this? it is odd since we had done a test upgrade for them many many months ago and i don't see any record of hitting this that time  
  > **username_3**: ok. so yep seems to be the case that DROP database didn't happen and yes this was a db that had an upgrade on it over 9 months ago.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2015-04-21. Score: 2
  
  That looks very strange error, it appears to be complaining that the created\_id column is being created twice, However looking through the upgrade sql files on the github repo, I can only see the one reference to creating created\_id column on that table and that is in the 4.6alpha7.sql file. I do note that it came from this JIRA case <https://issues.civicrm.org/jira/browse/CRM-15970>. Perhaps you should raise it as a bug in the Jira system but also would recommend looking through the upgrade sql files on your system to see if they match what is in the git repo
  
  
  ---
  
  