SnackyWell commented 5 years ago

I just started with Talk and got this Problem and try ti solve it with 4-byte support but my problem is now thare as before can you help me?

mario commented 5 years ago

Sounds very strange. So the only reason why this wouldn't work is if the DB was wrongly setup, but you say it should be fine. Did you try sending new emojis AFTER you've changed the DB?

SnackyWell commented 5 years ago

`# The MariaDB configuration file #

The MariaDB/MySQL tools read configuration files in the following order:

1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,

2. "/etc/mysql/conf.d/*.cnf" to set global options.

3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.

4. "~/.my.cnf" to set user-specific options.

#

If the same option is defined multiple times, the last one will apply.

#

One can use all long options that the program supports.

Run program with --help to get a list of available options and with

--print-defaults to see which it would actually understand and use.

#

This group is read both both by the client and the server

use it for options that affect everything

# [server] skip-name-resolve innodb_buffer_pool_size = 128M innodb_buffer_pool_instances = 1 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_max_dirty_pages_pct = 90 query_cache_type = 1 query_cache_limit = 2M query_cache_min_res_unit = 2k query_cache_size = 64M tmp_table_size= 64M max_heap_table_size= 64M slow-query-log = 1 slow-query-log-file = /var/log/mysql/slow.log long_query_time = 1

[client-server] !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mariadb.conf.d/

[client] default-character-set = utf8mb4

[mysqld] character-set-server = utf8mb4 collation-server = utf8mb4_general_ci transaction_isolation = READ-COMMITTED binlog_format = ROW innodb_large_prefix=on innodb_file_format=barracuda innodb_file_per_table=1 `

and this is my chat on Talk app: screenshot_20190125-112842

mario commented 5 years ago

Thanks for this. Well, first of all I do see that some emojis are working which makes it a bit strange.

I have absolutely no idea if this is needed for Maria, but maybe you can give it a shot if you haven't already?

sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true"

SnackyWell commented 5 years ago

Since i done this got an error while looking in the users and the emoji are doesent work anyways

SnackyWell commented 5 years ago

`Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` `u` LEFT JOIN `oc_preferences` `p` ON (`userid` = `uid`) AND (`appid` = 'settings') AND (`configkey` = 'email') WHERE (`uid` COLLATE utf8mb4_general_ci LIKE ?) OR (`displayname` COLLATE utf8mb4_general_ci LIKE ?) OR (`configvalue` COLLATE utf8mb4_general_ci LIKE ?) ORDER BY `uid_lower` ASC LIMIT 25 OFFSET 0' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128:

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

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

Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"})

/var/www/html/lib/private/DB/Connection.php - line 195:

Doctrine\DBAL\Connection->executeQuery("SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"}, { 1: 2,2: 2,3: 2}, null)

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

OC\DB\Connection->executeQuery("SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"}, { 1: 2,2: 2,3: 2})

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

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

/var/www/html/lib/private/User/Database.php - line 282:

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

/var/www/html/lib/private/User/Database.php - line 383:

OC\User\Database->getDisplayNames("", "25", "0")

/var/www/html/lib/private/User/Manager.php - line 229:

OC\User\Database->getUsers("", "25", "0")

/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php - line 165:

OC\User\Manager->search("", "25", "0")

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

OCA\Provisioning_API\Controller\UsersController->getUsersDetails("", "25", "0")

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

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

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

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

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

OC\AppFramework\App::main("OCA\\Provis ... r", "getUsersDetails", OC\AppFramew ... {}, { _route: "o ... "})

<<closure>>

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

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

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

/var/www/html/ocs/v1.php - line 82:

OC\Route\Router->match("/ocsapp/cloud/users/details")

/var/www/html/ocs/v2.php - line 24:

require_once("/var/www/html/ocs/v1.php")

Eingefasst vonDoctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 847:

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

/var/www/html/lib/private/DB/Connection.php - line 195:

Doctrine\DBAL\Connection->executeQuery("SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"}, { 1: 2,2: 2,3: 2}, null)

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

OC\DB\Connection->executeQuery("SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"}, { 1: 2,2: 2,3: 2})

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

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

/var/www/html/lib/private/User/Database.php - line 282:

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

/var/www/html/lib/private/User/Database.php - line 383:

OC\User\Database->getDisplayNames("", "25", "0")

/var/www/html/lib/private/User/Manager.php - line 229:

OC\User\Database->getUsers("", "25", "0")

/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php - line 165:

OC\User\Manager->search("", "25", "0")

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

OCA\Provisioning_API\Controller\UsersController->getUsersDetails("", "25", "0")

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

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

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

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

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

OC\AppFramework\App::main("OCA\\Provis ... r", "getUsersDetails", OC\AppFramew ... {}, { _route: "o ... "})

<<closure>>

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

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

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

/var/www/html/ocs/v1.php - line 82:

OC\Route\Router->match("/ocsapp/cloud/users/details")

/var/www/html/ocs/v2.php - line 24:

require_once("/var/www/html/ocs/v1.php")

Eingefasst vonPDOException: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 105:

PDOStatement->execute(null)

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

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

/var/www/html/lib/private/DB/Connection.php - line 195:

Doctrine\DBAL\Connection->executeQuery("SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"}, { 1: 2,2: 2,3: 2}, null)

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

OC\DB\Connection->executeQuery("SELECT `uid ... 0", { 1: "%%",2: "%%",3: "%%"}, { 1: 2,2: 2,3: 2})

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

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

/var/www/html/lib/private/User/Database.php - line 282:

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

/var/www/html/lib/private/User/Database.php - line 383:

OC\User\Database->getDisplayNames("", "25", "0")

/var/www/html/lib/private/User/Manager.php - line 229:

OC\User\Database->getUsers("", "25", "0")

/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php - line 165:

OC\User\Manager->search("", "25", "0")

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

OCA\Provisioning_API\Controller\UsersController->getUsersDetails("", "25", "0")

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

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

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

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

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

OC\AppFramework\App::main("OCA\\Provis ... r", "getUsersDetails", OC\AppFramew ... {}, { _route: "o ... "})

<<closure>>

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

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

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

/var/www/html/ocs/v1.php - line 82:

OC\Route\Router->match("/ocsapp/cloud/users/details")

/var/www/html/ocs/v2.php - line 24:

require_once("/var/www/html/ocs/v1.php")`

mario commented 5 years ago

The error itself tells you that character set is utf8 while it should be utf8mb4.

nextcloud / talk-android

emoji are displayed as 4 ???? #428

The MariaDB/MySQL tools read configuration files in the following order:

1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,

2. "/etc/mysql/conf.d/*.cnf" to set global options.

3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.

4. "~/.my.cnf" to set user-specific options.

If the same option is defined multiple times, the last one will apply.

One can use all long options that the program supports.

Run program with --help to get a list of available options and with

--print-defaults to see which it would actually understand and use.

This group is read both both by the client and the server

use it for options that affect everything