Just a head up that the next Joplin Server update could potentially include a breaking change, depending on your data. One of the database migration is going to add an "owner_id" column to the "items" table (where all notes, notebooks, etc. are stored), and automatically populate it. Normally that …

Are user of joplin cloud impacted by this? Will duplicated notes show up as a conflict notes and could be addressed by the conflict plugin?

The migration is already applied on Joplin Cloud so you won't need to do anything. There was one user affected by this - I've contacted him and since he wasn't using the account anymore he told me I could delete the duplicate notes.

Hi, I tried the query using psql on Joplin Server 2.5.9 (before upgrading to check before if I will have a problem), and I get : ERROR: column "items.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: select id, count(*), name, owner_id ^ Should I fi…

Right, I should have tested the query first. You actually need to remove the "id" part from it (as in my now updated post). If it returns nothing you're good to go.

[image] laurent: select count(*), name, owner_id from items group by name, owner_id having count(*) > 1; excellent, thank you. Now I get : count | name | owner_id -------+------+---------- (0 rows) It should be OK then

ok it seems like my server is affected. What do I need to do? I do not know how to use database tools and I am not a developer. [image] Joplin server fails with upgrading database Support Hi, I did a Joplin Dokcer pull yesterday. I now see that it fails some database upg…

You need to open a database client (a skill that's always useful when you self host): psql -h localhost -U joplin joplin (change the credential based on your env file) Then run this query: select count(*), name, owner_id from items group by name, owner_id having count(*) > 1; And then you can f…

From your log it seems that it's some timeCheck file that's duplicated, and you can safely delete these. delete from items where name='NAME OF FILE';

Thanks for the reply. Every app out there uses a different database, not easy to get accustomed to every piece of backend. I am running this inside the db docker psql -h localhost -U admin joplin psql (13.1 (Debian 13.1-1.pgdg100+1)) Type "help" for help. joplin=# select count(*), name, owner_id…

Then you need to try the queries without owner_id

Potential breaking change in next Joplin Server update (2.5.10)

News

kartoo 12 November 2021 16:29 7

ok it seems like my server is affected. What do I need to do? I do not know how to use database tools and I am not a developer.

Topic		Replies	Views
Deleting and Conflicting Support	28	607	14 March 2025
Self-hosted Joplin DB corrupted? Support	0	89	12 March 2025
Joplin server fails with upgrading database Support	1	1397	12 November 2021
Very disappointed on Joplin and its sync problems Lounge	19	1418	1 May 2025
Sync error on Linux - database query issue Support	6	161	15 December 2024

Potential breaking change in next Joplin Server update (2.5.10)

Related topics