Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

Errors: 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4' 5 days 8 hours ago #1

  • xmlf
  • xmlf's Avatar Topic Author
  • Offline
  • Junior
  • Junior
  • Posts: 174
Open Place list page:
QLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4' (SQL: select `p_place` from `wt_places` where `p_file` = 2 and `p_parent_id` = 0 order by p_place /*! COLLATE utf8_unicode_ci */ asc) …/vendor/illuminate/database/Connection.php:664
#0 …/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback()
#1 …/vendor/illuminate/database/Connection.php(333): Illuminate\Database\Connection->run()
#2 …/vendor/illuminate/database/Query/Builder.php(2130): Illuminate\Database\Connection->select()
#3 …/vendor/illuminate/database/Query/Builder.php(2324): Illuminate\Database\Query\Builder->runSelect()
#4 …/vendor/illuminate/database/Query/Builder.php(2604): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 …/vendor/illuminate/database/Query/Builder.php(2326): Illuminate\Database\Query\Builder->onceWithColumns()
#6 …/app/Place.php(193): Illuminate\Database\Query\Builder->pluck()
#7 …/app/Module/PlaceHierarchyListModule.php(284): Fisharebest\Webtrees\Place->getChildPlaces()
#8 …/app/Module/PlaceHierarchyListModule.php(219): Fisharebest\Webtrees\Module\PlaceHierarchyListModule->getHierarchy()
#9 …/app/Http/Middleware/WrapHandler.php(66): Fisharebest\Webtrees\Module\PlaceHierarchyListModule->handle()
#10 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\WrapHandler->process()
#11 …/app/Http/Middleware/CheckCsrf.php(75): Middleland\Dispatcher->handle()
#12 …/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CheckCsrf->process()
#13 …/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle()

After Administrator Login, Website Log:
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' (SQL: select n_surname /*! COLLATE utf8_bin */ AS surname, count(*) AS total from `wt_name` where `n_file` = 2 and n_surn /*! COLLATE utf8_bin */ = 王 group by `surname`) …/vendor/illuminate/database/Connection.php:664 #0 …/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback() #1 …/vendor/illuminate/database/Connection.php(333): Illuminate\Database\Connection->run() #2 …/vendor/illuminate/database/Query/Builder.php(2130): Illuminate\Database\Connection->select() #3 …/vendor/illuminate/database/Query/Builder.php(2324): Illuminate\Database\Query\Builder->runSelect() #4 …/vendor/illuminate/database/Query/Builder.php(2604): Illuminate\Database\

Again before I changed the database sorting rule from utf8_unicode_ci to utf8mb4_general_ci
MariaDB -10.4.17
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
Wang Family Website of Suining County, China
https://www.snwsjz.com
A family tree website that is customized, more humanized and convenient for users.

Please Log in or Create an account to join the conversation.

Last edit: by xmlf.

Website logs errors:utf8_bin is not valid for CHARACTER SET 5 days 8 hours ago #2

  • xmlf
  • xmlf's Avatar Topic Author
  • Offline
  • Junior
  • Junior
  • Posts: 174
Sorting rules only support utf8mb4_unicode_ci
github.com/fisharebest/webtrees/blob/82a.../UseDatabase.php#L65

I changed the sorting rule to utf8mb4_unicode_ci and the problem persists.
Wang Family Website of Suining County, China
https://www.snwsjz.com
A family tree website that is customized, more humanized and convenient for users.

Please Log in or Create an account to join the conversation.

Last edit: by xmlf.

Website logs errors:utf8_bin is not valid for CHARACTER SET 5 days 4 hours ago #3

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13693
webtrees does not yet support utf8mb4.

See github.com/fisharebest/webtrees/issues/2950
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Website logs errors:utf8_bin is not valid for CHARACTER SET 5 days 4 hours ago #4

  • xmlf
  • xmlf's Avatar Topic Author
  • Offline
  • Junior
  • Junior
  • Posts: 174
Mariadb is support utf8mb4_general_ci.
mariadb.com/kb/en/supported-character-sets-and-collations/
I backed up the database and re-imported it by changing the VARCHAR(255) in the SQL file to VARCHAR(191). Is it possible to support utf8mb4_general_ci
Wang Family Website of Suining County, China
https://www.snwsjz.com
A family tree website that is customized, more humanized and convenient for users.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum