Problem bei Datenübernahme tl_member

**mapfei** · 21.10.2017, 13:38

Hallo zusammen,

ich habe ein Problem bei der Übernahme der Mitglieder einer alten Contao-Version in Contao 4. Die Daten werden zwar übernommen, allerdings meldet die Konsole beim aktualisieren des Caches über den CM folgendes:

Code:

// 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                                                                       

12:50:47 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>

--------------------------------------------------------
Exception occured: The command "/usr/bin/php71 '-q' '/myWebsite/vendor/bin/contao-console' 'cache:warmup' '--env=prod'" failed.

Exit Code: 1(General error)

Working directory: /myWebsite

Output:
================

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



Error Output:
================
12:50:47 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:///myWebsite/web/contao-manager.phar.php/api/Tenside/Task/RebuildCacheTask.php(86): Tenside\Core\Task\AbstractCliSpawningTask->runProcess(Object(Symfony\Component\Process\Process))
#1 phar:///myWebsite/web/contao-manager.phar.php/api/Tenside/Task/RebuildCacheTask.php(52): Contao\ManagerApi\Tenside\Task\RebuildCacheTask->runSymfonyCommand('cache:warmup')
#2 phar:///myWebsite/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Task.php(173): Contao\ManagerApi\Tenside\Task\RebuildCacheTask->doPerform()
#3 phar:///myWebsite/web/contao-manager.phar.php/vendor/tenside/core/src/Task/Runner.php(89): Tenside\Core\Task\Task->perform('/www/htdocs/w00...')
#4 phar:///myWebsite/web/contao-manager.phar.php/vendor/tenside/core-bundle/src/Command/RunTaskCommand.php(82): Tenside\Core\Task\Runner->run('/www/htdocs/w00...')
#5 phar:///myWebsite/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))
#6 phar:///myWebsite/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))
#7 phar:///myWebsite/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))
#8 phar:///myWebsite/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))
#9 phar:///myWebsite/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))
#10 phar:///myWebsite/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))
#11 phar:///myWebsite/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))
#12 /myWebsite/web/contao-manager.phar.php(55): require('phar:///www/htd...')
#13 {main}
--------------------------------------------------------


Process terminated with exit code 1
Reason: General error

Was stimm hier nicht?

**w3scout** · 21.10.2017, 16:17

Evtl. ist das die Lösung?

https://community.contao.org/de/show...pd-4-4-5-error

VG

**mapfei** · 21.10.2017, 16:38

In der Tat hatten die beiden Tabellen tl_member und tl_member_group noch utf8_general_ci, statt utf8_unicode_ci. Das habe ich nun geändert. Allerdings spuckt die Konsole beim erstellen des Caches über den CM immer noch denselben Fehler aus.

**mapfei** · 21.10.2017, 21:28

Habe gesehen, dass die Tabellen tl_member und tl_member_group zwar jetzt utf8_unicode_ci sind, aber wenn ich beispielsweise in die Struktur von tl_member schaue, dort in allen Spalten noch utf8_general_ci steht. Kann ich die (über phpMyAdmin) irgendwie alle gleichzeitig ändern?

EDIT: Hab die betreffenden Spalten jetzt einzeln ausgewählt und angepasst und jetzt tut's! Vielen Dank nochmals für den Hinweis!