After the update I cannot see my workflows, but they are still working

YunoHost-Apps / n8n_ynh

n8n package for YunoHost

https://n8n.io/

GNU General Public License v3.0

14 stars 18 forks source link

After the update I cannot see my workflows, but they are still working #83

Open theRAGEhero opened 1 month ago

theRAGEhero commented 1 month ago

Describe the bug

After the update I cannot see any of my workflows, but they are still working (I have some apps that are using n8n webhooks).

Right now I have version 1.45.1, but also with the previous one was the same. I've read of the db change, but I cannot understand why the old workflows are still working.

Thanks

Context

Hardware: VPS bought online / Old laptop or computer / Raspberry Pi at home / Internet Cube with VPN / Other ARM board / ...
YunoHost version: 11.2.20.2 (stable).
I have access to my server: *Through SSH | through the webadmin | direct access via keyboard / screen | GUI
Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
- If yes, please explain:
Using, or trying to install package version/branch: 1.45.1

CodeShakingSheep commented 1 month ago

So with which DB have you installed n8n initially? Was it with SQLite?

theRAGEhero commented 1 month ago

So with which DB have you installed n8n initially? Was it with SQLite?

I suppose yes. Is there a way to exactly know which db is used? The thing that I don't understand is why the old workflows and credentials are still working, if the app is now using a different database.

Thanks

Screenshot from 2024-07-16 13-26-10

theRAGEhero commented 2 weeks ago

Any idea or suggestion? Thanks

CodeShakingSheep commented 1 week ago

That's indeed a weird scenario you're describing. I have no idea why your workflows are still working and the counter still shows you 4 active workflows although there are none visible in your dashboard.

Regarding the DB, please verify first in .env that DB_TYPE=postgresdb. See https://github.com/YunoHost-Apps/n8n_ynh/blob/master/conf/.env#L27. Additionally, you can check if your previous workflows are exported by n8n export:workflow --all. See https://community.n8n.io/t/best-practice-for-n8n-database-migration/23585/2 .

Ideally, before the update you should have exported your workflows and then imported them back in after the update. I'm not sure what's the best way to deal with it now that you've already made the update. I will think about it. You could also ask your question in the n8n community https://community.n8n.io . They might be able to help you better there.

theRAGEhero commented 6 days ago

Thanks for your comment.

At the end was simpler to uninstall and reinstall it. Not it works as supposed.