<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>

CC BY-SA 3.0
2015-02-23T20:17:30.377Z
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.
Judd Lyon
CC BY-SA 3.0
2015-02-22T00:54:36.780Z
2015-02-22T00:54:36.780Z
Brad Bell
<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>

<updating>
Borked upgrade from 1.3 to 2.3
# 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 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.  

---

