I have lots of problems with Floccus never being able to finish synching for a folder I have with a good number of sub folders and bookmarks. It seems to get confused and puts folders within folders and each time it runs the problem get worse, the number of folders, folders and subfolders increase and in the end it just never completes. And then I had the Nextcloud CPU/dB maxing out. Deleting all bookmarks and disabling the Bookmark app and not using Flocuss is the only way I’ve found to allow Nextcloud the be stable.
There seem to be several people complaining about similar things in Floccus and the bookmarks app. Is anyone working on diagnosing this. It seems that people are being left to themselves deleting/cleaning up bookmarks instead of someone diagnosing what causes the problem in the first place,
It is also possible to use Floccus without the Bookmarks app by choosing “XBEL-File in WebDAV share” instead of “Nextcloud Bookmarks” when creating a new account in Floccus.
It’s hard to debug these issues, especially without direct access to the machines. I’m basically doing support for free on a best effort basis, so please forgive me if not everything is solved ASAP.
Good to know. However, it not clear (at least to me) whether Floccus is party to causing the problems regarding duplication and corruption of bookmarks or whether it’s the bookmarks app itself or some interaction of the two (or something else). I’d love. To help diagnose but the issues bring my Nextcloud install (and the whole server) to its knees.
I also just updated to 23.0.2. I’m not sure if there is anything in that release that would have any impact on any of these problems.
Unfortunately, I don’t know what causes your issues. I updated my Nextcloud server to 23.0.2 yesterday and haven’t noticed any issues so far. I use Floccus on two computers and on my phone regularly with the Bookmarks app as a backend.
I haven’t had any issues with 23.0.2 either but that is without running Bookmarks and Floccus. All of these problems started mid January for me when I was running on 22.x.x with no apparent change in my environment. I then went thru the various upgrades to 23.0.2 since then with no change until I disabled bookmarks and stopped using Floccus. I’d love to help diagnose but the problem is so severe it makes my environment at the server I’m running on unusable.
My gut says it’s something to do with corrupt bookmark entries but how did that happen and how to avoid in the future. And how do I salvage what I can from. My bookmarks without starting from scratch
Not sure if that helps… But there are import/export buttons and a button to delete all bookmarks in the settings of the Nextcloud Bookmarks app. Also Floccus has options to initate one way syncs, either push or pull. I would try to delete all boomarks in the app and then re-sync them from your browser or re-imort them from the previously exported file. Just make sure you have backups of all your bookmarks from your browser and from the app before you going to delete anything or start messing with the diffrent sync options.
I have founds that most of my problems were from adding accounts to floccus on different computers instead of copying the account.
There is a difference in function and also normal sync vs pull.
I don’t know how your bookmarks originated. If on nextcloud FIRST or if you “push sync” to nextcloud.
I think it’s worth experimenting if you can export to file for backup.
What I did was to import to nextcloud first and it looked good from what I could tell, but when I added floccus to other computers this is what started to give me problems.
So I don’t know why the differences but it seems to me that letting nextcloud dictate at first instead of the browser being in control.
What I mean by this is that if You export browser bookmarks, then import to nextcloud, then add account but let floccus pull only. Then I think normal sync and folders should function as they are suppose to .
Then if you add computers I would literally delete all bookmarks from that computer, then “copy account” with floccus “copy account” selection.
Something about adding account gave issue for me. So I exported bookmarks and passwords, then imported bookmarks to nextcloud.
Delete all browser bookmarks and add account to floccus and either pull or normal sync should work perfect.
However, when setting up other computers I would delete bookmarks, and copy account.
You will need to copy account feature on subsequent computers too.
This process has worked flawless for me after playing around and getting duplicate folders files etc.
So things seem to be getting worse. I was going to try and follow the suggestions from Captain86. This is what I did:
Re-enabled the bookmarks app.
Tried importing some bookmarks into a Nextcloud account (it happened to be the admin account which I’d never used for booksmarks before). The bookmarks were imported fine and I could delete them, use them etc. DIdn’t try and synch them. Everything looked good
Then wanted to try the account I use day to day - the one that has had the booksmarks problems described previously. When I opened the bookmarks app within this account the bookmarks app opens but the hourglass spins forever until I get an error "This webpage is having a problem’ error page .
I tried disabling and re-enabling the bookmarks app. No change, same endless hourglass eventually followed by error message
I tried removing the bookmarks app and reinstalling. Same problem.
Does this suggest some form of corruption of the bookmarks tables in the dB for that account?
More information. Assuming the tables relevant to the booksmarks app are the ones starting with oc_bookmarks…
The oc_bookmarks table contains 17 rows. They are all for my wifes Nextcloud user ID. The bookmarks app works fine for that user ID and I can see the 17 bookmarks in the bookmarks app. So far so good. There are no entries in this table for the user ID (mine) which has problems
The oc_bookmarks_folders table most more than 18k rows which all seem to be for the user ID with problems
The oc_boomarks_root_folders has three entries (one for each of the user Id’s which have used bookmarks). Interestingly the user_ID with problems has ‘1’ in the ‘Locked’ field vs Null for the other 2 user ID’s
There are 18k rows in the oc_bookmarks_tree table
All of the other oc_bookmarks tables are empty
Looks to me like the folders and tree tables have erroneous records in them that need to be deleted?
Would it be safe just to delete all rows in all of the oc_bookmarks tables so I can start fresh? Looks like there is an ‘Empty the table(truncate)’ command in phpmyadmin page that I have access to thru my shared hosting service. So I think I could use that to clear out all of the oc_bookmarks tables without having to resort to SQL commands
OK. So deleted all the rows in all of the oc_bookmarks tables to try and start fresh.
Seems to have worked. I can now access the bookmarks app. Have imported and tables look fine. Deleted all bookmarks. Tables look fine. Re-imported, everything looks fine. So I seem to be back to a stable starting point.
Next step will be to try and re-setup Floccus.
I guess the remaining question is to why I ended up with 18k+ orphaned entries in the oc_boomarks_folder and oc_bookmarks_tree tables. I suspect this was to do with Floccus when it seemed to get into a recursive loop and its bookmark synchs (which were set as bi-directional) would never complete successfully
Hopefully this helps someone else and maybe helps point whoever to what caused the problem
I’m not sure why this seems to work better for me or why copy would be any different then just adding new account but there did seem to be a difference for me.
Also I set to normal sync and then also had to select “auto sync” . When creating a new account I don’t remember “auto sync” being check “off”. But when copy account it is for me so you have to turn it on.
