<p>While I’m not sure exactly what caused the issue after my client purchased the Craft Commerce Pro license, it was eventually fixed by restoring the database, upgrading Craft and Craft Pro to the current versions on my local machine, pushing those changes to the dev server, and allowing the upgrade scripts to run in full on the dev server. Thanks to @Brad for pointing me in the right direction.</p>

CC BY-SA 4.0
2020-09-26T15:43:18.203Z
2020-09-26T15:43:18.203Z
Document Services
<p>My installation of Craft Commerce seems stuck after purchasing the Pro license. Im getting similar errors throughout the site:</p>
<p><code>Base table or view not found: 1146 Table 'craft_xxx.xxx_commerce_customers' doesn't exist.</code></p>
<p>I've gone ahead and updated Craft to the latest version. Commerce is still on version 2. Updating it to version 3 via the control panel doesn't work (memory limit) and updating via the console yield multiple errors:</p>
<p><code>Applying new migrations ... error: The command &quot;'/xxx/craft' 'migrate/all' '--no-backup' '--no-content'&quot; failed.</code></p>
<p><code>&gt; create table {{%commerce_lineitemstatuses}} ...Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'xxx_commerce_lineitemstatuses' already exists</code></p>
<p>Not even sure if I need to update things.. Just hoping to get the site up and running and back into development.. :) I can restore the database and leave the files in place for the recent Craft and old 2.2.22 Commerce and try to upgrade again? Would that work?</p>
<p>Any advice?</p>

CC BY-SA 4.0
2020-09-24T02:33:30.663Z
`Base table or view already exists: 1050 Table 'xxx_commerce_lineitemstatuses' already exists` - that particular error happens when an update is attempted and the database isn't nuked and restored from a pre-update attempt backup before the next update attempt is made.
Brad Bell
CC BY-SA 4.0
2020-09-24T06:05:14.083Z
K, Trying to restore but even that's been an issue. Going to restore to pre-updated Craft and Craft Commerce and then run the update script via the command line...
Document Services
<plugin-craftcommerce>
Craft Commerce Upgrade Stuck
# Craft Commerce Upgrade Stuck

(Asked by: username_0 on 2020-09-23)

My installation of Craft Commerce seems stuck after purchasing the Pro license. Im getting similar errors throughout the site:

`Base table or view not found: 1146 Table 'craft_xxx.xxx_commerce_customers' doesn't exist.`

I've gone ahead and updated Craft to the latest version. Commerce is still on version 2. Updating it to version 3 via the control panel doesn't work (memory limit) and updating via the console yield multiple errors:

`Applying new migrations ... error: The command "'/xxx/craft' 'migrate/all' '--no-backup' '--no-content'" failed.`

`> create table {{%commerce_lineitemstatuses}} ...Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'xxx_commerce_lineitemstatuses' already exists`

Not even sure if I need to update things.. Just hoping to get the site up and running and back into development.. :) I can restore the database and leave the files in place for the recent Craft and old 2.2.22 Commerce and try to upgrade again? Would that work?

Any advice?

**Tags:** plugin-craftcommerce

> **Comments:**
> **username_1**: `Base table or view already exists: 1050 Table 'xxx_commerce_lineitemstatuses' already exists` - that particular error happens when an update is attempted and the database isn't nuked and restored from a pre-update attempt backup before the next update attempt is made.  
> **username_0**: K, Trying to restore but even that's been an issue. Going to restore to pre-updated Craft and Craft Commerce and then run the update script via the command line...  

---

## 1 answers

### Answer by username_0 on 2020-09-26. Score: 1 | Accepted answer

While I’m not sure exactly what caused the issue after my client purchased the Craft Commerce Pro license, it was eventually fixed by restoring the database, upgrading Craft and Craft Pro to the current versions on my local machine, pushing those changes to the dev server, and allowing the upgrade scripts to run in full on the dev server. Thanks to @Brad for pointing me in the right direction.


---

