after thte migration the new update 1.113.1 my workflow let to work, and said that I miss a colummns:
column 9827483463398fbb7d6b96916fe451d8bdefa0e8.role does not exist

1424653604454666240

Want to clarify, have you run the SQL snippet that you sent above? If not would be happy to help you get to where you can paste that.

Want to preface though. As a general rule of thumb any manual SQL run on services should be treated as a "worst case I lose everything" (even if its just a simple thing 😁).
Always make a backup of important workflows, data, settings, and secrets beforehand.

it is just for test not for work…just I sent to you the error that n8n gave to me that nobody can help me, thanks for your advide+

how can I resolve the problem ?? my workflows worked perfectly and after the update it i not working. I did not touch anything of my workflow it is about railways, it inos fair play, I spend a lot to make the workflow and I have to spend time to resolve this problem as well

hiiii nobody can help me ??

Did you do what Noah suggested? Back up the Postgres instance, then run the SQL you believe fixes this. As they said, gotta be extra careful.

You can do this by using a Postgres client and connecting to the DB to execute the SQL, I use this one:
https://eggerapps.at/postico2/

Also make sure this is not in your n8n env N8N_SKIP_MIGRATIONS=true

i DON T KNOW BACK UP THE POSTRGES AND RUN SQL, I DONT KNOW WAHT IS SQL , I DON KNOW HOW CAN I USE EGGERAPPS. IT IS LIKE YOU AR SPEAKING ME IN CHINNESE

After spend so many time for make the workflow …. happens this things that it is very frustrated .. xd

I'm sorry. As you shared the SQL snippet I thought you were familiar.

I don't have an immediate answer but I'll see if I can come up with something easier for you to do

sorry this texted was from claude that told me this post for resolve the problem cd

CrisOG you are my only choise at the moment, thanks

only me happened this things ?? if you tell me how can I resolve…

You are not the only one, there's a lot of non-technical people using Railway especially with automation tools like n8n.

what can I do ?? the workflow it is not working for the migration … xd if I konw this I dont update n8n

Backup your postgres first. This is how to do it

You said Service: Primary (n8n v1.113.3) but is the Worker also on this version? You can check by Clicking the Worker service then Settings.

Bear in mind, backups are only available on the Pro tier and above

Missed that one, thanks!

In that case, make sure the versions match, that could also trigger the issue you are running into

CLAUDE. said that I don t have one column, that the column was missing after the update then if i install before version anyway it is not working. Claude recommend me this program, but i was thinking that may be there are an easy way to resolve this problem because it is aproblem of railways after the update . This is the program… if the team can resolve the problem will be better, I won t like to dowload the program try to learn about the program and spend my time in this… xd https://eggerapps.at/postico2/

holaaaa joe necesi ayudaa

how can i find the terminal in railway ??

follow the docs here https://docs.railway.com/guides/cli#ssh

NO HAY HUEVOS… I NEE TO CONECT TO RAILWAY SSH O TERMINAL IN THE WEBSITE

ya lo he solucionado gracias, por na pq no me has podido ayudado en nada

Glad to hear you’ve solved it, but please keep this server English only. We have helped as much as we are able, given that you have not been receptive to our suggestions.

Marking this thread as solved

!s