Hallo zusammen,
seit heute führt der Contao Manager keine Aktualisierung des Application Cache mehr durch und bricht mit der nachfolgenden Meldung ab. Ich weiß momentan nicht, was man tun könnte um diesen Fehler zu beheben. Wer kann mir bitte mitteilen wie man diesen Fehler lösen kann?
Für Lösungsmöglichkeiten wäre ich sehr dankbar.
Code:
$ /usr/bin/php7.1 '-q' '-d' 'allow_url_fopen=1' '-d' 'memory_limit=2048M' '-d' 'suhosin.executor.include.whitelist="phar://,http://,https://"' '/is/htdocs/wp1163178_BIQN3TMV92/www.musikverein-hirschzell.de/contaosub/vendor/contao/manager-bundle/bin/contao-console' 'cache:clear' '--env=prod' '--no-warmup' 2>&1
// Clearing the cache for the prod environment with debug
// false
[OK] Cache for the "prod" environment (debug=false) was successfully cleared.
# Process terminated with exit code 0
# Result: OK
$ /usr/bin/php7.1 '-q' '-d' 'allow_url_fopen=1' '-d' 'memory_limit=2048M' '-d' 'suhosin.executor.include.whitelist="phar://,http://,https://"' '/is/htdocs/wp1163178_BIQN3TMV92/www.musikverein-hirschzell.de/contaosub/vendor/contao/manager-bundle/bin/contao-console' 'cache:warmup' '--env=prod' 2>&1
// Warming up the cache for the prod environment with debug
// false
11:39:05 ERROR [console] Error thrown while running command "cache:warmup --env=prod". Message: "An exception occurred while executing '
SELECT
language
FROM
tl_member
UNION
SELECT
language
FROM
tl_user
UNION
SELECT
REPLACE(language, '-', '_')
FROM
tl_page
WHERE
type = 'root'
':
SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'" ["exception" => Doctrine\DBAL\Exception\DriverException { …},"command" => "cache:warmup --env=prod","message" => """ An exception occurred while executing '\n SELECT\n language\n FROM\n tl_member\n UNION\n SELECT\n language\n FROM\n tl_user\n UNION\n SELECT\n REPLACE(language, '-', '_')\n FROM\n tl_page\n WHERE\n type = 'root'\n ':\n \n SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' """]
In AbstractMySQLDriver.php line 126:
An exception occurred while executing '
SELECT
language
FROM
tl_member
UNION
SELECT
language
FROM
tl_user
UNION
SELECT
REPLACE(language, '-', '_')
FROM
tl_page
WHERE
type = 'root'
':
SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operatio n 'UNION'
In PDOStatement.php line 144:
SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operatio n 'UNION'
In PDOStatement.php line 142:
SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operatio n 'UNION'
cache:warmup [--no-optional-warmers] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>
# Process terminated with exit code 1
# Result: General error
---
### The background task has stopped unexpectedly ###
Danke!
Gruß
Thomas