Answers.Body: <p>Solved it by manually removing the references to it in the yaml file! I then had to apply the yaml changes in the dashboard a few times over before the sections came back. Adjusted the craft cms plan in the yaml file too. There was still a discrepancy between the local and production yaml files so I did a database pull back from production which resolved that.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-09T00:04:42.687Z
Answers.Text: Feel free to mark this as "The Answer" to close things out :)
Answers.UserDisplayName: cherrykoda
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-02T20:19:43.063Z
Answers.LastActivityDate: 2024-07-02T20:19:43.063Z
Answers.UserDisplayName: George Bleasdale
Answers.Body: <p>That migration error is probably the culprit behind the behavior you're seeing, and it's likely caused by a plugin's install migration attempting to create a table that already exists in your database.</p>
  <p>To fix it, make sure the database is completely empty before re-installing your project.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-02T20:16:26.477Z
Answers.Text: Couldn't get access to the database but solved it by manually removing the references to it in the yaml file!
Answers.UserDisplayName: George Bleasdale
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-02T19:31:29.170Z
Answers.LastActivityDate: 2024-07-02T19:31:29.170Z
Answers.UserDisplayName: Mats Mikkel Rummelhoff
Body: <p>I had to reinstall the project locally to solve an issue but now when logging into the admin dashboard locally:</p>
  <ul>
  <li>all sections are gone</li>
  <li>plugins are gone</li>
  <li>fields etc are gone</li>
  <li>It shows as Craft Solo instead of Pro</li>
  <li>Dashboard shows pending yaml chan
  ges. When I try to apply them it doesn't work because of a dodgy plugin from a while back:
  Migration Error: An error occurred while executing the &quot;craft\commerce\stripe\migrations\Install migration: SQLSTATE[42S01]: Base table or view already exists...</li>
  </ul>
  <p>The only thing it seems to have right is the multi sites I have set up in the Sites settings.</p>
  <p>As far as I can see the code files are all as they should be and yaml has all the sections etc showing.</p>
  <p>Any ideas? I'm more on the design side of things so struggle with databases etc.</p>
  
Tags: <error><craft4><installation><project.yaml>
Title: All sections & plugins gone after local reinstall - help!
ThreadText: # All sections & plugins gone after local reinstall - help!
  
  (Asked by: username_0 on 2024-07-02)
  
  I had to reinstall the project locally to solve an issue but now when logging into the admin dashboard locally:
  
  * all sections are gone
  * plugins are gone
  * fields etc are gone
  * It shows as Craft Solo instead of Pro
  * Dashboard shows pending yaml chan
    ges. When I try to apply them it doesn't work because of a dodgy plugin from a while back:
    Migration Error: An error occurred while executing the "craft\commerce\stripe\migrations\Install migration: SQLSTATE[42S01]: Base table or view already exists...
  
  The only thing it seems to have right is the multi sites I have set up in the Sites settings.
  
  As far as I can see the code files are all as they should be and yaml has all the sections etc showing.
  
  Any ideas? I'm more on the design side of things so struggle with databases etc.
  
  **Tags:** error, craft4, installation, project.yaml
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2024-07-02. Score: 3 | Accepted answer
  
  Solved it by manually removing the references to it in the yaml file! I then had to apply the yaml changes in the dashboard a few times over before the sections came back. Adjusted the craft cms plan in the yaml file too. There was still a discrepancy between the local and production yaml files so I did a database pull back from production which resolved that.
  
  > **Comments:**
  > **username_1**: Feel free to mark this as "The Answer" to close things out :)  
  
  ---
  
  ### Answer by username_2 on 2024-07-02. Score: 1
  
  That migration error is probably the culprit behind the behavior you're seeing, and it's likely caused by a plugin's install migration attempting to create a table that already exists in your database.
  
  To fix it, make sure the database is completely empty before re-installing your project.
  
  > **Comments:**
  > **username_0**: Couldn't get access to the database but solved it by manually removing the references to it in the yaml file!  
  
  ---
  
  