New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enabling emoticon support #369

Closed
stevenandree opened this Issue Oct 17, 2017 · 6 comments

Comments

Projects
None yet
2 participants
@stevenandree
Copy link

stevenandree commented Oct 17, 2017

No description provided.

@stevenandree

This comment has been minimized.

Copy link

stevenandree commented Oct 17, 2017

Hi, having a constant error in enabling sms sync off and to the server. I have done some digging and it appears to be linked to enabling utf8mb4 support. I was going to have a dig and see if I could edit the myself conf, but I wasn't sure where to find it in the snap.

Issue was originally opened nerzhul/ncsms-android#135

@stevenandree

This comment has been minimized.

Copy link

stevenandree commented Oct 17, 2017

Sorry edit mysql conf

@stevenandree

This comment has been minimized.

Copy link

stevenandree commented Oct 17, 2017

Link to Nextcloud implementation instructions were here https://docs.nextcloud.com/server/11/admin_manual/maintenance/mysql_4byte_support.html
I'm happy to test on my set up, was just hoping to get some feedback from someone on where the configuration file was in the snap

@kyrofa

This comment has been minimized.

Copy link
Member

kyrofa commented Oct 17, 2017

Hey @stevenandree, thanks for logging an issue! Quick guide for you (note that this is, of course, experimental, until it's been stabilized in Nextcloud):

First, change database character set and collation:

$ sudo nextcloud.mysql-client
mysql> ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Then set mysql.utf8mb4 to true in Nextcloud:

$ sudo nextcloud.occ config:system:set mysql.utf8mb4 --type boolean --value="true"

And finally apply the new settings to existing tables with:

$ sudo nextcloud.occ maintenance:repair

Once you do that, you should be able to use emojis, like this:

image

@kyrofa kyrofa closed this Oct 18, 2017

@stevenandree

This comment has been minimized.

Copy link

stevenandree commented Oct 18, 2017

Thanks @kyrofa works a treat and no issues! Have been using the snap for a long time now and that has been my only issue to sync up with all the extra apps on my phone! Thanks for your work!

@kyrofa

This comment has been minimized.

Copy link
Member

kyrofa commented Oct 18, 2017

Thanks for letting me know, @stevenandree! I appreciate your using it 😄 . Please let me know if you have any other issues.

@Jakethethird Jakethethird referenced this issue May 9, 2018

Closed

Converting to utf8mb4 #226

1 of 1 task complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment