It would seem after changing the migrate programs v3 location it fails at the following line:
$setting_lang = \DB::table('system_settings')->where('setting_name', 'manager_language')->first();
with a server 500 error.
PHP error is:
[11-Jul-2022 09:56:17 Europe/London] PHP Fatal error: Uncaught PDOException: SQLSTATE: Syntax error or access violation: 1253 COLLATION 'utf8mb3_general_ci' is not valid for CHARACTER SET 'latin1' in dev14\core\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:82
#0 dev14\core\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(82): PDO->prepare('set names 'lati...', Array)
#1 dev14\core\vendor\illuminate\database\Connectors\MySqlConnector.php(76): Doctrine\DBAL\Driver\PDOConnection->prepare('set names 'lati...')
#2 dev14\core\vendor\illuminate\database\Connectors\MySqlConnector.php(32): Illuminate\Database\Connectors\MySqlConnector->configureEncoding(Object(Doctrine\DBAL\Driver\PDOConnection), Array)
#3 dev14\core\vendor\illuminate\database\Connectors\ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#4 [internal function]: Illuminate in dev14\core\vendor\illuminate\database\Connection.php on line 712
I've tried a few things but nothing seems to get around in.
Been trying for two days to see if I can sort this out. I'm torn between it's a MariaDB 10.6 thing or a PDO thing. Either way I'm at a wall.
The only other way would be rewrite it!