Hello, I just discovered n8n and I’m already a fan. My first WF was easy to setup but the second one that looks a lot like the first breaks without error. If anyone got an idea of the reason that would be great !
My WF is supposed to check for me if some manga chapter is out on a site and if it is, send me a message on Disord.
I have a very simple postgres database with one table that keep the last chapter number of each manga followed.
I have inserted some logging instructions in the function nodes. It seems that the sub-WF is weirdly partially executed.
My main WF will get the list of website to query, make the requests and pass the HTMLs to the sublow.
The Subflow will parse the HTML check if the chapter is more recent than the one in the DB, if yes send a message on discord and log a string in the terminal else directly log the string.
Main:
Sub workflow:
The database used:
create table mangas
(
id serial not null
constraint mangas_pk
primary key,
name text not null,
source text not null,
last_chapter integer not null,
site text
);
alter table mangas
owner to driky;
create unique index mangas_id_uindex
on mangas (id);
INSERT INTO public.mangas (id, name, source, last_chapter, site) VALUES (1, 'Skeleton Soldier Couldn’t Protect the Dungeon', 'https://asurascans.com/manga/skeleton-soldier-couldnt-protect-the-dungeon/', 101, 'asura');
INSERT INTO public.mangas (id, name, source, last_chapter, site) VALUES (34, 'A Returner’s Magic Should Be Special', 'https://asurascans.com/manga/a-returners-magic-should-be-special/', 121, 'asura');
The logs:
n8n_1 | Postgres result:
n8n_1 | ┌──────────────┬─────────────────────────────────────────────────────────────────────┐
n8n_1 | │ (index) │ Values │
n8n_1 | ├──────────────┼──────────────────────────────────────────────────────────────────────────────┤
n8n_1 | │ id │ 1 │
n8n_1 | │ name │ 'Skeleton Soldier Couldn’t Protect the Dungeon' │
n8n_1 | │ source │ 'https://asurascans.com/manga/skeleton-soldier-couldnt-protect-the-dungeon/' │
n8n_1 | │ site │ 'asura' │
n8n_1 | │ last_chapter │ 101 │
n8n_1 | └──────────────┴──────────────────────────────────────────────────────────────────────────────┘
n8n_1 | Postgres result:
n8n_1 | ┌──────────────┬─────────────────────────────────────────────────────────────────────┐
n8n_1 | │ (index) │ Values │
n8n_1 | ├──────────────┼─────────────────────────────────────────────────────────────────────┤
n8n_1 | │ id │ 34 │
n8n_1 | │ name │ 'A Returner’s Magic Should Be Special' │
n8n_1 | │ source │ 'https://asurascans.com/manga/a-returners-magic-should-be-special/' │
n8n_1 | │ site │ 'asura' │
n8n_1 | │ last_chapter │ 121 │
n8n_1 | └──────────────┴─────────────────────────────────────────────────────────────────────┘
n8n_1 | TEST
n8n_1 | ┌─────────┬───────────────┬────────────────────────────────────────────────────────────────────────────────────┐
n8n_1 | │ (index) │ chapter │ link │
n8n_1 | ├─────────┼───────────────┼────────────────────────────────────────────────────────────────────────────────────┤
n8n_1 | │ json │ 'Chapter 102' │ 'https://asurascans.com/skeleton-soldier-couldnt-protect-the-dungeon-chapter-102/' │
n8n_1 | └─────────┴───────────────┴────────────────────────────────────────────────────────────────────────────────────┘
n8n_1 | https://asurascans.com/skeleton-soldier-couldnt-protect-the-dungeon-chapter-102/
n8n_1 | 102
n8n_1 | ASURA2 END
n8n_1 | ASURA2 END
