wallabag
docker-compose setup + mysql doesn't support articles with emojis
i am using the wallabag docker-compose setup. I am receiving a 500: Internal Server Error when I try to bag this page: https://blog.kentcdodds.com/how-getting-into-open-source-has-been-awesome-for-me-8480cd756a80
I get this error from the browser addon, web application, and android app.
here is the full error message from web application - error message as picture
android app error message:
Server error
Error: com.di72nn.stuff.wallabag.apiwrapper.exceptions.UnsuccessfulResponseException: HTTP response: 500 Internal Server Error
another user maybe had a similar issue and the article he tried to bag gets me also the error described above.
is this maybe a related issue?
posted about it yesterday, but with too little information and probably in the wrong repo
can you help me with this problem?
wallabag in docker container seems to have a problem with the emoji in the content of the article. The thumbs up and cake is the problem. Error message is SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x91\x8D</...' for column 'content' at row 1
and thumbs's UTF-8 (hex) is 0xF0 0x9F 0x91 0x8D.
With mysql, there is always a problem, that default table encoding is utf8, but you need utf8mb. I do not know how this is in Mariadb, but maybe it's the same issue?
Setting up the Database to be UTF8 has the solution, but i do not know how to integrate it into wallabag docker setup.
Or just use postgresql :)
@pixelyo, when you are using MySQL you need to use utf8mb4.
If you are using docker-compose use the example in this issue: https://github.com/wallabag/docker/issues/105
I've changed my docker-compose file after upgrading to the 2.3.2. It migrated the database without issues (Just make a backup to be on the save side :-) )
