d9957bc2-4cac-4a55-807d-267c37d6d5ae

The problem seems to be located in the Postgres DB. It MAY be related to me adding a column called "thumbnail" which happend around the same time it stopped working. However, it did work at least for a while after the addition of the thumbnail column.

This is a likely issue as well:
2024-07-08 10:52:40.562 UTC [31] LOG: invalid record length at 0/1C40720: expected at least 24, got 0

neither of these are errors, just because they are red does not mean they are automatically errors.

I can't generate a RSS Feed (it stopped working yesterday)
going to need more information about this, why are you unable to generate an rss feed? that sounds more like a code issue

can't access the db contents from the web
i assume you mean the data tab, and if so, its never been reliable so its best not to use it entirely

I am able to connect to the DB via my local IDE and the application is still adding contents to it
im not seeing anything that would indicate an issue with your database besides a code issue.

Thank you for looking into this. I will not review the RSSFeedView

This is where the RSSFeed is generated. Since you were able to explain that generating Data in the GUI should not be expected to work, also the fact that you can't find any issue with the current DB, I have dismissed an issue with the DB.

Now I'm moving onto the code that generates the RSSFeed, which is a java file: RSSFeedVie (also, my headache, not yours 🙂 )

sounds good, i wish you the best of luck debugging this!

Thanks! I'll let you know if I need any more help. But it seems it's actually parsing of date that doesn't work (strangely enough, this isn't a problem for my json export)

maybe the date the data tab inserted was wrong?

Could be, hopefully I know exactly which one it is soon

if you where using the data tab, your data could now be malformed in subtle ways

Yes, I think that's probably the cause. I will add some logging information, but also some DB protection if possible

I should be able to safeguard from malformed data insertion

and most importantly stop using the data tab 😉

Ahhhh

Yes

You're gith

right

That's probably what happend

Hm, I will try to remove the article I change

for database management, deploy the dbgate template into the project and have it connect to your database over the private network

Good tips! This is just a POC so I can try that for the next setup (I will work out the kinks and try to build it again)

Do you have a URL that explains how to set it up like you described? Also I had major issues deploying the front end, but ultimately used your github with caddy, not entirely sure why it worked but it did

how to set dbgate up?

Yes, I had a headache fixing the CORS so I jujst set it to allow all now between front end and back end

But I need some better security / data mgm in the next step

It's a bit besides of this support ticket, sorry.

But also to say I was helped by your github repo for react + vite + caddy

just look up some cors info for your backend framework and follow that, wouldnt be specfic to railway after all

Thank you @Brody - I found the error to be a malformed date. Possibly a result of the GUI as you said. I have now changed to ensure that malformed dates are not included in the feed and will take steps to ensure that properly formatted dates and times are inserted to begin with.

awsome!

Really great help, thanks again!

no problem!