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