jason Posts - Answer Overflow

jason

•Created by jason on 4/15/2025 in #🙋questions

Accidentally cooked my db, start fresh from latest migration?

Hi all, I accidentally cooked my db again lmao, oops.. I had some migrations testing some stuff out, but accidentally really messed it up and deleted migration files by reverting with git, blah blah blah, here I am now, I THOUGHT I fixed it by running "wasp db reset" and doing a new "wasp db migrate-dev", but after changing the schema.prisma again and running "wasp db migrate-dev" again, it was saying:

Could not find the migration file at /srv/web/shelter/app/.wasp/out/db/migrations/20250414202957_video_migration/migration.sql. Please delete the directory or restore the migration file.

Could not find the migration file at /srv/web/shelter/app/.wasp/out/db/migrations/20250414202957_video_migration/migration.sql. Please delete the directory or restore the migration file.

Then I removed the empty directories from /srv/web/shelter/app/.wasp/out/db/migrations/ and ran it again, but now:

Error: P3006

Migration `20250415005503_new_init_migration` failed to apply cleanly to the shadow database.
Error:
ERROR: type "UserRole" already exists
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine/connectors/sql-schema-connector/src/lib.rs:335
   1: schema_core::state::DevDiagnostic
             at schema-engine/core/src/state.rs:276

Error: P3006

Migration `20250415005503_new_init_migration` failed to apply cleanly to the shadow database.
Error:
ERROR: type "UserRole" already exists
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine/connectors/sql-schema-connector/src/lib.rs:335
   1: schema_core::state::DevDiagnostic
             at schema-engine/core/src/state.rs:276

I'd rather just start the db fresh with no migration history, just using the current schema.primsa from my latest git commit. How can I do this?

10 replies

WWasp

•Created by jason on 2/14/2025 in #🙋questions

How can I log the 'request-password-reset' email in the server console while using the Dummy sender?

Hi all, I'm working on a new Wasp project based on the OpenSaaS template, attempting to implement multi-tenancy. Part of this includes inviting new users, which if the email isn't associated with an account already, it creates an account for that email and sends an email with a link to the request-password-reset URL, instructing the user to change their password then log in. My question is, when a user account is created, the Dummy email sender outputs the email to the server console so that I can just click the link to activate it. However, when I submit the request-password-reset action, I don't see any way to see that resulting value. I assume it's some URL with a key value. How can I make that known? I can easily create new user accounts, but I have no way of testing the entire system until I can request password resets in development.

10 replies

WWasp

•Created by jason on 1/26/2025 in #🙋questions

How do I access Prisma Studio for my Wasp app that I've deployed on Fly.io?

Hi all, like the title asks, how can I access the Prisma Studio to view / modify database records for a Wasp app that's been deployed to Fly.io?

6 replies

WWasp

•Created by jason on 1/23/2025 in #🙋questions

Fly.io stopped deploying

Hi! I'm testing deployment of my Wasp app to Fly.io. It was working perfectly for a while, but stopped working. I'm not quite sure what to make of these logs, and could use some guidance. I'm not sure why it went from just magically working to not working. I've attached the logs of my deployment attempt.

8 replies

WWasp

•Created by jason on 1/21/2025 in #🙋questions

Setting server secret env values and Stripe Webhook upon Fly.io deployment?

Hi, I'm working on launching my Wasp project! While I'm very excited, I'm also very confused. I'm using the 'wasp deploy fly' command with fly.io. The docs only very briefly mention the server secrets. It looks like I have to manually set each and every one? That's a bit troublesome as I'm using like 10 different values. Is this correct? You just have to manually set all those via commands? But more importantly, how does the Stripe Webhook get set? Don't we have to run that webhook via a terminal somewhere, get the generated value, then set it? How does this work with fly.io? Any guidance would be more than greatly appreciated!

7 replies

WWasp

•Created by jason on 1/20/2025 in #🙋questions

Hosting a Wasp project?

Hi, I recently have created a webapp using Wasp. But the wasp docs are a little confusing with how hosting works. In my experience, when I've completed websites in the past, I just throw everything (frontend, backend, db) into docker containers and run it all off a cheap $4/month vps, or my own home server. I see most of the options require 2 different services, 1 for the frontend and a complete different service for the frontend and backend? Why is that? What's stopping us from just running everything off the same server? I'm a bit confused and would really appreciate someone explaining hosting to me.

5 replies

WWasp

•Created by jason on 1/6/2025 in #🙋questions

I messed up my db migrations...

Hi all.. I messed up my db migration and now I have no idea how to fix this. This 'migration' stuff is kind of insane, but I'm willing to put up with it because the framework itself is so solid. Anyways, I have my OpenSaaS project being tracked by git. I was trying to implement a new feature, which included a change to the schema.prisma file, which required a db migration. However, I later decided to just roll back to the last git commit. This messed up my migration, the errors weren't specific at all about what I should do so I think I just removed the latest migration directory? It got super messed up, so I just reset the entire db using "wasp db reset". It looked like it was working fine after reset. But now, I'm making more changes to the db schema, and tried migrating it. But it threw an error about the last migration from before I reset.

[   Db  !] Error: P3015
[   Db  !]
[   Db  !] Could not find the migration file at /srv/web/opensaas_first_project/app/.wasp/out/db/migrations/20250103154636_interview_strengths_improvments_skillscores_migration/migration.sql. Please delete the directory or restore the migration file.
[   Db  !]

[   Db  !] Error: P3015
[   Db  !]
[   Db  !] Could not find the migration file at /srv/web/opensaas_first_project/app/.wasp/out/db/migrations/20250103154636_interview_strengths_improvments_skillscores_migration/migration.sql. Please delete the directory or restore the migration file.
[   Db  !]

I tried, from the /app directory, running: wasp clean rm -rf .wasp/ rm -rf node_modules/ npm install wasp db start wasp db reset But it's STILL talking about the old migration. Is it somewhere in my .git folder? What the hell is causing this headache?

12 replies

Gaming

Programming