Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-26T15:43:18.203Z
Answers.LastActivityDate: 2020-09-26T15:43:18.203Z
Answers.UserDisplayName: Document Services
Body: <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>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-24T02:33:30.663Z
Comments.Text: `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.
Comments.UserDisplayName: Brad Bell
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-24T06:05:14.083Z
Comments.Text: 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...
Comments.UserDisplayName: Document Services
Tags: <plugin-craftcommerce>
Title: Craft Commerce Upgrade Stuck
ThreadText: # 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 @username_1 for pointing me in the right direction.
  
  
  ---
  
  