Datenbankanpassung auf 4.6 bringt Fehler

**ollibraun** · 01.09.2018, 20:18

Hallo,

ich habe per Contao-Manager die 4.6 installiert und eine Datenbak aus der Version 4.4 eingespielt. PHP 7.2.9. Beim Aufruf des Install-Tools kommt dann (nachdem es die Seite angezeigt hat, welche DB-Anpassungen es vornehmen wird):

Code:

[2018-09-01 19:03:49] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"http://domain/contao/install","method":"HEAD"} []
[2018-09-01 19:03:49] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"http://domain/contao/install","method":"GET"} []
[2018-09-01 19:03:53] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE tl_content SET playerStart = youtubeStart':  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'youtubeStart' in 'field list'" at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 80 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE tl_content SET playerStart = youtubeStart':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'youtubeStart' in 'field list' at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:80, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'youtubeStart' in 'field list' at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'youtubeStart' in 'field list' at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} []
[2018-09-01 19:07:31] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"http://domain/contao/install","method":"POST"} []

Beim zweiten Aufruf des Install-Tools kommt dies:

Code:

[2018-09-01 19:07:38] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci':  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes" at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 126 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:126, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /var/www/vhosts/domain/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} []

Weiß jemand, was ich falsch mache?

Viele Grüße,
Oliver

**ollibraun** · 01.09.2018, 20:43

Und weil ich im Forum einen ähnlichen Beitrag gefunden habe - es ist ein Debian 9-vServer, gesteuert von Plesk:

Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Code:

MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_%';
+---------------------------------------------+------------------------+
| Variable_name                               | Value                  |
+---------------------------------------------+------------------------+
| innodb_adaptive_flushing                    | ON                     |
| innodb_adaptive_flushing_lwm                | 10.000000              |
| innodb_adaptive_hash_index                  | ON                     |
| innodb_adaptive_hash_index_partitions       | 1                      |
| innodb_adaptive_max_sleep_delay             | 150000                 |
| innodb_additional_mem_pool_size             | 8388608                |
| innodb_api_bk_commit_interval               | 5                      |
| innodb_api_disable_rowlock                  | OFF                    |
| innodb_api_enable_binlog                    | OFF                    |
| innodb_api_enable_mdl                       | OFF                    |
| innodb_api_trx_level                        | 0                      |
| innodb_autoextend_increment                 | 64                     |
| innodb_autoinc_lock_mode                    | 1                      |
| innodb_background_scrub_data_check_interval | 3600                   |
| innodb_background_scrub_data_compressed     | OFF                    |
| innodb_background_scrub_data_interval       | 604800                 |
| innodb_background_scrub_data_uncompressed   | OFF                    |
| innodb_buf_dump_status_frequency            | 0                      |
| innodb_buffer_pool_dump_at_shutdown         | OFF                    |
| innodb_buffer_pool_dump_now                 | OFF                    |
| innodb_buffer_pool_dump_pct                 | 100                    |
| innodb_buffer_pool_filename                 | ib_buffer_pool         |
| innodb_buffer_pool_instances                | 8                      |
| innodb_buffer_pool_load_abort               | OFF                    |
| innodb_buffer_pool_load_at_startup          | OFF                    |
| innodb_buffer_pool_load_now                 | OFF                    |
| innodb_buffer_pool_populate                 | OFF                    |
| innodb_buffer_pool_size                     | 134217728              |
| innodb_change_buffer_max_size               | 25                     |
| innodb_change_buffering                     | all                    |
| innodb_checksum_algorithm                   | INNODB                 |
| innodb_checksums                            | ON                     |
| innodb_cleaner_lsn_age_factor               | HIGH_CHECKPOINT        |
| innodb_cmp_per_index_enabled                | OFF                    |
| innodb_commit_concurrency                   | 0                      |
| innodb_compression_algorithm                | zlib                   |
| innodb_compression_failure_threshold_pct    | 5                      |
| innodb_compression_level                    | 6                      |
| innodb_compression_pad_pct_max              | 50                     |
| innodb_concurrency_tickets                  | 5000                   |
| innodb_corrupt_table_action                 | assert                 |
| innodb_data_file_path                       | ibdata1:12M:autoextend |
| innodb_data_home_dir                        |                        |
| innodb_default_encryption_key_id            | 1                      |
| innodb_defragment                           | OFF                    |
| innodb_defragment_fill_factor               | 0.900000               |
| innodb_defragment_fill_factor_n_recs        | 20                     |
| innodb_defragment_frequency                 | 40                     |
| innodb_defragment_n_pages                   | 7                      |
| innodb_defragment_stats_accuracy            | 0                      |
| innodb_disable_sort_file_cache              | OFF                    |
| innodb_disallow_writes                      | OFF                    |
| innodb_doublewrite                          | ON                     |
| innodb_empty_free_list_algorithm            | LEGACY                 |
| innodb_encrypt_log                          | OFF                    |
| innodb_encrypt_tables                       | OFF                    |
| innodb_encryption_rotate_key_age            | 1                      |
| innodb_encryption_rotation_iops             | 100                    |
| innodb_encryption_threads                   | 0                      |
| innodb_fake_changes                         | OFF                    |
| innodb_fast_shutdown                        | 1                      |
| innodb_fatal_semaphore_wait_threshold       | 600                    |
| innodb_file_format                          | Antelope               |
| innodb_file_format_check                    | ON                     |
| innodb_file_format_max                      | Antelope               |
| innodb_file_per_table                       | ON                     |
| innodb_flush_log_at_timeout                 | 1                      |
| innodb_flush_log_at_trx_commit              | 1                      |
| innodb_flush_method                         |                        |
| innodb_flush_neighbors                      | 1                      |
| innodb_flushing_avg_loops                   | 30                     |
| innodb_force_load_corrupted                 | OFF                    |
| innodb_force_primary_key                    | OFF                    |
| innodb_force_recovery                       | 0                      |
| innodb_foreground_preflush                  | EXPONENTIAL_BACKOFF    |
| innodb_ft_aux_table                         |                        |
| innodb_ft_cache_size                        | 8000000                |
| innodb_ft_enable_diag_print                 | OFF                    |
| innodb_ft_enable_stopword                   | ON                     |
| innodb_ft_max_token_size                    | 84                     |
| innodb_ft_min_token_size                    | 3                      |
| innodb_ft_num_word_optimize                 | 2000                   |
| innodb_ft_result_cache_limit                | 2000000000             |
| innodb_ft_server_stopword_table             |                        |
| innodb_ft_sort_pll_degree                   | 2                      |
| innodb_ft_total_cache_size                  | 640000000              |
| innodb_ft_user_stopword_table               |                        |
| innodb_idle_flush_pct                       | 100                    |
| innodb_immediate_scrub_data_uncompressed    | OFF                    |
| innodb_instrument_semaphores                | OFF                    |
| innodb_io_capacity                          | 200                    |
| innodb_io_capacity_max                      | 2000                   |
| innodb_kill_idle_transaction                | 0                      |
| innodb_large_prefix                         | OFF                    |
| innodb_lock_schedule_algorithm              | fcfs                   |
| innodb_lock_wait_timeout                    | 50                     |
| innodb_locking_fake_changes                 | ON                     |
| innodb_locks_unsafe_for_binlog              | OFF                    |
| innodb_log_arch_dir                         | ./                     |
| innodb_log_arch_expire_sec                  | 0                      |
| innodb_log_archive                          | OFF                    |
| innodb_log_block_size                       | 512                    |
| innodb_log_buffer_size                      | 16777216               |
| innodb_log_checksum_algorithm               | INNODB                 |
| innodb_log_compressed_pages                 | ON                     |
| innodb_log_file_size                        | 50331648               |
| innodb_log_files_in_group                   | 2                      |
| innodb_log_group_home_dir                   | ./                     |
| innodb_lru_scan_depth                       | 1024                   |
| innodb_max_bitmap_file_size                 | 104857600              |
| innodb_max_changed_pages                    | 1000000                |
| innodb_max_dirty_pages_pct                  | 75.000000              |
| innodb_max_dirty_pages_pct_lwm              | 0.001000               |
| innodb_max_purge_lag                        | 0                      |
| innodb_max_purge_lag_delay                  | 0                      |
| innodb_mirrored_log_groups                  | 1                      |
| innodb_monitor_disable                      |                        |
| innodb_monitor_enable                       |                        |
| innodb_monitor_reset                        |                        |
| innodb_monitor_reset_all                    |                        |
| innodb_mtflush_threads                      | 8                      |
| innodb_old_blocks_pct                       | 37                     |
| innodb_old_blocks_time                      | 1000                   |
| innodb_online_alter_log_max_size            | 134217728              |
| innodb_open_files                           | 2000                   |
| innodb_optimize_fulltext_only               | OFF                    |
| innodb_page_size                            | 16384                  |
| innodb_prefix_index_cluster_optimization    | OFF                    |
| innodb_print_all_deadlocks                  | OFF                    |
| innodb_purge_batch_size                     | 300                    |
| innodb_purge_threads                        | 1                      |
| innodb_random_read_ahead                    | OFF                    |
| innodb_read_ahead_threshold                 | 56                     |
| innodb_read_io_threads                      | 4                      |
| innodb_read_only                            | OFF                    |
| innodb_replication_delay                    | 0                      |
| innodb_rollback_on_timeout                  | OFF                    |
| innodb_rollback_segments                    | 128                    |
| innodb_sched_priority_cleaner               | 19                     |
| innodb_scrub_log                            | OFF                    |
| innodb_scrub_log_speed                      | 256                    |
| innodb_show_locks_held                      | 10                     |
| innodb_show_verbose_locks                   | 0                      |
| innodb_simulate_comp_failures               | 0                      |
| innodb_sort_buffer_size                     | 1048576                |
| innodb_spin_wait_delay                      | 6                      |
| innodb_stats_auto_recalc                    | ON                     |
| innodb_stats_include_delete_marked          | OFF                    |
| innodb_stats_method                         | nulls_equal            |
| innodb_stats_modified_counter               | 0                      |
| innodb_stats_on_metadata                    | OFF                    |
| innodb_stats_persistent                     | ON                     |
| innodb_stats_persistent_sample_pages        | 20                     |
| innodb_stats_sample_pages                   | 8                      |
| innodb_stats_traditional                    | ON                     |
| innodb_stats_transient_sample_pages         | 8                      |
| innodb_status_output                        | OFF                    |
| innodb_status_output_locks                  | OFF                    |
| innodb_strict_mode                          | OFF                    |
| innodb_support_xa                           | ON                     |
| innodb_sync_array_size                      | 1                      |
| innodb_sync_spin_loops                      | 30                     |
| innodb_table_locks                          | ON                     |
| innodb_thread_concurrency                   | 0                      |
| innodb_thread_sleep_delay                   | 10000                  |
| innodb_tmpdir                               |                        |
| innodb_track_changed_pages                  | OFF                    |
| innodb_undo_directory                       | .                      |
| innodb_undo_logs                            | 128                    |
| innodb_undo_tablespaces                     | 0                      |
| innodb_use_atomic_writes                    | OFF                    |
| innodb_use_fallocate                        | OFF                    |
| innodb_use_global_flush_log_at_trx_commit   | ON                     |
| innodb_use_mtflush                          | OFF                    |
| innodb_use_native_aio                       | ON                     |
| innodb_use_stacktrace                       | OFF                    |
| innodb_use_sys_malloc                       | ON                     |
| innodb_use_trim                             | OFF                    |
| innodb_version                              | 5.6.36-82.1            |
| innodb_write_io_threads                     | 4                      |
+---------------------------------------------+------------------------+
180 rows in set (0.00 sec)

**Spooky** · 02.09.2018, 06:48

Dieser Fehler sollte in Contao 4.6.1 eigentlich behoben sein: https://github.com/contao/contao/issues/28

**ollibraun** · 02.09.2018, 10:53

Zitat von Spooky

Dieser Fehler sollte in Contao 4.6.1 eigentlich behoben sein: https://github.com/contao/contao/issues/28

Wohl nicht so ganz, oder es ist etwas anderes. Der Manager hat die 4.6.2 geladen, siehe auch hier:

Code:

  - Installing contao/image (0.3.7): Downloading (100%)
  - Installing contao/core-bundle (4.6.2): Downloading (100%)
  - Installing contao/calendar-bundle (4.6.2): Downloading (100%)
  - Installing contao/comments-bundle (4.6.2): Downloading (100%)
  - Installing contao/faq-bundle (4.6.2): Downloading (100%)
  - Installing contao/listing-bundle (4.6.2): Downloading (100%)
  - Installing toflar/psr6-symfony-http-cache-store (1.1.2): Downloading (100%)
  - Installing symfony/polyfill-php72 (v1.9.0): Downloading (100%)
  - Installing symfony/var-dumper (v4.1.4): Downloading (100%)
  - Installing symfony/web-profiler-bundle (v4.1.4): Downloading (100%)
  - Installing zendframework/zend-eventmanager (3.2.1): Downloading (100%)
  - Installing zendframework/zend-code (3.3.1): Downloading (100%)
  - Installing ocramius/proxy-manager (2.2.1): Downloading (100%)
  - Installing symfony/proxy-manager-bridge (v4.1.4): Downloading (100%)
  - Installing monolog/monolog (1.23.0): Downloading (100%)
  - Installing symfony/monolog-bridge (v4.1.4): Downloading (100%)
  - Installing symfony/monolog-bundle (v3.3.0): Downloading (100%)
  - Installing symfony/dotenv (v4.1.4): Downloading (100%)
  - Installing symfony/debug-bundle (v4.1.4): Downloading (100%)
  - Installing ua-parser/uap-php (v3.5.0): Downloading (100%)
  - Installing paragonie/random_compat (v2.0.17): Downloading (100%)
  - Installing nelmio/security-bundle (2.5.1): Downloading (100%)
  - Installing lexik/maintenance-bundle (v2.1.5): Downloading (100%)
  - Installing sensiolabs/ansi-to-html (v1.1.3): Downloading (100%)
  - Installing contao/installation-bundle (4.6.2): Downloading (100%)
  - Installing contao/manager-bundle (4.6.2): Downloading (100%)
  - Installing contao/news-bundle (4.6.2): Downloading (100%)
  - Installing contao/newsletter-bundle (4.6.2): Downloading (100%)

Ist der Fehler vielleicht von 4.6.1 auf 4.6.2 wieder reingekommen?

**tab** · 02.09.2018, 12:20

Zitat von Spooky

Dieser Fehler sollte in Contao 4.6.1 eigentlich behoben sein: https://github.com/contao/contao/issues/28

Hmm. für mich als relativen Laien sieht das so aus, als ob Leo und du euch da irgendwie missverstanden habt. Wird das 4.5 Update, in das er die beiden Felder mit eingebaut hat, denn auch bei einem Update von 4.4 auf 4.6 ausgeführt?

**ollibraun** · 02.09.2018, 13:31

Zitat von tab

Hmm. für mich als relativen Laien sieht das so aus, als ob Leo und du euch da irgendwie missverstanden habt. Wird das 4.5 Update, in das er die beiden Felder mit eingebaut hat, denn auch bei einem Update von 4.4 auf 4.6 ausgeführt?

Leider kann man über den Manager wohl nicht in einzelnen Schritten updaten. Mir wird nur "Latest 4.6" oder eben "4.4" angeboten.

**Spooky** · 02.09.2018, 13:49

Zitat von tab

Hmm. für mich als relativen Laien sieht das so aus, als ob Leo und du euch da irgendwie missverstanden habt. Wird das 4.5 Update, in das er die beiden Felder mit eingebaut hat, denn auch bei einem Update von 4.4 auf 4.6 ausgeführt?

Ja, wird auch ausgeführt

**Spooky** · 03.09.2018, 08:25

Für den zweiten Fehler solltest du ein Ticket auf Github öffnen: https://github.com/contao/contao/issues

**ollibraun** · 03.09.2018, 14:43

Zitat von Spooky

Für den zweiten Fehler solltest du ein Ticket auf Github öffnen: https://github.com/contao/contao/issues

Das war ein guter Tipp, vielen Dank! Ich habe - wie in einem dortigen Thread vorgeschlagen - die beiden folgenden Tabellen gelöscht, bevor das Install-Tool anspringt (beide Tabellen werden neu angelegt, Newsletter nutze ich nicht):

tl_newsletter_recipients
tl_search

Danach lief das Install-Tool durch.

**stomfohrde** · 09.10.2019, 20:52

ich scheinen wohl einen ähnlichen fehler zu haben:

HTML-Code:

[2019-10-09 12:31:31] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2019-10-09 12:31:32] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'INSERT INTO tl_comments (`tstamp`, `land`) VALUES (1570617092, 'deutschland')':  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'land' in 'field list'" at /homepages/20/d467602785/htdocs/cm4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 80 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'INSERT INTO tl_comments (`tstamp`, `land`) VALUES (1570617092, 'deutschland')':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'land' in 'field list' at /homepages/20/d467602785/htdocs/cm4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:80, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'land' in 'field list' at /homepages/20/d467602785/htdocs/cm4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'land' in 'field list' at /homepages/20/d467602785/htdocs/cm4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} [

kann mir hier jemand weiter helfen?

Danke schon mal und Gruß