4.4.1 managed Upd. 4.4.5 error

**tio** · 23.09.2017, 19:07

hi zusammen,

per phar.php update, kann vielleicht jemand sagen ob dieser SQL ein Problem macht???
vielen lieben Dank!!!

Code:

Loading composer repositories with package information
Updating dependencies
Nothing to install or update
Generating optimized autoload files
> Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication

 Added/updated the web/app_dev.php file.
 Added/updated the web/app.php file.

 // Clearing the cache for the prod environment with debug                      
 // false                                                                       

 [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  


 // Warming up the cache for the prod environment with debug                    
 // false                                                                       

20:02:45 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'" ["error" => Doctrine\DBAL\Exception\DriverException { …},"command" => "cache:warmup --env=prod","message" => """  An exception occurred while executing '\n              SELECT language FROM tl_member\n              UNION SELECT language FROM tl_user\n              UNION SELECT REPLACE(language, '-', '_') FROM tl_page\n              WHERE type='root'\n          ':\n  \n  SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'  """] []

                                                                               
  [Doctrine\DBAL\Exception\DriverException]                                    
  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'                                                                    
                                                                               

                                                                               
  [Doctrine\DBAL\Driver\PDOException]                                          
  SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operatio  
  n 'UNION'                                                                    
                                                                               

                                                                               
  [PDOException]                                                               
  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>

Script Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication handling the post-update-cmd event terminated with an exception
--------------------------------------------------------
Exception occured: An error occurred while executing the "cache:warmup" command: 20:02:45 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'" ["error" => Doctrine\DBAL\Exception\DriverException { …},"command" => "cache:warmup --env=prod","message" => """  An exception occurred while executing '\n              SELECT language FROM tl_member\n              UNION SELECT language FROM tl_user\n              UNION SELECT REPLACE(language, '-', '_') FROM tl_page\n              WHERE type='root'\n          ':\n  \n  SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'  """] []

                                                                               
  [Doctrine\DBAL\Exception\DriverException]                                    
  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'                                                                    
                                                                               

                                                                               
  [Doctrine\DBAL\Driver\PDOException]                                          
  SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operatio  
  n 'UNION'                                                                    
                                                                               

                                                                               
  [PDOException]                                                               
  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>


#0 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Composer/AbstractComposerCommandTask.php(166): Tenside\Core\Task\Composer\AbstractComposerCommandTask->executeCommand(Object(Composer\Command\UpdateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Tenside\Core\Task\TaskOutput))
#1 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Task.php(173): Tenside\Core\Task\Composer\AbstractComposerCommandTask->doPerform()
#2 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Runner.php(89): Tenside\Core\Task\Task->perform('/home/httpd/vho...')
#3 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core-bundle/src/Command/RunTaskCommand.php(82): Tenside\Core\Task\Runner->run('/home/httpd/vho...')
#4 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Command/Command.php(264): Tenside\CoreBundle\Command\RunTaskCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#5 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core-bundle/src/Command/RunTaskCommand.php(61): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#6 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Application.php(887): Tenside\CoreBundle\Command\RunTaskCommand->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#7 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Application.php(223): Symfony\Component\Console\Application->doRunCommand(Object(Tenside\CoreBundle\Command\RunTaskCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#8 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/api/ApiApplication.php(71): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Application.php(130): Contao\ManagerApi\ApiApplication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/api/console(74): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php(55): require('phar:///home/ht...')
#12 {main}
Chained exception: An error occurred while executing the "cache:warmup" command: 20:02:45 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'" ["error" => Doctrine\DBAL\Exception\DriverException { …},"command" => "cache:warmup --env=prod","message" => """  An exception occurred while executing '\n              SELECT language FROM tl_member\n              UNION SELECT language FROM tl_user\n              UNION SELECT REPLACE(language, '-', '_') FROM tl_page\n              WHERE type='root'\n          ':\n  \n  SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'  """] []

                                                                               
  [Doctrine\DBAL\Exception\DriverException]                                    
  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'                                                                    
                                                                               

                                                                               
  [Doctrine\DBAL\Driver\PDOException]                                          
  SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operatio  
  n 'UNION'                                                                    
                                                                               

                                                                               
  [PDOException]                                                               
  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>


#0 /home/httpd/vhosts/domain/httpdocs/vendor/contao/manager-bundle/src/Composer/ScriptHandler.php(38): Contao\ManagerBundle\Composer\ScriptHandler::executeCommand('cache:warmup', Object(Composer\Script\Event))
#1 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/composer/composer/src/Composer/EventDispatcher/EventDispatcher.php(282): Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication(Object(Composer\Script\Event))
#2 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/composer/composer/src/Composer/EventDispatcher/EventDispatcher.php(205): Composer\EventDispatcher\EventDispatcher->executeEventPhpScript('Contao\\ManagerB...', 'initializeAppli...', Object(Composer\Script\Event))
#3 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/composer/composer/src/Composer/EventDispatcher/EventDispatcher.php(96): Composer\EventDispatcher\EventDispatcher->doDispatch(Object(Composer\Script\Event))
#4 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/composer/composer/src/Composer/Installer.php(307): Composer\EventDispatcher\EventDispatcher->dispatchScript('post-update-cmd', false)
#5 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/composer/composer/src/Composer/Command/UpdateCommand.php(158): Composer\Installer->run()
#6 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Command/Command.php(264): Composer\Command\UpdateCommand->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Tenside\Core\Task\TaskOutput))
#7 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Composer/AbstractComposerCommandTask.php(147): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Tenside\Core\Task\TaskOutput))
#8 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Composer/AbstractComposerCommandTask.php(166): Tenside\Core\Task\Composer\AbstractComposerCommandTask->executeCommand(Object(Composer\Command\UpdateCommand), Object(Symfony\Component\Console\Input\ArrayInput), Object(Tenside\Core\Task\TaskOutput))
#9 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Task.php(173): Tenside\Core\Task\Composer\AbstractComposerCommandTask->doPerform()
#10 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Runner.php(89): Tenside\Core\Task\Task->perform('/home/httpd/vho...')
#11 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core-bundle/src/Command/RunTaskCommand.php(82): Tenside\Core\Task\Runner->run('/home/httpd/vho...')
#12 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Command/Command.php(264): Tenside\CoreBundle\Command\RunTaskCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/tenside/core-bundle/src/Command/RunTaskCommand.php(61): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Application.php(887): Tenside\CoreBundle\Command\RunTaskCommand->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Application.php(223): Symfony\Component\Console\Application->doRunCommand(Object(Tenside\CoreBundle\Command\RunTaskCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/api/ApiApplication.php(71): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/vendor/symfony/console/Application.php(130): Contao\ManagerApi\ApiApplication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 phar:///home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php/api/console(74): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /home/httpd/vhosts/domain/httpdocs/web/contao-manager.phar.php(55): require('phar:///home/ht...')
#20 {main}
--------------------------------------------------------


Process terminated with exit code 1
Reason: General error

**Spooky** · 26.09.2017, 08:09

Welche PHP Version?
Was für ein MySQL Server in welcher Version kommt zum Einsatz?
Welche collations haben bei dir tl_user.language und tl_page.language ?

**niccaballero** · 18.10.2017, 12:08

Das Problem kann gelöst werden, indem man der mySQL-Datenbanktabelle "tl_page" die richtige Kollation zuweist, sicherlich steht dort noch "COLLATE utf8_general_ci" und es sollte "COLLATE utf8_unicode_ci" stehen.

**dudette** · 10.11.2018, 09:48

Vielen Dank für den Tipp! Ich bin soeben verzweifelt, weil ich nach Import von User Groups und News Archives aus Contao 2 (!!!) in 4.4.* die gleichen Fehler angezeigt bekam. Jetzt läuft alles wieder rund. :-)

**jan.theofel** · 09.01.2019, 18:44

Hallo zusammen,

ich habe den selben Fehler. Also die Kollation auf utf8_general_ci für die ganze Datenbank gesetzt. Nur der Fehler ist weiterhin da. Sowohl im Contao Manager als auch wenn ich den SQL Code versuche direkt mittels phpMyAdmin auszuführen.

Was kann ich noch tun?

Jan