Why An error occurred while performing the search

ℹ️ Support
1

I am facing error while adding the person into talk
An error occurred while performing the search
the talk cannot find the user

[no app in context] Error: 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 10’ with params ["%abc%", “%abc%”, “%abc%”]:

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’ at <>

  1. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(“An exception oc … '”, Doctrine\DBAL\Dr … ]})
  2. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “An exception oc … '”)
  3. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 911
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “SELECT uid, ` … 0”, {1: “%abc%”,2: “%abc%”,3: “%abc%”})
  4. /var/www/html/lib/private/DB/Connection.php line 199
    Doctrine\DBAL\Connection->executeQuery(“SELECT uid, ` … 0”, {1: “%abc%”,2: “%abc%”,3: “%abc%”}, {1: 2,2: 2,3: 2}, null)
  5. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
    OC\DB\Connection->executeQuery(“SELECT uid, ` … 0”, {1: “%abc%”,2: “%abc%”,3: “%abc%”}, {1: 2,2: 2,3: 2})
  6. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 215
    Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /var/www/html/lib/private/User/Database.php line 285
    OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /var/www/html/lib/private/User/Manager.php line 275
    OC\User\Database->getDisplayNames(“abc”, 10, 0)
  9. /var/www/html/lib/private/Collaboration/Collaborators/UserPlugin.php line 82
    OC\User\Manager->searchDisplayName(“abc”, 10, 0)
  10. /var/www/html/lib/private/Collaboration/Collaborators/Search.php line 65
    OC\Collaboration\Collaborators\UserPlugin->search(“abc”, 10, 0, OC\Collaboration … {})
  11. /var/www/html/core/Controller/AutoCompleteController.php line 76
    OC\Collaboration\Collaborators\Search->search(“abc”, [“0”,“1”,“7”], false, 10, 0)
  12. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 170
    OC\Core\Controller\AutoCompleteController->get(“abc”, “call”, “new”, null, [“0”,“1”,“7”], 10)
  13. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 99
    OC\AppFramework\Http\Dispatcher->executeController(OC\Core\Controll … {}, “get”)
  14. /var/www/html/lib/private/AppFramework/App.php line 125
    OC\AppFramework\Http\Dispatcher->dispatch(OC\Core\Controll … {}, “get”)
  15. /var/www/html/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main(“OC\Core\Contr … r”, “get”, OC\AppFramework\ … {}, {_route: “ocs.core.AutoComplete.get”})
  16. <>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: “ocs.core.AutoComplete.get”})
  17. /var/www/html/lib/private/Route/Router.php line 299
    call_user_func(OC\AppFramework\ … {}, {_route: “ocs.core.AutoComplete.get”})
  18. /var/www/html/ocs/v1.php line 82
    OC\Route\Router->match("/ocsapp/core/autocomplete/get")
  19. /var/www/html/ocs/v2.php line 24
    require_once("/var/www/html/ocs/v1.php")

GET /ocs/v2.php/core/autocomplete/get?search=abc&itemType=call&itemId=new&shareTypes[]=0&shareTypes[]=1&shareTypes[]=7
from 192.168.10.2 by abc1 at 2020-04-14T07:08:24+00:00

2

I would recommend to use the search function of this forum, because similar questions are asked in this forum on a regular base. See e.g.:

https://help.nextcloud.com/search?q=Syntax%20error%20or%20access%20violation%3A%20COLLATION%20%E2%80%98utf8mb4_general_ci%E2%80%99%20is%20not%20valid%20for%20CHARACTER%20SET%20%E2%80%98utf8%E2%80%99