After updating my database to the new service my app is not working

After updating my database to the new service my app is not working
apparently the migration was successful the env variables were updated automatically and when I checked the data, my name appeared in the database
No description
No description
75 Replies
Percy
Percy•10mo ago
Project ID: 542e6990-3a58-4b92-aec7-c58979a3fcfc
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
542e6990-3a58-4b92-aec7-c58979a3fcfc
Brody
Brody•10mo ago
does your app use variable references? eg. ${{Postgres.DATABASE_URL}}
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
i see this
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
and i checked the values and they match with what the database shows , the prot , the password ,etc
Brody
Brody•10mo ago
sorry but that doesnt quite answer my question check the raw editor, are they using reference variables?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
yes
Brody
Brody•10mo ago
perfect now that error message says 500, so maybe check the app's deploy logs
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Brody
Brody•10mo ago
is this an app you wrote?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
no i isntalled it using the templates railway provided
Brody
Brody•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
they removed it some time ago
Brody
Brody•10mo ago
are you running a very old version of shiori?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
probably
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
a year ago i installed it
Brody
Brody•10mo ago
i can make you an updated template, but im not sure its going to work with your database
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
can we try ? please
Brody
Brody•10mo ago
it might require you to do some manual migrations
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
yes i can try
Brody
Brody•10mo ago
can you link me to the repo you are deploying from?
Brody
Brody•10mo ago
make it public please
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
😮
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
i saw this and I tried those credentials and with those ones i was able to access
Brody
Brody•10mo ago
are your bookmarks there?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
no
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
😦
Brody
Brody•10mo ago
i have an idea of whats going on show me the tables in postgres please
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Brody
Brody•10mo ago
do you know how to dump the postgres database?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
i have only done it with datagrip
Brody
Brody•10mo ago
do you still have the legacy database?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
yes
Brody
Brody•10mo ago
oh cool then thats your backup
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
they have the same info
Brody
Brody•10mo ago
i think i have a possible solution, i will get back to you
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
thanks
Brody
Brody•10mo ago
open the raw editor of the v2 postgres service, on the DATABASE_PRIVATE_URL variable, replace postgresql:// with postgres:// (theres more steps, but one thing at a time)
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
here?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Brody
Brody•10mo ago
yep
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
done
Brody
Brody•10mo ago
looks good screenshot of your project please
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
what? sorry
Brody
Brody•10mo ago
screenshot of your railway project
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Brody
Brody•10mo ago
little cut off lol but thats okay, remove the active deployment from the shiori service
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
here? remove?
Brody
Brody•10mo ago
yep
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
done
Brody
Brody•10mo ago
rename that service to Shiori - Old
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
done
Brody
Brody•10mo ago
refresh your project window, then from within the same project click the + New button, choose template, search for shiori and deploy the only result
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Brody
Brody•10mo ago
click deploy why are all your screenshots cut off lol
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
No description
Brody
Brody•10mo ago
^ how did the deploy go?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
It was successful
Brody
Brody•10mo ago
did you try loging in?
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
Not yet
Brody
Brody•10mo ago
try loging in with the original credentials you would normally use
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
Yaaay It is working Thank you
Brody
Brody•10mo ago
you can now delete the old shori service, and your legacy postgres database
Javier Fuentes Mora
Javier Fuentes Mora•10mo ago
thank ypu
Brody
Brody•10mo ago
no problem!
Want results from more Discord servers?
Add your server