Fehler aufgrund inkompatibler Collations
Im Log tauchen Meldungen wie die folgenden auf, was darauf hinweist, dass irgendwelche Tabellen nicht zueinander passen.
2024/01/24 11:23:30 [error] 4081#4081: *255723039 FastCGI sent in stderr: "PHP message: PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' in /var/www/studip-5.1/lib/classes/StudipPDO.class.php:188
Stack trace:
#0 /var/www/studip-5.1/lib/classes/StudipPDO.class.php(188): PDO->query('SELECT b.semin...')
#1 /var/www/studip-5.1/lib/phplib/DB_Sql.class.php(79): StudipPDO->query('SELECT b.semin...')
#2 /var/www/studip-5.1/lib/classes/DbView.class.php(203): DB_Sql->query('SELECT b.semin...')
#3 /var/www/studip-5.1/lib/classes/StudipSemSearchHelper.class.php(114): DbView->get_query('view:SEM_TREE_G...')
#4 /var/www/studip-5.1/lib/classes/StudipSemSearch.class.php(198): StudipSemSearchHelper->doSearch()
#5 /var/www/studip-5.1/lib/classes/SemBrowse.class.php(162): StudipSemSearch->doSearch()
#6 /var/www/studip-5.1/app/controllers/search/courses.php(64): SemBrowse->__construct()
#7 /var/www/studip-5.1/vendor/trails/trails.php(557): Search_CoursesController->index_action()
#8 /var/www/st" while reading response header from upstream, client: 70.34.220.11, server: elearning.uni-oldenburg.de, request: "POST /dispatch.php/search/courses?cmd=qs&level=vv&option=&sset=0&sterm=1 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm.sock:", host: "elearning.uni-oldenburg.de", referrer: "https://elearning.uni-oldenburg.de/"
2024/01/24 11:12:17 [error] 4078#4078: *255694577 FastCGI sent in stderr: "PHP message: PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' in /var/www/studip-5.1/lib/classes/StudipPDOStatement.php:154
Stack trace:
#0 /var/www/studip-5.1/lib/classes/StudipPDOStatement.php(154): PDOStatement->execute()
#1 /var/www/studip-5.1/public/plugins_packages/UOL/Veranstaltungsverzeichnis/models/RelevantEnergy.php(110): StudipPDOStatement->execute()
#2 /var/www/studip-5.1/public/plugins_packages/UOL/Veranstaltungsverzeichnis/models/RelevantEnergy.php(67): VVZ\RelevantEnergy::getCoursesInstitutes('1\x00\xC0\xA7\xC0\xA2%2527%252...', NULL)
#3 /var/www/studip-5.1/public/plugins_packages/UOL/Veranstaltungsverzeichnis/controllers/relevantenergy.php(19): VVZ\RelevantEnergy::getInvolvedInstitutes('1\x00\xC0\xA7\xC0\xA2%2527%252...', NULL)
#4 /var/www/studip-5.1/vendor/trails/trails.php(557): RelevantenergyController->index_action()
#5 /var/www/studip-5.1/app/controllers/studip_controller.php(113): T" while reading response header from upstream, client: 70.34.220.11, server: elearning.uni-oldenburg.de, request: "POST /plugins.php/veranstaltungsverzeichnis/relevantenergy?Zuweisen=&vvz_sem_select=1%00%C0%A7%C0%A2%252527%252522 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm.sock:", host: "elearning.uni-oldenburg.de", referrer: "https://elearning.uni-oldenburg.de/"