Answers.Body: <p>In between borked update attempts, are you restoring the database to the pre-update state? By default, Craft will create a database backup and place it in the <code>craft/storage/backups</code> folder during an update that you can use.</p>
  
  <p>If you look at your <code>craft/storage/runtime/logs</code> files you'll be able to 1) see the error that originally happened to cause the failed update and 2) see the error that's preventing the CP from loading.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-02-23T20:17:30.377Z
Answers.Text: Thanks Brad, I managed to get one of the old SQL files to work, then the auto-update did two separate upgrades and everything is groovy.
Answers.UserDisplayName: Judd Lyon
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-02-22T00:54:36.780Z
Answers.LastActivityDate: 2015-02-22T00:54:36.780Z
Answers.UserDisplayName: Brad Bell
Body: <p>I'm trying to upgrade an Craft site from 1.3 to 2.3 and have gotten into a broken state.</p>
  
  <p>The update button failed, so I tried a manual update. This noted that I needed at least version 2.1, which I then downloaded and tried. It throws the following error and reverts:</p>
  
  <p><em>CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'edition' in 'field list'</em></p>
  
  <p>When I revert back to 1.3 the admin screen is now blank.</p>
  
  <p>The relevant versions/schema info:</p>
  
  <ul>
  <li>Version: 1.3, Build: 2486, Schema: 1.3.15 (blank login)</li>
  <li>Version: 2.1, Build: 2570, Schema: 2.1.2 (SQL error)</li>
  <li>Version: 2.3, Craft Build: 2635, Schema: 2.3.4 (desired version)</li>
  </ul>
  
  <p>The craft_info table shows that I'm running 1.3. The site is up, but I can't access the backend. </p>
  
  <p>Any help greatly appreciated!</p>
  
Tags: <updating>
Title: Borked upgrade from 1.3 to 2.3
ThreadText: # Borked upgrade from 1.3 to 2.3
  
  (Asked by: username_0 on 2015-02-21)
  
  I'm trying to upgrade an Craft site from 1.3 to 2.3 and have gotten into a broken state.
  
  The update button failed, so I tried a manual update. This noted that I needed at least version 2.1, which I then downloaded and tried. It throws the following error and reverts:
  
  *CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'edition' in 'field list'*
  
  When I revert back to 1.3 the admin screen is now blank.
  
  The relevant versions/schema info:
  
  * Version: 1.3, Build: 2486, Schema: 1.3.15 (blank login)
  * Version: 2.1, Build: 2570, Schema: 2.1.2 (SQL error)
  * Version: 2.3, Craft Build: 2635, Schema: 2.3.4 (desired version)
  
  The craft\_info table shows that I'm running 1.3. The site is up, but I can't access the backend.
  
  Any help greatly appreciated!
  
  **Tags:** updating
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-02-22. Score: 0 | Accepted answer
  
  In between borked update attempts, are you restoring the database to the pre-update state? By default, Craft will create a database backup and place it in the `craft/storage/backups` folder during an update that you can use.
  
  If you look at your `craft/storage/runtime/logs` files you'll be able to 1) see the error that originally happened to cause the failed update and 2) see the error that's preventing the CP from loading.
  
  > **Comments:**
  > **username_0**: Thanks username_1, I managed to get one of the old SQL files to work, then the auto-update did two separate upgrades and everything is groovy.  
  
  ---
  
  