How to find the "bad" bookmark that leads to a sync failure in Firefox with Nextcloud Bookmarks?

[johanneskastl]

Hi all,

is there a way to find out, which of my bookmarks is causing the sync to fail?

I am syncing from Firefox to my Nextcloud Bookmarks. The sync starts but fails with this error:

["Could not add bookmark"]} Nextcloud API error: {"status":"error","data":["Could not add bookmark"]} Nextcloud API error: {"status":"error","data":["Could not add bookmark"]} | Last synchronized: 0 seconds ago

I create a backup of my bookmarks, and delete half of them. Now the sync is successful.

So, other than importing the backup, only deleting half of the half that I deleted previously, and repeating this for ever, how can I find out which of the bookmarks is causing the sync to fail?

The debug log looks like this, it does not indicate which bookmark failed:

2024-11-08T07:31:02.387Z Executed 8 actions from 426 actions
2024-11-08T07:31:02.388Z Executed 9 actions from 426 actions
2024-11-08T07:31:02.463Z Receiving response for PUT https://<redacted>/index.php/apps/bookmarks/public/rest/v2/bookmark/71
2024-11-08T07:31:02.465Z Executed 10 actions from 426 actions
2024-11-08T07:31:02.465Z Syncing failed with Nextcloud API error:
{"status":"error","data":["Could not add bookmark"]}
Nextcloud API error:
{"status":"error","data":["Could not add bookmark"]}

I already skimmed for "funny" characters in the names and renamed the obvious ones. But to no avail (and I have a lot of bookmarks...).

Thanks in advance!

Kind Regards,
Johannes

[marcelklehr]

Hey Johannes,

the PUT should be associated with an UPDATE action, which should contain the Bookmark that is being updated in the log entry. Since this seems to happen in the first 10 actions being executed, you should be able to find the offending Bookmark in the logs leading up to this point. If you like you can send me the log privately via email.

[johanneskastl]

OK, I think I got the relations right. But I find no reason, why such a Bookmark should cause issues?

This is the line for the offending bookmark:

           - #1340;31[Kitsch trifft Armut](http://www.spiegel.de/kultur/gesellschaft/0,1518,714571,00.html) parentId: 31

[marcelklehr]

Mmmh, the IDs are not the same, though. 1340 is the id of the last bookmark, 71 the one of the offending bookmark

[marcelklehr]

Looking deeper into this, though, the API error stems from this method: https://github.com/nextcloud/bookmarks/blob/484d6c26ea8edcb590572d88dccbdf8c826c32ba/lib/Controller/BookmarkController.php#L427-L457 which means it can't have stemmed from the PUT 71, it must have been from a CREATE action, which would be a POST request

[johanneskastl]

Mmmh, the IDs are not the same, though. 1340 is the id of the last bookmark, 71 the one of the offending bookmark

Sorry, I took a newer debug log and use that as an example.

There are at least 100 lines between the last CREATE.

The last PUT is a dozen lines before:

2024-11-09T18:01:04.203Z Receiving response for POST https://<redacted>/index.php/apps/bookmarks/public/rest/v2/bookmark

This does not shed much light, unfortunately...

[marcelklehr]

Can you send me a redacted log perhaps? That would make things easier

[marcelklehr]

I was able to replicate this issue, it doesn't seem to be due to the URL. Can you try emptying the trash in Nextcloud Bookmarks?

[marcelklehr]

117? Then your DB schema isn't up to date, I think.

[marcelklehr]

Is it possible that you had installed the bookmarks app once years ago, uninstalled it and now installed it again? You may be running an up-to-date code base on an outdated DB schema. The up-to-date schema should allow 1000 bytes in the title.

[johanneskastl]

Is it possible that you had installed the bookmarks app once years ago, uninstalled it and now installed it again? You may be running an up-to-date code base on an outdated DB schema. The up-to-date schema should allow 1000 bytes in the title.

Not willingly, but as sometimes apps get deactivated during updates, I cannot rule that out.

Is there a way to update the schema?

[marcelklehr]

First please check the oc_bookmarks table schema and post it here, so we can check if it's actually outdated.

Then the easiest way is to

0. Put your instance in maintenance mode
1. make a db backup
2. log into your dbms console
3. drop all tables that start with oc_bookmarks
4. Delete all entries in oc_migrations for the bookmarks app
5. Run occ upgrade

This will clear all bookmarks data for all users on your instance, though. It's essentially a reinstall. If you want to keep your data, you need to manually adjust the db tables. You need to check the Migrations folder in apps/bookmarks/lib/Migrations and figure out from the code which changes to make to the db schema. This is difficult though, because you don't know which schema changes are missing.

[johanneskastl]

As I am just starting to use Floccus and Nextcloud (as the first user on this instance), I can start from scratch without issues.

Is there an easy way to uninstall Nextcloud bookmarks and remove the database tables? To make sure I do not have any leftovers in the database?

Or do I need to uninstall and drop the tables manually?

[marcelklehr]

Is there an easy way to uninstall Nextcloud bookmarks and remove the database tables?

The easy way is outlined above, sadly.

[johanneskastl]

OK, I'll give it a try and report back.

[johanneskastl]

Short question:

Delete all entries in oc_migrations for the bookmarks app

Is this a table called oc_migrations or is this a folder in config or similar?