[GH-ISSUE #952] Server sync error on specific URLs #621

Closed
opened 2026-02-25 22:37:39 +03:00 by kerem · 1 comment
Owner

Originally created by @zumlernen-de on GitHub (Sep 8, 2021).
Original GitHub issue: https://github.com/floccusaddon/floccus/issues/952

Describe the bug

I get a E020 server error when adding a specific URL (https://developer.nvidia.com/gpugems/gpugems3/part-iv-image-effects/chapter-24-importance-being-linear) to my bookmarks. As soon as I remove this specific website from my bookmarks syncinc is possible again. I'm also able to add other new bookmarks, they sync just fine, so it seems to be a problem with the specific site. I get the following error on the Nextcloud server:

[index] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1

POST /index.php/apps/bookmarks/public/rest/v2/bookmark

The strange thing is, that I'm able to add the URL directly via the web interface. Even syncing with the firefox plugin works after adding it manually on the server. The problem only occurs when I try to create the bookmark locally and sync it via the Firefox plugin. Do you have the same issue when trying to add a bookmark on this URL?

Edit: After adding the URL manually in the webinterface to some location I'm able to add it via my local clients to other folders as well. Do you just reference to existing entries in the database when adding the same entry twice on different locations?

To Reproduce

Steps to reproduce the behavior:

  1. Ensure you do not have https://developer.nvidia.com/gpugems/gpugems3/part-iv-image-effects/chapter-24-importance-being-linear in your synced bookmarks
  2. Go to https://developer.nvidia.com/gpugems/gpugems3/part-iv-image-effects/chapter-24-importance-being-linear
  3. Add bookmark
  4. Sync now via the floccus addon

Expected behavior

The bookmark syncs to the server.

Desktop

(please complete the following information)

  • OS: Windows
  • Browser: Firefox
  • Browser Version: 91.0.2
  • Floccus version: 4.7.0
  • Floccus sync method: Nextcloud bookmarks api

Server

(please complete the following information)

  • OS: Ubuntu 20.04
  • Nextcloud version: 22.1.1
  • Bookmarks app version: 4.4.1

Note: Please write down the actual version numbers instead of writing 'latest'.

Debug log

  • Debug log provided
Originally created by @zumlernen-de on GitHub (Sep 8, 2021). Original GitHub issue: https://github.com/floccusaddon/floccus/issues/952 ### Describe the bug I get a E020 server error when adding a specific URL (https://developer.nvidia.com/gpugems/gpugems3/part-iv-image-effects/chapter-24-importance-being-linear) to my bookmarks. As soon as I remove this specific website from my bookmarks syncinc is possible again. I'm also able to add other new bookmarks, they sync just fine, so it seems to be a problem with the specific site. I get the following error on the Nextcloud server: ``` [index] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 POST /index.php/apps/bookmarks/public/rest/v2/bookmark ``` The strange thing is, that I'm able to add the URL directly via the web interface. Even syncing with the firefox plugin works after adding it manually on the server. The problem only occurs when I try to create the bookmark locally and sync it via the Firefox plugin. Do you have the same issue when trying to add a bookmark on this URL? Edit: After adding the URL manually in the webinterface to some location I'm able to add it via my local clients to other folders as well. Do you just reference to existing entries in the database when adding the same entry twice on different locations? ### To Reproduce Steps to reproduce the behavior: 1. Ensure you do not have https://developer.nvidia.com/gpugems/gpugems3/part-iv-image-effects/chapter-24-importance-being-linear in your synced bookmarks 2. Go to https://developer.nvidia.com/gpugems/gpugems3/part-iv-image-effects/chapter-24-importance-being-linear 3. Add bookmark 4. Sync now via the floccus addon ### Expected behavior The bookmark syncs to the server. ### Desktop (please complete the following information) - OS: Windows - Browser: Firefox - Browser Version: 91.0.2 - Floccus version: 4.7.0 - Floccus sync method: Nextcloud bookmarks api ### Server (please complete the following information) - OS: Ubuntu 20.04 - Nextcloud version: 22.1.1 - Bookmarks app version: 4.4.1 Note: Please write down the actual version numbers instead of writing 'latest'. ### Debug log - [ ] Debug log provided
kerem 2026-02-25 22:37:39 +03:00
  • closed this issue
  • added the
    bug
    label
Author
Owner

@github-actions[bot] commented on GitHub (Mar 20, 2023):

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

<!-- gh-comment-id:1476411237 --> @github-actions[bot] commented on GitHub (Mar 20, 2023): This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/floccus#621
No description provided.