starred/floccus

Fork 0

mirror of https://github.com/floccusaddon/floccus.git synced 2026-04-25 22:26:06 +03:00

[GH-ISSUE #341] E019 #287

New issue

Closed

opened 2026-02-25 22:36:42 +03:00 by kerem · 6 comments

kerem commented

2026-02-25 22:36:42 +03:00

Owner

Originally created by @Klaus15 on GitHub (Aug 3, 2019).
Original GitHub issue: https://github.com/floccusaddon/floccus/issues/341

Software versions

Browser: Chrome 75.0.3770.142
Nextcloud: 16.0.3
Nextcloud Bookmarks app: 1.1.1
Floccus: 3.3.2.
Floccus sync method: nextcloud Bookmarks v0.14+

Steps to reproduce

Created connection to nextcloud, configured sync
Started syncing
Syncing with small folder no problem
Syncing with bigger folder takes pretty long
eventually floccus states the error "Syncing failed with E019: HTTP Status 500. Anfrage vom Typ GET fehlgeschlagen. Überprüfen Sie die Server-Konfiguration und das Server-Log"

Expected outcome

Looks like it does not like certain string combinations of my booksmarks

Actual outcome

...

Debug log

Debug log provided

I've already reinstalled bookmarks app in nextcloud, truncated its tables. I also renamed the relevant tables in mysql to force their recreation which unfortunately did not happen after reinstalling the bookmarks app. So I restored them to their original name.

gmp, intl, mbstring are already installed on my system

Originally created by @Klaus15 on GitHub (Aug 3, 2019). Original GitHub issue: https://github.com/floccusaddon/floccus/issues/341  ### Software versions  - Browser: Chrome 75.0.3770.142 - Nextcloud: 16.0.3 - Nextcloud Bookmarks app: 1.1.1 - Floccus: 3.3.2. - Floccus sync method: nextcloud Bookmarks v0.14+  ### Steps to reproduce  1. Created connection to nextcloud, configured sync 2. Started syncing 3. Syncing with small folder no problem 4. Syncing with bigger folder takes pretty long 5. eventually floccus states the error "Syncing failed with E019: HTTP Status 500. Anfrage vom Typ GET fehlgeschlagen. Überprüfen Sie die Server-Konfiguration und das Server-Log" ### Expected outcome  Looks like it does not like certain string combinations of my booksmarks ### Actual outcome  ... ### Debug log  - [x] Debug log provided I've already reinstalled bookmarks app in nextcloud, truncated its tables. I also renamed the relevant tables in mysql to force their recreation which unfortunately did not happen after reinstalling the bookmarks app. So I restored them to their original name. gmp, intl, mbstring are already installed on my system

kerem closed this issue

2026-02-25 22:36:42 +03:00

kerem commented

2026-02-25 22:36:42 +03:00

Author

Owner

@marcelklehr commented on GitHub (Aug 3, 2019):

Thanks for your feedback! Since this is a server-side error, could you check the nextcloud log for errors and post the associated one here?

@marcelklehr commented on GitHub (Aug 3, 2019): Thanks for your feedback! Since this is a server-side error, could you check the nextcloud log for errors and post the associated one here?

kerem commented

2026-02-25 22:36:42 +03:00

Author

Owner

@Klaus15 commented on GitHub (Aug 3, 2019):

Hi Marcel,
thanks for having a look into this!
This seems to be the offending line in nextcloud.log:
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_bookmarks (url, title, user_id, public, added, lastmodified, description) VALUES(?, ?, ?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), ?)' with params ["https://www.amazon.de/Victure-Unterwasserkamera-170%C2%B0Fischaugen-Linse-Ersatzbatterien-Halterungs-Kit/product-reviews/B07L311D7M/ref%3Dcm_cr_dp_d_show_all_btm?ie=UTF8&reviewerType=all_reviews", "Amazon.de:Kundenrezensionen: Victure Action Cam 4K 20MP WiFi Touch Screen Ultra Full HD 30 Meters Unterwasserkamera Einstellbare 170\u00b0Fischaugen-Linse EIS Sports Kamera 2\u00d71350mAh Ersatzbatterien and Halterungs-Kit", "kluus", 0, ""]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'title' at row 1
0. /var/www/html/ocl/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 184: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... 1", Doctrine\DBA ... ]}) 

Maybe I'm still using old table settings in nextcloud? Is there a way to "reinitialize" the tables for the bookmarks app?

Thanks, Klaus

@Klaus15 commented on GitHub (Aug 3, 2019): Hi Marcel, thanks for having a look into this! This seems to be the offending line in nextcloud.log: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_bookmarks` (`url`, `title`, `user_id`, `public`, `added`, `lastmodified`, `description`) VALUES(?, ?, ?, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), ?)' with params ["https:\/\/www.amazon.de\/Victure-Unterwasserkamera-170%C2%B0Fischaugen-Linse-Ersatzbatterien-Halterungs-Kit\/product-reviews\/B07L311D7M\/ref%3Dcm_cr_dp_d_show_all_btm?ie=UTF8&reviewerType=all_reviews", "Amazon.de:Kundenrezensionen: Victure Action Cam 4K 20MP WiFi Touch Screen Ultra Full HD 30 Meters Unterwasserkamera Einstellbare 170\u00b0Fischaugen-Linse EIS Sports Kamera 2\u00d71350mAh Ersatzbatterien and Halterungs-Kit", "kluus", 0, ""]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'title' at row 1 0. /var/www/html/ocl/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 184: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... 1", Doctrine\DBA ... ]})  Maybe I'm still using old table settings in nextcloud? Is there a way to "reinitialize" the tables for the bookmarks app? Thanks, Klaus

kerem commented

2026-02-25 22:36:42 +03:00

Author

Owner

@marcelklehr commented on GitHub (Aug 3, 2019):

You can drop all bookmarks_* tables and remove the relevant migration entry from oc_migrations in order to recreate the tables from scratch.

@marcelklehr commented on GitHub (Aug 3, 2019): You can drop all bookmarks_* tables *and* remove the relevant migration entry from oc_migrations in order to recreate the tables from scratch.

kerem commented

2026-02-25 22:36:42 +03:00

Author

Owner

@Klaus15 commented on GitHub (Aug 3, 2019):

Hi Marcel,
that did the trick! After removing the tables, cleaning relevant part of oc_migrations and reinstalling the bookmarks app via nextcloud web-interface everything is working as before. Very much appreciated and thanks for the quick help!
Cheers, Klaus

@Klaus15 commented on GitHub (Aug 3, 2019): Hi Marcel, that did the trick! After removing the tables, cleaning relevant part of oc_migrations and reinstalling the bookmarks app via nextcloud web-interface everything is working as before. Very much appreciated and thanks for the quick help! Cheers, Klaus

kerem commented

2026-02-25 22:36:42 +03:00

Author

Owner

@marcelklehr commented on GitHub (Aug 3, 2019):

Awesome, I'm glad it works :)

@marcelklehr commented on GitHub (Aug 3, 2019): Awesome, I'm glad it works :)

kerem commented

2026-02-25 22:36:42 +03:00

Author

Owner

@github-actions[bot] commented on GitHub (Mar 21, 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.

@github-actions[bot] commented on GitHub (Mar 21, 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.

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#287

No description provided.

Rows
Columns