[GH-ISSUE #210] Error 500. Failed POST request in FireFox (works in chrome)

kerem commented

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

Owner

Originally created by @roelWuyts on GitHub (Dec 9, 2018).
Original GitHub issue: https://github.com/floccusaddon/floccus/issues/210

Software versions

Browser: Firefox 63.0.3 (64-bit)
Nextcloud: 14.0.4
Nextcloud Bookmarks app: 0.14.3
Floccus: 3.1.15
Floccus sync method: nextcloud Bookmarks v0.14+ with folders

Steps to reproduce

installed Bookmarks app in NextCloud
installed Floccus in Firefox
created synctest bookmarks folder in the Bookmarks Toolbar
added a link in this folder
added my account details (server, username, password) and set it to sync the '/Bookmarks Toolbar/synctest' folder with the server folder '/test' on my nextcloud

Expected outcome

After syncing I expected there to be a 'test' bookmark folder with the link in my nextcloud.

...

Actual outcome

the floccus plugin shows an error: 'Error 500. Failed POST request. Check your server configuration.
in the bookmarks app in nextcloud, when viewing it via a webbrowser, the 'test' folder is created but did not contain an entry

Checking my apache2 serverlogs and nextcloud logs did not reveal anything special (requests get through, which was to be expected given that the folder was created successfully).

I repeated the steps in Chrome (70.0.3538.110), where everything worked as advertised.

So it seems to be a firefox+floccus problem.
...

Debug log

Starting sync process for account wijle@cloud.1236.be
Fetching bookmarks
Received bookmarks from server [ - #1 AnandTech: Hardware News and Tech Reviews Since 1997 parentId: -1 ]
Filtered out the following duplicates before syncing []
COMPARE { localItem:
+ #Gy4FLAP73pR2[synctest] parentId: undefined
- #EWkL7iDCaC0afloccus – Get this Extension for 🦊 Firefox (en-US) parentId: Gy4FLAP73pR2,
cacheItem:
+ #undefined[undefined] parentId: undefined
,
serverItem:
+ #1[undefined] parentId: undefined
}
Checking subtree
COMPARE { localItem: - #EWkL7iDCaC0afloccus – Get this Extension for 🦊 Firefox (en-US) parentId: Gy4FLAP73pR2,
cacheItem: null,
serverItem: undefined }
(nextcloud-folders)CREATE - #undefinedfloccus – Get this Extension for 🦊 Firefox (en-US) parentId: 1

Originally created by @roelWuyts on GitHub (Dec 9, 2018). Original GitHub issue: https://github.com/floccusaddon/floccus/issues/210  ### Software versions  - Browser: Firefox 63.0.3 (64-bit) - Nextcloud: 14.0.4 - Nextcloud Bookmarks app: 0.14.3 - Floccus: 3.1.15 - Floccus sync method: nextcloud Bookmarks v0.14+ with folders ### Steps to reproduce  1. installed Bookmarks app in NextCloud 2. installed Floccus in Firefox 3. created synctest bookmarks folder in the Bookmarks Toolbar 4. added a link in this folder 5. added my account details (server, username, password) and set it to sync the '/Bookmarks Toolbar/synctest' folder with the server folder '/test' on my nextcloud ### Expected outcome After syncing I expected there to be a 'test' bookmark folder with the link in my nextcloud. ... ### Actual outcome 1. the floccus plugin shows an error: 'Error 500. Failed POST request. Check your server configuration. 2. in the bookmarks app in nextcloud, when viewing it via a webbrowser, the 'test' folder is created but did not contain an entry Checking my apache2 serverlogs and nextcloud logs did not reveal anything special (requests get through, which was to be expected given that the folder was created successfully). I repeated the steps in Chrome (70.0.3538.110), where everything worked as advertised. So it seems to be a firefox+floccus problem. ... ### Debug log Starting sync process for account wijle@cloud.1236.be Fetching bookmarks Received bookmarks from server [ - #1[AnandTech: Hardware News and Tech Reviews Since 1997](https://anandtech.com) parentId: -1 ] Filtered out the following duplicates before syncing [] COMPARE { localItem: + #Gy4FLAP73pR2[synctest] parentId: undefined - #EWkL7iDCaC0a[floccus – Get this Extension for 🦊 Firefox (en-US)](https://addons.mozilla.org/en-US/firefox/addon/floccus) parentId: Gy4FLAP73pR2, cacheItem: + #undefined[undefined] parentId: undefined , serverItem: + #1[undefined] parentId: undefined } Checking subtree COMPARE { localItem: - #EWkL7iDCaC0a[floccus – Get this Extension for 🦊 Firefox (en-US)](https://addons.mozilla.org/en-US/firefox/addon/floccus) parentId: Gy4FLAP73pR2, cacheItem: null, serverItem: undefined } (nextcloud-folders)CREATE - #undefined[floccus – Get this Extension for 🦊 Firefox (en-US)](https://addons.mozilla.org/en-US/firefox/addon/floccus) parentId: 1

kerem closed this issue

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

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 9, 2018):

Hey,
This is weird. If nextcloud hits a server-side error like that, there should be something about that in the nextcloud log file :/

@marcelklehr commented on GitHub (Dec 9, 2018): Hey, This is weird. If nextcloud hits a server-side error like that, there should be *something* about that in the nextcloud log file :/

kerem commented

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

Author

Owner

@roelWuyts commented on GitHub (Dec 9, 2018):

Just tried syncing again, saved the debug.log and attached it here.
Searching for error or post didn't give me anything.
I'm also stumped, especially since it was able to connect to make the folder.

Can the verbosity of the log be increased ?

floccus-3.1.15-2018-12-09(1).log

@roelWuyts commented on GitHub (Dec 9, 2018): Just tried syncing again, saved the debug.log and attached it here. Searching for error or post didn't give me anything. I'm also stumped, especially since it was able to connect to make the folder. Can the verbosity of the log be increased ? [floccus-3.1.15-2018-12-09(1).log](https://github.com/marcelklehr/floccus/files/2660797/floccus-3.1.15-2018-12-09.1.log)

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 9, 2018):

Floccus is not able to determine the reason for a 500 error, because that is a server-side error. It is possible to increase the verbosity of the nextcloud log in the settings UI, I think. If in doubt, feel free to send the nextcloud log file to me, via mail.

@marcelklehr commented on GitHub (Dec 9, 2018): Floccus is not able to determine the reason for a 500 error, because that is a server-side error. It is possible to increase the verbosity of the nextcloud log in the settings UI, I think. If in doubt, feel free to send the nextcloud log file to me, via mail.

kerem commented

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

Author

Owner

@roelWuyts commented on GitHub (Dec 10, 2018):

Dear Marcel,

I had a deeper look at the log entries in nextcloud, and it shows me one error after syncing floccus.

Below a screenshot, but I also saved the complete text from the screenshot and attached it to this mail.

Looking a bit closer to the error I noted that the problem was with the string value. This made me wonder...

The (one) entry I had in this sync folder was a link to this site (the firefox floccus add-on page)):

https://addons.mozilla.org/en-US/firefox/addon/floccus/

... and syncing that page gives me an error. I removed it, added another page, and that syncs correctly !

So I guess this 'fox' icon in the middle of the name causes problems ?

That also explains why it worked on Chrome, where I did not use the same page (should have known that - bad idea to not reproduce it exactly the sam...).

Kind regards,

Roel

[cid:c11680ac-e76c-4d0e-96c9-e77dbbca6461]

From: Marcel Klehr notifications@github.com
Sent: Sunday, December 9, 2018 19:57
To: marcelklehr/floccus
Cc: Roel Wuyts (imec); Author
Subject: Re: [marcelklehr/floccus] Error 500. Failed POST request in FireFox (works in chrome) (#210)

Floccus is not able to determine the reason for a 500 error, because that is a server-side error. It is possible to increase the verbosity of the nextcloud log in the settings UI, I think. I fin doubt, feel free to send the nextcloud log file to me, via mail.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com/marcelklehr/floccus/issues/210#issuecomment-445561952, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFXk7bl6E5iDXYoNwfSDbDexWld0iCrZks5u3V0CgaJpZM4ZKG6y.

Error index 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://addons.mozilla.org/en-US/firefox/addon/floccus", "floccus \u2013 Get this Extension for \ud83e\udd8a Firefox (en-US)", "wijle", 0, "Download floccus for Firefox. Sync your browser bookmarks with your self-hosted server"]: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128:

Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... 1", Doctrine\DBA ... ]})

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1015:

Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "INSERT INTO ... )", { 1: "https: ... "})

/var/www/nextcloud/lib/private/DB/Connection.php - line 216:

Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ "https://a ... "], [ 2,2,2,2,2])

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208:

OC\DB\Connection->executeUpdate("INSERT INTO ... )", { user_id: " ... "}, [])

/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/nextcloud/apps/bookmarks/controller/lib/bookmarks.php - line 918:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/nextcloud/apps/bookmarks/controller/rest/bookmarkcontroller.php - line 236:

OCA\Bookmarks\Controller\Lib\Bookmarks->addBookmark("wijle", "https://add ... s", "floccus – G ... )", [], "Download fl ... r", false, [ "1"])

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 166:

OCA\Bookmarks\Controller\Rest\BookmarkController->newBookmark("https://add ... s", [], "floccus – G ... )", false, "", [], [ "1"])

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99:

OC\AppFramework\Http\Dispatcher->executeController(OCA\Bookmark ... {}, "newBookmark")

/var/www/nextcloud/lib/private/AppFramework/App.php - line 118:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\Bookmark ... {}, "newBookmark")

/var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47:

OC\AppFramework\App::main("BookmarkController", "newBookmark", OC\AppFramew ... {}, { _route: "b ... "})

OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "b ... "})

/var/www/nextcloud/lib/private/Route/Router.php - line 297:

call_user_func(OC\AppFramew ... {}, { _route: "b ... "})

/var/www/nextcloud/lib/base.php - line 987:

OC\Route\Router->match("/apps/bookm ... k")

/var/www/nextcloud/index.php - line 42:

OC::handleRequest()

Cased by Doctrine\DBAL\Driver\PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1006:

Doctrine\DBAL\Driver\PDOStatement->execute()

/var/www/nextcloud/lib/private/DB/Connection.php - line 216:

Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ "https://a ... "], [ 2,2,2,2,2])

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208:

OC\DB\Connection->executeUpdate("INSERT INTO ... )", { user_id: " ... "}, [])

/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/nextcloud/apps/bookmarks/controller/lib/bookmarks.php - line 918:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/nextcloud/apps/bookmarks/controller/rest/bookmarkcontroller.php - line 236:

OCA\Bookmarks\Controller\Lib\Bookmarks->addBookmark("wijle", "https://add ... s", "floccus – G ... )", [], "Download fl ... r", false, [ "1"])

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 166:

OCA\Bookmarks\Controller\Rest\BookmarkController->newBookmark("https://add ... s", [], "floccus – G ... )", false, "", [], [ "1"])

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99:

OC\AppFramework\Http\Dispatcher->executeController(OCA\Bookmark ... {}, "newBookmark")

/var/www/nextcloud/lib/private/AppFramework/App.php - line 118:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\Bookmark ... {}, "newBookmark")

/var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47:

OC\AppFramework\App::main("BookmarkController", "newBookmark", OC\AppFramew ... {}, { _route: "b ... "})

OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "b ... "})

/var/www/nextcloud/lib/private/Route/Router.php - line 297:

call_user_func(OC\AppFramew ... {}, { _route: "b ... "})

/var/www/nextcloud/lib/base.php - line 987:

OC\Route\Router->match("/apps/bookm ... k")

/var/www/nextcloud/index.php - line 42:

OC::handleRequest()

Cased by PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 105:

PDOStatement->execute(null)

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1006:

Doctrine\DBAL\Driver\PDOStatement->execute()

/var/www/nextcloud/lib/private/DB/Connection.php - line 216:

Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ "https://a ... "], [ 2,2,2,2,2])

/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208:

OC\DB\Connection->executeUpdate("INSERT INTO ... )", { user_id: " ... "}, [])

/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/nextcloud/apps/bookmarks/controller/lib/bookmarks.php - line 918:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/nextcloud/apps/bookmarks/controller/rest/bookmarkcontroller.php - line 236:

OCA\Bookmarks\Controller\Lib\Bookmarks->addBookmark("wijle", "https://add ... s", "floccus – G ... )", [], "Download fl ... r", false, [ "1"])

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 166:

OCA\Bookmarks\Controller\Rest\BookmarkController->newBookmark("https://add ... s", [], "floccus – G ... )", false, "", [], [ "1"])

/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99:

OC\AppFramework\Http\Dispatcher->executeController(OCA\Bookmark ... {}, "newBookmark")

/var/www/nextcloud/lib/private/AppFramework/App.php - line 118:

OC\AppFramework\Http\Dispatcher->dispatch(OCA\Bookmark ... {}, "newBookmark")

/var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47:

OC\AppFramework\App::main("BookmarkController", "newBookmark", OC\AppFramew ... {}, { _route: "b ... "})

OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "b ... "})

/var/www/nextcloud/lib/private/Route/Router.php - line 297:

call_user_func(OC\AppFramew ... {}, { _route: "b ... "})

/var/www/nextcloud/lib/base.php - line 987:

OC\Route\Router->match("/apps/bookm ... k")

/var/www/nextcloud/index.php - line 42:

OC::handleRequest()

@roelWuyts commented on GitHub (Dec 10, 2018): Dear Marcel, I had a deeper look at the log entries in nextcloud, and it shows me one error after syncing floccus. Below a screenshot, but I also saved the complete text from the screenshot and attached it to this mail. Looking a bit closer to the error I noted that the problem was with the string value. This made me wonder... The (one) entry I had in this sync folder was a link to this site (the firefox floccus add-on page)): https://addons.mozilla.org/en-US/firefox/addon/floccus/ ... and syncing that page gives me an error. I removed it, added another page, and that syncs correctly ! So I guess this 'fox' icon in the middle of the name causes problems ? That also explains why it worked on Chrome, where I did not use the same page (should have known that - bad idea to not reproduce it exactly the sam...). Kind regards, Roel [cid:c11680ac-e76c-4d0e-96c9-e77dbbca6461] ------ ________________________________ From: Marcel Klehr <notifications@github.com> Sent: Sunday, December 9, 2018 19:57 To: marcelklehr/floccus Cc: Roel Wuyts (imec); Author Subject: Re: [marcelklehr/floccus] Error 500. Failed POST request in FireFox (works in chrome) (#210) Floccus is not able to determine the reason for a 500 error, because that is a server-side error. It is possible to increase the verbosity of the nextcloud log in the settings UI, I think. I fin doubt, feel free to send the nextcloud log file to me, via mail. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://github.com/marcelklehr/floccus/issues/210#issuecomment-445561952>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AFXk7bl6E5iDXYoNwfSDbDexWld0iCrZks5u3V0CgaJpZM4ZKG6y>. Error index 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:\/\/addons.mozilla.org\/en-US\/firefox\/addon\/floccus", "floccus \u2013 Get this Extension for \ud83e\udd8a Firefox (en-US)", "wijle", 0, "Download floccus for Firefox. Sync your browser bookmarks with your self-hosted server"]: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... 1", Doctrine\DBA ... ]}) /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1015: Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "INSERT INTO ... )", { 1: "https: ... "}) /var/www/nextcloud/lib/private/DB/Connection.php - line 216: Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ "https://a ... "], [ 2,2,2,2,2]) /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208: OC\DB\Connection->executeUpdate("INSERT INTO ... )", { user_id: " ... "}, []) /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/apps/bookmarks/controller/lib/bookmarks.php - line 918: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/apps/bookmarks/controller/rest/bookmarkcontroller.php - line 236: OCA\Bookmarks\Controller\Lib\Bookmarks->addBookmark("wijle", "https://add ... s", "floccus – G ... )", [], "Download fl ... r", false, [ "1"]) /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 166: OCA\Bookmarks\Controller\Rest\BookmarkController->newBookmark("https://add ... s", [], "floccus – G ... )", false, "", [], [ "1"]) /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99: OC\AppFramework\Http\Dispatcher->executeController(OCA\Bookmark ... {}, "newBookmark") /var/www/nextcloud/lib/private/AppFramework/App.php - line 118: OC\AppFramework\Http\Dispatcher->dispatch(OCA\Bookmark ... {}, "newBookmark") /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47: OC\AppFramework\App::main("BookmarkController", "newBookmark", OC\AppFramew ... {}, { _route: "b ... "}) OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "b ... "}) /var/www/nextcloud/lib/private/Route/Router.php - line 297: call_user_func(OC\AppFramew ... {}, { _route: "b ... "}) /var/www/nextcloud/lib/base.php - line 987: OC\Route\Router->match("/apps/bookm ... k") /var/www/nextcloud/index.php - line 42: OC::handleRequest() Cased by Doctrine\DBAL\Driver\PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1006: Doctrine\DBAL\Driver\PDOStatement->execute() /var/www/nextcloud/lib/private/DB/Connection.php - line 216: Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ "https://a ... "], [ 2,2,2,2,2]) /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208: OC\DB\Connection->executeUpdate("INSERT INTO ... )", { user_id: " ... "}, []) /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/apps/bookmarks/controller/lib/bookmarks.php - line 918: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/apps/bookmarks/controller/rest/bookmarkcontroller.php - line 236: OCA\Bookmarks\Controller\Lib\Bookmarks->addBookmark("wijle", "https://add ... s", "floccus – G ... )", [], "Download fl ... r", false, [ "1"]) /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 166: OCA\Bookmarks\Controller\Rest\BookmarkController->newBookmark("https://add ... s", [], "floccus – G ... )", false, "", [], [ "1"]) /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99: OC\AppFramework\Http\Dispatcher->executeController(OCA\Bookmark ... {}, "newBookmark") /var/www/nextcloud/lib/private/AppFramework/App.php - line 118: OC\AppFramework\Http\Dispatcher->dispatch(OCA\Bookmark ... {}, "newBookmark") /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47: OC\AppFramework\App::main("BookmarkController", "newBookmark", OC\AppFramew ... {}, { _route: "b ... "}) OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "b ... "}) /var/www/nextcloud/lib/private/Route/Router.php - line 297: call_user_func(OC\AppFramew ... {}, { _route: "b ... "}) /var/www/nextcloud/lib/base.php - line 987: OC\Route\Router->match("/apps/bookm ... k") /var/www/nextcloud/index.php - line 42: OC::handleRequest() Cased by PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 105: PDOStatement->execute(null) /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1006: Doctrine\DBAL\Driver\PDOStatement->execute() /var/www/nextcloud/lib/private/DB/Connection.php - line 216: Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ "https://a ... "], [ 2,2,2,2,2]) /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 208: OC\DB\Connection->executeUpdate("INSERT INTO ... )", { user_id: " ... "}, []) /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 214: Doctrine\DBAL\Query\QueryBuilder->execute() /var/www/nextcloud/apps/bookmarks/controller/lib/bookmarks.php - line 918: OC\DB\QueryBuilder\QueryBuilder->execute() /var/www/nextcloud/apps/bookmarks/controller/rest/bookmarkcontroller.php - line 236: OCA\Bookmarks\Controller\Lib\Bookmarks->addBookmark("wijle", "https://add ... s", "floccus – G ... )", [], "Download fl ... r", false, [ "1"]) /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 166: OCA\Bookmarks\Controller\Rest\BookmarkController->newBookmark("https://add ... s", [], "floccus – G ... )", false, "", [], [ "1"]) /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 99: OC\AppFramework\Http\Dispatcher->executeController(OCA\Bookmark ... {}, "newBookmark") /var/www/nextcloud/lib/private/AppFramework/App.php - line 118: OC\AppFramework\Http\Dispatcher->dispatch(OCA\Bookmark ... {}, "newBookmark") /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47: OC\AppFramework\App::main("BookmarkController", "newBookmark", OC\AppFramew ... {}, { _route: "b ... "}) OC\AppFramework\Routing\RouteActionHandler->__invoke({ _route: "b ... "}) /var/www/nextcloud/lib/private/Route/Router.php - line 297: call_user_func(OC\AppFramew ... {}, { _route: "b ... "}) /var/www/nextcloud/lib/base.php - line 987: OC\Route\Router->match("/apps/bookm ... k") /var/www/nextcloud/index.php - line 42: OC::handleRequest()

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 10, 2018):

This is a problem with your database. Checkout the nextcloud docs on how to convert your mysql database charset to utf8mb4.

@marcelklehr commented on GitHub (Dec 10, 2018): This is a problem with your database. Checkout the nextcloud docs on how to convert your mysql database charset to utf8mb4.

kerem commented

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

Author

Owner

@roelWuyts commented on GitHub (Dec 10, 2018):

Ah, I see, thanks (for the tip and fast response).

Kind regards,

Roel

From: Marcel Klehr notifications@github.com
Sent: Monday, December 10, 2018 17:33
To: marcelklehr/floccus
Cc: Roel Wuyts (imec); Author
Subject: Re: [marcelklehr/floccus] Error 500. Failed POST request in FireFox (works in chrome) (#210)

This is a problem with your database. Checkout the nextcloud docs on how to convert your mysql database charset to utf8mb4.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com/marcelklehr/floccus/issues/210#issuecomment-445880157, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AFXk7f1m2PD7i3GZfVBDus3HZmlYLIusks5u3ozBgaJpZM4ZKG6y.

@roelWuyts commented on GitHub (Dec 10, 2018): Ah, I see, thanks (for the tip and fast response). Kind regards, Roel ________________________________ From: Marcel Klehr <notifications@github.com> Sent: Monday, December 10, 2018 17:33 To: marcelklehr/floccus Cc: Roel Wuyts (imec); Author Subject: Re: [marcelklehr/floccus] Error 500. Failed POST request in FireFox (works in chrome) (#210) This is a problem with your database. Checkout the nextcloud docs on how to convert your mysql database charset to utf8mb4. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://github.com/marcelklehr/floccus/issues/210#issuecomment-445880157>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AFXk7f1m2PD7i3GZfVBDus3HZmlYLIusks5u3ozBgaJpZM4ZKG6y>.

kerem commented

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

Author

Owner

@prog-amateur commented on GitHub (Dec 10, 2018):

Sorry but the solving is not clear. Please, could you share a link to solve this issue please ? I am a beginner, and I like floccus but I have the same error. I use Nextcloudpi.

Thank you very much for your help.

@prog-amateur commented on GitHub (Dec 10, 2018): Sorry but the solving is not clear. Please, could you share a link to solve this issue please ? I am a beginner, and I like floccus but I have the same error. I use Nextcloudpi. Thank you very much for your help.

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 10, 2018):

@prog-amateur Sorry for the brevity on my part. This is the relevant article in the docs: https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html

@marcelklehr commented on GitHub (Dec 10, 2018): @prog-amateur Sorry for the brevity on my part. This is the relevant article in the docs: https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html

kerem commented

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

Author

Owner

@prog-amateur commented on GitHub (Dec 11, 2018):

Thank you very much for your feedback.This is definitely something I can't handle easily because I use Nextcloudpi (not Nextcloud), therefore, I will issue a ticket in the forum to know how to access the database and set it up as you have advised. Thank you.

@prog-amateur commented on GitHub (Dec 11, 2018): Thank you very much for your feedback.This is definitely something I can't handle easily because I use Nextcloudpi (not Nextcloud), therefore, I will issue a ticket in the forum to know how to access the database and set it up as you have advised. Thank you.

kerem commented

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

Author

Owner

@bernd-wechner commented on GitHub (Dec 11, 2018):

Me too (on Nextcloudpi). And it seems the latest releases uses MariaDB 10.1.37, meaning this is the section for us:

https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html#mariadb-10-2-or-earlier

And yet step 1 already loses me as it doesn't say where or how that configuration is set. So off I go on a jolly hunt for it.

Step 1:

$ sudo grep -R innodb /etc/mysql/*
mariadb.conf.d/50-server.cnf:innodb_file_format=barracuda
mariadb.conf.d/50-server.cnf:innodb_file_per_table=1
mariadb.conf.d/50-server.cnf:innodb_large_prefix=on
mariadb.conf.d/90-ncp.cnf:innodb_file_format=barracuda
mariadb.conf.d/90-ncp.cnf:innodb_file_per_table=1
mariadb.conf.d/90-ncp.cnf:innodb_large_prefix=on

which tells me I already have the config that this page requests. Good oh!

Small niggle, my system uses "on" as the value for innodb_large_prefix and the admin manual uses true. I am guessing they are synonymous.

Step 2: check that the config is right. They suggest:

SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%"

But this returns nothing on my box.

MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
Empty set (0.01 sec)

So generalising that query (removing the WHERE clause:

MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
Empty set (0.00 sec)

and generalising the query on that table:

MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
Empty set (0.00 sec)

So alas, I'm stuck on interpreting that admin manual. It does not seem to align with what I see in practice. Though provisionally it seems like I am already configured properly in this regard and this is not cause of my PUT failures?

@bernd-wechner commented on GitHub (Dec 11, 2018): Me too (on Nextcloudpi). And it seems the latest releases uses MariaDB 10.1.37, meaning this is the section for us: https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html#mariadb-10-2-or-earlier And yet step 1 already loses me as it doesn't say where or how that configuration is set. So off I go on a jolly hunt for it. Step 1: ``` $ sudo grep -R innodb /etc/mysql/* mariadb.conf.d/50-server.cnf:innodb_file_format=barracuda mariadb.conf.d/50-server.cnf:innodb_file_per_table=1 mariadb.conf.d/50-server.cnf:innodb_large_prefix=on mariadb.conf.d/90-ncp.cnf:innodb_file_format=barracuda mariadb.conf.d/90-ncp.cnf:innodb_file_per_table=1 mariadb.conf.d/90-ncp.cnf:innodb_large_prefix=on ``` which tells me I already have the config that this page requests. Good oh! Small niggle, my system uses "on" as the value for `innodb_large_prefix` and the admin manual uses true. I am guessing they are synonymous. Step 2: check that the config is right. They suggest: `SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%" ` But this returns nothing on my box. ``` MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%"; Empty set (0.01 sec) ``` So generalising that query (removing the WHERE clause: ``` MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES; Empty set (0.00 sec) ``` and generalising the query on that table: ``` MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES; Empty set (0.00 sec) ``` So alas, I'm stuck on interpreting that admin manual. It does not seem to align with what I see in practice. Though provisionally it seems like I am already configured properly in this regard and this is not cause of my PUT failures?

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 11, 2018):

@bernd-wechner This solution only applies to you, if you see the following (or similar) error in your nextcloud log:

Error	index	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_bookmarks` ... SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1

@marcelklehr commented on GitHub (Dec 11, 2018): @bernd-wechner This solution only applies to you, if you see the following (or similar) error in your nextcloud log: ``` Error index Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_bookmarks` ... SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\xA6\x8A F...' for column 'title' at row 1 ```

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 11, 2018):

@bernd-wechner Also, you apparently need the PROCESS privilege.

@marcelklehr commented on GitHub (Dec 11, 2018): @bernd-wechner Also, you [apparently need](https://mariadb.com/kb/en/library/information-schema-innodb_sys_tables-table/ ) the `PROCESS` privilege.

kerem commented

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

Author

Owner

@prog-amateur commented on GitHub (Dec 12, 2018):

Hello Bernd, Marcel, thank you for your feedback. Please find the thread I have issue in Nextcloud forum :

Hello, thank you all for your help !

The log file is a bit complicated to share as it contains some private links (nothing abnormal don’t worry ^^) among many many others, so it is difficult to sort them before showing it.

What is strange, is that since Firefox 64.0 update this morning, I have no more issue (it shows all good - Last synchronized : 3 mn ago). I really don’t know what happened as it is the first time I install completely floccus. The only change was Firefox update (for your information, I am on Linux).

I keep this thread open a few days, and if there is no more issue, I will close it.

As you can see, the issue disappeared this morning ! The only difference was Firefox update this morning to version 64.0.
Another interesting point is that Nextcloudpi's main developer says that utfmb4 already enabled, and he uses floccus without any issue.

@marcelklehr : Did you have updated the WebExtension in between ?

Thank you very much.

@prog-amateur commented on GitHub (Dec 12, 2018): Hello Bernd, Marcel, thank you for your feedback. Please find the thread I have issue in [Nextcloud forum](https://help.nextcloud.com/t/how-to-enable-mysql-mariadb-4-byte-support/42958/5) : > Hello, thank you all for your help ! > > The log file is a bit complicated to share as it contains some private links (nothing abnormal don’t worry ^^) among many many others, so it is difficult to sort them before showing it. > > **What is strange, is that since Firefox 64.0 update this morning, I have no more issue** (it shows all good - Last synchronized : 3 mn ago). I really don’t know what happened as it is the first time I install completely floccus. **The only change was Firefox update** (for your information, I am on Linux). > > I keep this thread open a few days, and if there is no more issue, I will close it. As you can see, the issue disappeared this morning ! The only difference was Firefox update this morning to version 64.0. Another interesting point is that Nextcloudpi's main developer says that **utfmb4 already enabled**, and he uses floccus without any issue. @marcelklehr : Did you have updated the WebExtension in between ? Thank you very much.

kerem commented

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

Author

Owner

@marcelklehr commented on GitHub (Dec 13, 2018):

I haven't updated the extension since you've opened this issue, no. I'm glad it works. :)

@marcelklehr commented on GitHub (Dec 13, 2018): I haven't updated the extension since you've opened this issue, no. I'm glad it works. :)

kerem commented

2026-02-25 22:36:28 +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.

Rows
Columns

[GH-ISSUE #210] Error 500. Failed POST request in FireFox (works in chrome) #199

Software versions

Steps to reproduce

Expected outcome

Actual outcome

Debug log