Install failed with MySQL v8

I'm trying to install MySQL v8 but I saw some errors, bellow is my docker-compose file
version: "3.8"
services:
  mysql:
    image: mysql:8.0
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: shopware
      MYSQL_USER: shopware
      MYSQL_PASSWORD: shopware
  shopware:
    image: shyim/shopware:<IP_ADDRESS>-php8.1.13
    environment:
      APP_SECRET: wjMHHxmts4ah1fTquytZJQbB6onGrCE3V7Ti45FkZXVkGoZzR57w1cZ75WZ6xqFp
      INSTANCE_ID: 7chE97XKxKwstQO5Xlyg5Zek3DPDImqZhWkKMcAL9GJg7noB
      APP_URL: http://localhost
      DATABASE_HOST: mysql
      DATABASE_URL: mysql://shopware:shopware@mysql:3306/shopware
      INSTALL_LOCALE: vi-VN
      INSTALL_CURRENCY: VND
    ports:
      - 80:80

and here is the log file, It's ok if I used MySQL v5
2023-01-04 22:19:09 shopware6platform-mysql-1     | 2023-01-04 15:19:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-01-04 22:19:09 shopware6platform-shopware-1  | Waiting for database connection...
2023-01-04 22:19:09 shopware6platform-mysql-1     | 2023-01-04 15:19:09+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-01-04 22:19:09 shopware6platform-mysql-1     | 2023-01-04 15:19:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-01-04 22:19:10 shopware6platform-mysql-1     | 2023-01-04 15:19:10+00:00 [Note] [Entrypoint]: Initializing database files
2023-01-04 22:19:10 shopware6platform-mysql-1     | 2023-01-04T15:19:10.027646Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-01-04 22:19:10 shopware6platform-mysql-1     | 2023-01-04T15:19:10.029405Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.31) initializing of server in progress as process 80
2023-01-04 22:19:10 shopware6platform-mysql-1     | 2023-01-04T15:19:10.056188Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-04 22:19:11 shopware6platform-mysql-1     | 2023-01-04T15:19:11.740637Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-04 22:19:14 shopware6platform-shopware-1  | Waiting for database connection...
2023-01-04 22:19:14 shopware6platform-mysql-1     | 2023-01-04T15:19:14.798510Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2023-01-04 22:19:19 shopware6platform-shopware-1  | Waiting for database connection...
2023-01-04 22:19:19 shopware6platform-mysql-1     | 2023-01-04 15:19:19+00:00 [Note] [Entrypoint]: Database files initialized
2023-01-04 22:19:19 shopware6platform-mysql-1     | 2023-01-04 15:19:19+00:00 [Note] [Entrypoint]: Starting temporary server
2023-01-04 22:19:19 shopware6platform-mysql-1     | 2023-01-04T15:19:19.739942Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-01-04 22:19:19 shopware6platform-mysql-1     | 2023-01-04T15:19:19.750821Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 131
2023-01-04 22:19:19 shopware6platform-mysql-1     | 2023-01-04T15:19:19.796185Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04T15:19:20.288509Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04T15:19:20.681282Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04T15:19:20.681347Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04T15:19:20.685526Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04T15:19:20.722186Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04T15:19:20.722287Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.31'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2023-01-04 22:19:20 shopware6platform-mysql-1     | 2023-01-04 15:19:20+00:00 [Note] [Entrypoint]: Temporary server started.
2023-01-04 22:19:20 shopware6platform-mysql-1     | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-01-04 22:19:22 shopware6platform-mysql-1     | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
2023-01-04 22:19:22 shopware6platform-mysql-1     | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
2023-01-04 22:19:24 shopware6platform-shopware-1  | Waiting for database connection...
2023-01-04 22:19:26 shopware6platform-mysql-1     | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
2023-01-04 22:19:26 shopware6platform-mysql-1     | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
2023-01-04 22:19:26 shopware6platform-mysql-1     | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2023-01-04 22:19:26 shopware6platform-mysql-1     | 2023-01-04 15:19:26+00:00 [Note] [Entrypoint]: Creating database shopware
2023-01-04 22:19:26 shopware6platform-mysql-1     | 2023-01-04 15:19:26+00:00 [Note] [Entrypoint]: Creating user shopware
2023-01-04 22:19:26 shopware6platform-mysql-1     | 2023-01-04 15:19:26+00:00 [Note] [Entrypoint]: Giving user shopware access to schema shopware
2023-01-04 22:19:26 shopware6platform-mysql-1     |
2023-01-04 22:19:26 shopware6platform-mysql-1     | 2023-01-04 15:19:26+00:00 [Note] [Entrypoint]: Stopping temporary server
2023-01-04 22:19:26 shopware6platform-mysql-1     | 2023-01-04T15:19:26.558004Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.31).
2023-01-04 22:19:28 shopware6platform-mysql-1     | 2023-01-04T15:19:28.292559Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31)  MySQL Community Server - GPL.
2023-01-04 22:19:28 shopware6platform-mysql-1     | 2023-01-04 15:19:28+00:00 [Note] [Entrypoint]: Temporary server stopped
2023-01-04 22:19:28 shopware6platform-mysql-1     |
2023-01-04 22:19:28 shopware6platform-mysql-1     | 2023-01-04 15:19:28+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2023-01-04 22:19:28 shopware6platform-mysql-1     |
2023-01-04 22:19:28 shopware6platform-mysql-1     | 2023-01-04T15:19:28.861180Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-01-04 22:19:28 shopware6platform-mysql-1     | 2023-01-04T15:19:28.862814Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-01-04 22:19:28 shopware6platform-mysql-1     | 2023-01-04T15:19:28.872870Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-04 22:19:29 shopware6platform-shopware-1  | Waiting for database connection...
2023-01-04 22:19:29 shopware6platform-mysql-1     | 2023-01-04T15:19:29.141788Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-04 22:19:29 shopware6platform-mysql-1     | 2023-01-04T15:19:29.423766Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-01-04 22:19:29 shopware6platform-mysql-1     | 2023-01-04T15:19:29.423837Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-01-04 22:19:29 shopware6platform-mysql-1     | 2023-01-04T15:19:29.427713Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-01-04 22:19:29 shopware6platform-mysql-1     | 2023-01-04T15:19:29.459673Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-01-04 22:19:29 shopware6platform-mysql-1     | 2023-01-04T15:19:29.459734Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.31'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2023-01-04 22:19:34 shopware6platform-shopware-1  | mysql (<IP_ADDRESS>:3306) open
2023-01-04 22:19:40 shopware6platform-shopware-1  | Prepare installation
2023-01-04 22:19:40 shopware6platform-shopware-1  |
2023-01-04 22:19:40 shopware6platform-shopware-1  | Created database `shopware`
2023-01-04 22:19:40 shopware6platform-shopware-1  | Imported base schema.sql
2023-01-04 22:19:40 shopware6platform-shopware-1  |
2023-01-04 22:19:40 shopware6platform-shopware-1  |
2023-01-04 22:19:40 shopware6platform-shopware-1  |
2023-01-04 22:19:40 shopware6platform-shopware-1  | Get collection for identifier: "core"
2023-01-04 22:19:40 shopware6platform-shopware-1  | migrate Migrations
2023-01-04 22:19:41 shopware6platform-shopware-1  |    0/538 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0%
2023-01-04 22:19:42 shopware6platform-shopware-1  |   13/538 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   2%
2023-01-04 22:19:44 shopware6platform-shopware-1  |   22/538 [=░░░░░░░░░░░░░░░░░░░░░░░░░░░]   4%
2023-01-04 22:19:45 shopware6platform-shopware-1  |   34/538 [=░░░░░░░░░░░░░░░░░░░░░░░░░░░]   6%
2023-01-04 22:19:45 shopware6platform-shopware-1  |   52/538 [==░░░░░░░░░░░░░░░░░░░░░░░░░░]   9%
2023-01-04 22:19:46 shopware6platform-shopware-1  |   54/538 [==░░░░░░░░░░░░░░░░░░░░░░░░░░]  10%
2023-01-04 22:19:47 shopware6platform-shopware-1  |   73/538 [===░░░░░░░░░░░░░░░░░░░░░░░░░]  13%
2023-01-04 22:19:53 shopware6platform-shopware-1  |   89/538 [====░░░░░░░░░░░░░░░░░░░░░░░░]  16%
2023-01-04 22:19:54 shopware6platform-shopware-1  |   95/538 [====░░░░░░░░░░░░░░░░░░░░░░░░]  17%
2023-01-04 22:19:55 shopware6platform-shopware-1  |  108/538 [=====░░░░░░░░░░░░░░░░░░░░░░░]  20%
2023-01-04 22:19:56 shopware6platform-shopware-1  |  123/538 [======░░░░░░░░░░░░░░░░░░░░░░]  22%
2023-01-04 22:19:57 shopware6platform-shopware-1  |  139/538 [=======░░░░░░░░░░░░░░░░░░░░░]  25%
2023-01-04 22:19:57 shopware6platform-shopware-1  |  156/538 [========░░░░░░░░░░░░░░░░░░░░]  28%
2023-01-04 22:19:58 shopware6platform-shopware-1  |  162/538 [========░░░░░░░░░░░░░░░░░░░░]  30%
2023-01-04 22:20:00 shopware6platform-shopware-1  |  168/538 [========░░░░░░░░░░░░░░░░░░░░]  31%
2023-01-04 22:20:01 shopware6platform-shopware-1  |  180/538 [=========░░░░░░░░░░░░░░░░░░░]  33%
2023-01-04 22:20:02 shopware6platform-shopware-1  |  187/538 [=========░░░░░░░░░░░░░░░░░░░]  34%
2023-01-04 22:20:03 shopware6platform-shopware-1  |  196/538 [==========░░░░░░░░░░░░░░░░░░]  36%
2023-01-04 22:20:03 shopware6platform-shopware-1  | 15:20:03 ERROR     [app] Migration: "Shopware\Core\Migration\V6_3\Migration1580218617RefactorShippingMethodPrice" failed: "An exception occurred while executing 'CREATE TRIGGER shipping_method_price_new_price_update BEFORE UPDATE ON shipping_method_price
2023-01-04 22:20:03 shopware6platform-shopware-1  |             FOR EACH ROW
2023-01-04 22:20:03 shopware6platform-shopware-1  |             BEGIN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                 IF @TRIGGER_DISABLED IS NULL OR @TRIGGER_DISABLED = 0 THEN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                 IF (NEW.price != OLD.price OR (NEW.price IS NOT NULL AND OLD.price IS NULL))
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         OR (NEW.currency_id != OLD.currency_id OR (NEW.currency_id IS NOT NULL AND OLD.currency_id IS NULL))
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         AND (NEW.currency_price = OLD.currency_price OR (NEW.currency_price IS NULL AND OLD.currency_price IS NULL)) THEN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                     SET NEW.currency_price = JSON_OBJECT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         CONCAT("c", LOWER(HEX(NEW.currency_id))),
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         JSON_OBJECT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                             "net", NEW.price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                             "gross", NEW.price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                             "linked", false,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                             "currencyId", LOWER(HEX(NEW.currency_id))
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         )
2023-01-04 22:20:03 shopware6platform-shopware-1  |                     );
2023-01-04 22:20:03 shopware6platform-shopware-1  |                 ELSEIF (NEW.price = OLD.price OR NEW.price IS NULL)
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         AND (NEW.currency_id = OLD.currency_id OR NEW.currency_id IS NULL)
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         AND (NEW.currency_price != OLD.currency_price OR (OLD.currency_price IS NULL AND NEW.currency_price IS NOT NULL)) THEN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                     SET NEW.price = JSON_UNQUOTE(JSON_EXTRACT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         NEW.currency_price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NEW.currency_price), "$[0]")), ".gross")
2023-01-04 22:20:03 shopware6platform-shopware-1  |                     )) + 0.0;
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  |                     SET NEW.currency_id = UNHEX(JSON_UNQUOTE(JSON_EXTRACT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         NEW.currency_price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                         CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NEW.currency_price), "$[0]")), ".currencyId")
2023-01-04 22:20:03 shopware6platform-shopware-1  |                     )));
2023-01-04 22:20:03 shopware6platform-shopware-1  |                 END IF;
2023-01-04 22:20:03 shopware6platform-shopware-1  |                 END IF;
2023-01-04 22:20:03 shopware6platform-shopware-1  |             END;':
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  | SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)"
2023-01-04 22:20:03 shopware6platform-shopware-1  |  204/538 [==========░░░░░░░░░░░░░░░░░░]  37% ---------- ----------------------
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Action     Number of migrations
2023-01-04 22:20:03 shopware6platform-shopware-1  |  ---------- ----------------------
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Migrated   205 out of 538
2023-01-04 22:20:03 shopware6platform-shopware-1  |  ---------- ----------------------
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  | 15:20:03 CRITICAL  [console] Error thrown while running command "system:install --create-database --force".  JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NEW.currency_price), "$[0]")), ".gross")\n                    )) + 0.0;\n\n                    SET NEW.currency_id = UNHEX(JSON_UNQUOTE(JSON_EXTRACT(\n                        NEW.currency_price,\n                        CONCAT("$.",  JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NEW.currency_price), "$[0]")), ".gross")\n                      )) + 0.0;\n  \n                      SET NEW.currency_id = UNHEX(JSON_UNQUOTE(JSON_EXTRACT(\n                          NEW.currency_price,\n                          CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NEW.currency_price), "$[0]")), ".currencyId")\n                      )));\n                  END IF;\n                  END IF;\n              END;':\n  \n  SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)\n  Trace: \n  #0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDO\Exception))\n  #1 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'An exception oc...')\n  #2 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'CREATE TRIGGER ...', Array)\n  #3 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1538): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'CREATE TRIGGER ...', Array, Array)\n  #4 /var/www/html/vendor/shopware/core/Framework/Migration/MigrationStep.php(117): Doctrine\DBAL\Connection->executeStatement('CREATE TRIGGER ...', Array)\n  #5 /var/www/html/vendor/shopware/core/Migration/V6_3/Migration1580218617RefactorShippingMethodPrice.php(76): Shopware\Core\Framework\Migration\MigrationStep->createTrigger(Object(Doctrine\DBAL\Connection), 'CREATE TRIGGER ...')\n  #6 /var/www/html/vendor/shopware/core/Migration/V6_3/Migration1580218617RefactorShippingMethodPrice.php(22): Shopware\Core\Migration\V6_3\Migration1580218617RefactorShippingMethodPrice->createUpdateTrigger(Object(Doctrine\DBAL\Connection))\n  #7 /var/www/html/vendor/shopware/core/Framework/Migration/MigrationRuntime.php(47): Shopware\Core\Migration\V6_3\Migration1580218617RefactorShippingMethodPrice->update(Object(Doctrine\DBAL\Connection))\n  #8 /var/www/html/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(59): Shopware\Core\Framework\Migration\MigrationRuntime->migrate(Object(Shopware\Core\Framework\Migration\MigrationSource), NULL, 0)\n  #9 /var/www/html/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(161): Shopware\Core\Framework\Migration\Command\MigrationCommand->getMigrationGenerator(Object(Shopware\Core\Framework\Migration\MigrationCollection), NULL, 0)\n  #10 /var/www/html/vendor/shopware/core/Framework/Migration/Command/MigrationCommand.php(103): Shopware\Core\Framework\Migration\Command\MigrationCommand->runMigrationForIdentifier(Object(Symfony\Component\Console\Input\ArrayInput), 'core', 0, NULL)\n  #11 /var/www/html/vendor/symfony/console/Command/Command.php(298): Shopware\Core\Framework\Migration\Command\MigrationCommand->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n  #12 /var/www/html/vendor/shopware/core/Maintenance/System/Command/SystemInstallCommand.php(192): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n  #13 /var/www/html/vendor/shopware/core/Maintenance/System/Command/SystemInstallCommand.php(158): Shopware\Core\Maintenance\System\Command\SystemInstallCommand->runCommands(Array, Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n  #14 /var/www/html/vendor/symfony/console/Command/Command.php(298): Shopware\Core\Maintenance\System\Command\SystemInstallCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Shopware\Core\Framework\Adapter\Console\ShopwareStyle))\n  #15 /var/www/html/vendor/symfony/console/Application.php(1058): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n  #16 /var/www/html/vendor/symfony/framework-bundle/Console/Application.php(96): Symfony\Component\Console\Application->doRunCommand(Object(Shopware\Core\Maintenance\System\Command\SystemInstallCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n  #17 /var/www/html/vendor/symfony/console/Application.php(301): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand(Object(Shopware\Core\Maintenance\System\Command\SystemInstallCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n  #18 /var/www/html/vendor/symfony/framework-bundle/Console/Application.php(82): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n  #19 /var/www/html/vendor/symfony/console/Application.php(171): Symfony\Bundle\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))\n  #20 /var/www/html/bin/console(77): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))\n  #21 {main}  """]
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  | In MigrationCommand.php line 168:
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Migration error: An exception occurred while executing 'CREATE TRIGGER ship
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ping_method_price_new_price_update BEFORE UPDATE ON shipping_method_price
2023-01-04 22:20:03 shopware6platform-shopware-1  |               FOR EACH ROW
2023-01-04 22:20:03 shopware6platform-shopware-1  |               BEGIN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                   IF @TRIGGER_DISABLED IS NULL OR @TRIGGER_DISABLED = 0 THEN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                   IF (NEW.price != OLD.price OR (NEW.price IS NOT NULL AND OL
2023-01-04 22:20:03 shopware6platform-shopware-1  |   D.price IS NULL))
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           OR (NEW.currency_id != OLD.currency_id OR (NEW.curr
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ency_id IS NOT NULL AND OLD.currency_id IS NULL))
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           AND (NEW.currency_price = OLD.currency_price OR (NE
2023-01-04 22:20:03 shopware6platform-shopware-1  |   W.currency_price IS NULL AND OLD.currency_price IS NULL)) THEN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                       SET NEW.currency_price = JSON_OBJECT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           CONCAT("c", LOWER(HEX(NEW.currency_id))),
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           JSON_OBJECT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                               "net", NEW.price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                               "gross", NEW.price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                               "linked", false,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                               "currencyId", LOWER(HEX(NEW.currency_id))
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           )
2023-01-04 22:20:03 shopware6platform-shopware-1  |                       );
2023-01-04 22:20:03 shopware6platform-shopware-1  |                   ELSEIF (NEW.price = OLD.price OR NEW.price IS NULL)
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           AND (NEW.currency_id = OLD.currency_id OR NEW.curre
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ncy_id IS NULL)
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           AND (NEW.currency_price != OLD.currency_price OR (O
2023-01-04 22:20:03 shopware6platform-shopware-1  |   LD.currency_price IS NULL AND NEW.currency_price IS NOT NULL)) THEN
2023-01-04 22:20:03 shopware6platform-shopware-1  |                       SET NEW.price = JSON_UNQUOTE(JSON_EXTRACT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           NEW.currency_price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NE
2023-01-04 22:20:03 shopware6platform-shopware-1  |   W.currency_price), "$[0]")), ".gross")
2023-01-04 22:20:03 shopware6platform-shopware-1  |                       )) + 0.0;
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  |                       SET NEW.currency_id = UNHEX(JSON_UNQUOTE(JSON_EXTRACT(
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           NEW.currency_price,
2023-01-04 22:20:03 shopware6platform-shopware-1  |                           CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NE
2023-01-04 22:20:03 shopware6platform-shopware-1  |   W.currency_price), "$[0]")), ".currencyId")
2023-01-04 22:20:03 shopware6platform-shopware-1  |                       )));
2023-01-04 22:20:03 shopware6platform-shopware-1  |                   END IF;
2023-01-04 22:20:03 shopware6platform-shopware-1  |                   END IF;
2023-01-04 22:20:03 shopware6platform-shopware-1  |               END;':
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  |   SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
2023-01-04 22:20:03 shopware6platform-shopware-1  |   d binary logging is enabled (you *might* want to use the less safe log_bin_
2023-01-04 22:20:03 shopware6platform-shopware-1  |   trust_function_creators variable)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Trace:
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(1
2023-01-04 22:20:03 shopware6platform-shopware-1  |   82): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An excepti
2023-01-04 22:20:03 shopware6platform-shopware-1  |   on oc...', Object(Doctrine\DBAL\Driver\PDO\Exception))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #1 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(1
2023-01-04 22:20:03 shopware6platform-shopware-1  |   59): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver
2023-01-04 22:20:03 shopware6platform-shopware-1  |   \PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'An excepti
2023-01-04 22:20:03 shopware6platform-shopware-1  |   on oc...')
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #2 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\
2023-01-04 22:20:03 shopware6platform-shopware-1  |   DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception),
2023-01-04 22:20:03 shopware6platform-shopware-1  |   'CREATE TRIGGER ...', Array)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #3 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1538
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBA
2023-01-04 22:20:03 shopware6platform-shopware-1  |   L\Driver\PDO\Exception), 'CREATE TRIGGER ...', Array, Array)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #4 /var/www/html/vendor/shopware/core/Framework/Migration/MigrationStep.php
2023-01-04 22:20:03 shopware6platform-shopware-1  |   (117): Doctrine\DBAL\Connection->executeStatement('CREATE TRIGGER ...', Arr
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ay)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #5 /var/www/html/vendor/shopware/core/Migration/V6_3/Migration1580218617Ref
2023-01-04 22:20:03 shopware6platform-shopware-1  |   actorShippingMethodPrice.php(76): Shopware\Core\Framework\Migration\Migrati
2023-01-04 22:20:03 shopware6platform-shopware-1  |   onStep->createTrigger(Object(Doctrine\DBAL\Connection), 'CREATE TRIGGER ...
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ')
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #6 /var/www/html/vendor/shopware/core/Migration/V6_3/Migration1580218617Ref
2023-01-04 22:20:03 shopware6platform-shopware-1  |   actorShippingMethodPrice.php(22): Shopware\Core\Migration\V6_3\Migration158
2023-01-04 22:20:03 shopware6platform-shopware-1  |   0218617RefactorShippingMethodPrice->createUpdateTrigger(Object(Doctrine\DBA
2023-01-04 22:20:03 shopware6platform-shopware-1  |   L\Connection))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #7 /var/www/html/vendor/shopware/core/Framework/Migration/MigrationRuntime.
2023-01-04 22:20:03 shopware6platform-shopware-1  |   php(47): Shopware\Core\Migration\V6_3\Migration1580218617RefactorShippingMe
2023-01-04 22:20:03 shopware6platform-shopware-1  |   thodPrice->update(Object(Doctrine\DBAL\Connection))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #8 /var/www/html/vendor/shopware/core/Framework/Migration/Command/Migration
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Command.php(59): Shopware\Core\Framework\Migration\MigrationRuntime->migrat
2023-01-04 22:20:03 shopware6platform-shopware-1  |   e(Object(Shopware\Core\Framework\Migration\MigrationSource), NULL, 0)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #9 /var/www/html/vendor/shopware/core/Framework/Migration/Command/Migration
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Command.php(161): Shopware\Core\Framework\Migration\Command\MigrationComman
2023-01-04 22:20:03 shopware6platform-shopware-1  |   d->getMigrationGenerator(Object(Shopware\Core\Framework\Migration\Migration
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Collection), NULL, 0)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #10 /var/www/html/vendor/shopware/core/Framework/Migration/Command/Migratio
2023-01-04 22:20:03 shopware6platform-shopware-1  |   nCommand.php(103): Shopware\Core\Framework\Migration\Command\MigrationComma
2023-01-04 22:20:03 shopware6platform-shopware-1  |   nd->runMigrationForIdentifier(Object(Symfony\Component\Console\Input\ArrayI
2023-01-04 22:20:03 shopware6platform-shopware-1  |   nput), 'core', 0, NULL)
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #11 /var/www/html/vendor/symfony/console/Command/Command.php(298): Shopware
2023-01-04 22:20:03 shopware6platform-shopware-1  |   \Core\Framework\Migration\Command\MigrationCommand->execute(Object(Symfony\
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Component\Console\Input\ArrayInput), Object(Shopware\Core\Framework\Adapter
2023-01-04 22:20:03 shopware6platform-shopware-1  |   \Console\ShopwareStyle))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #12 /var/www/html/vendor/shopware/core/Maintenance/System/Command/SystemIns
2023-01-04 22:20:03 shopware6platform-shopware-1  |   tallCommand.php(192): Symfony\Component\Console\Command\Command->run(Object
2023-01-04 22:20:03 shopware6platform-shopware-1  |   (Symfony\Component\Console\Input\ArrayInput), Object(Shopware\Core\Framewor
2023-01-04 22:20:03 shopware6platform-shopware-1  |   k\Adapter\Console\ShopwareStyle))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #13 /var/www/html/vendor/shopware/core/Maintenance/System/Command/SystemIns
2023-01-04 22:20:03 shopware6platform-shopware-1  |   tallCommand.php(158): Shopware\Core\Maintenance\System\Command\SystemInstal
2023-01-04 22:20:03 shopware6platform-shopware-1  |   lCommand->runCommands(Array, Object(Shopware\Core\Framework\Adapter\Console
2023-01-04 22:20:03 shopware6platform-shopware-1  |   \ShopwareStyle))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #14 /var/www/html/vendor/symfony/console/Command/Command.php(298): Shopware
2023-01-04 22:20:03 shopware6platform-shopware-1  |   \Core\Maintenance\System\Command\SystemInstallCommand->execute(Object(Symfo
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ny\Component\Console\Input\ArgvInput), Object(Shopware\Core\Framework\Adapt
2023-01-04 22:20:03 shopware6platform-shopware-1  |   er\Console\ShopwareStyle))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #15 /var/www/html/vendor/symfony/console/Application.php(1058): Symfony\Com
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ponent\Console\Command\Command->run(Object(Symfony\Component\Console\Input\
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #16 /var/www/html/vendor/symfony/framework-bundle/Console/Application.php(9
2023-01-04 22:20:03 shopware6platform-shopware-1  |   6): Symfony\Component\Console\Application->doRunCommand(Object(Shopware\Cor
2023-01-04 22:20:03 shopware6platform-shopware-1  |   e\Maintenance\System\Command\SystemInstallCommand), Object(Symfony\Componen
2023-01-04 22:20:03 shopware6platform-shopware-1  |   t\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\Console
2023-01-04 22:20:03 shopware6platform-shopware-1  |   Output))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #17 /var/www/html/vendor/symfony/console/Application.php(301): Symfony\Bund
2023-01-04 22:20:03 shopware6platform-shopware-1  |   le\FrameworkBundle\Console\Application->doRunCommand(Object(Shopware\Core\M
2023-01-04 22:20:03 shopware6platform-shopware-1  |   aintenance\System\Command\SystemInstallCommand), Object(Symfony\Component\C
2023-01-04 22:20:03 shopware6platform-shopware-1  |   onsole\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOut
2023-01-04 22:20:03 shopware6platform-shopware-1  |   put))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #18 /var/www/html/vendor/symfony/framework-bundle/Console/Application.php(8
2023-01-04 22:20:03 shopware6platform-shopware-1  |   2): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\C
2023-01-04 22:20:03 shopware6platform-shopware-1  |   onsole\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOut
2023-01-04 22:20:03 shopware6platform-shopware-1  |   put))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #19 /var/www/html/vendor/symfony/console/Application.php(171): Symfony\Bund
2023-01-04 22:20:03 shopware6platform-shopware-1  |   le\FrameworkBundle\Console\Application->doRun(Object(Symfony\Component\Cons
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ole\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput
2023-01-04 22:20:03 shopware6platform-shopware-1  |   ))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #20 /var/www/html/bin/console(77): Symfony\Component\Console\Application->r
2023-01-04 22:20:03 shopware6platform-shopware-1  |   un(Object(Symfony\Component\Console\Input\ArgvInput))
2023-01-04 22:20:03 shopware6platform-shopware-1  |   #21 {main}
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:03 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  | In AbstractMySQLDriver.php line 128:
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |   An exception occurred while executing 'CREATE TRIGGER shipping_method_price
2023-01-04 22:20:04 shopware6platform-shopware-1  |   _new_price_update BEFORE UPDATE ON shipping_method_price
2023-01-04 22:20:04 shopware6platform-shopware-1  |               FOR EACH ROW
2023-01-04 22:20:04 shopware6platform-shopware-1  |               BEGIN
2023-01-04 22:20:04 shopware6platform-shopware-1  |                   IF @TRIGGER_DISABLED IS NULL OR @TRIGGER_DISABLED = 0 THEN
2023-01-04 22:20:04 shopware6platform-shopware-1  |                   IF (NEW.price != OLD.price OR (NEW.price IS NOT NULL AND OL
2023-01-04 22:20:04 shopware6platform-shopware-1  |   D.price IS NULL))
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           OR (NEW.currency_id != OLD.currency_id OR (NEW.curr
2023-01-04 22:20:04 shopware6platform-shopware-1  |   ency_id IS NOT NULL AND OLD.currency_id IS NULL))
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           AND (NEW.currency_price = OLD.currency_price OR (NE
2023-01-04 22:20:04 shopware6platform-shopware-1  |   W.currency_price IS NULL AND OLD.currency_price IS NULL)) THEN
2023-01-04 22:20:04 shopware6platform-shopware-1  |                       SET NEW.currency_price = JSON_OBJECT(
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           CONCAT("c", LOWER(HEX(NEW.currency_id))),
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           JSON_OBJECT(
2023-01-04 22:20:04 shopware6platform-shopware-1  |                               "net", NEW.price,
2023-01-04 22:20:04 shopware6platform-shopware-1  |                               "gross", NEW.price,
2023-01-04 22:20:04 shopware6platform-shopware-1  |                               "linked", false,
2023-01-04 22:20:04 shopware6platform-shopware-1  |                               "currencyId", LOWER(HEX(NEW.currency_id))
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           )
2023-01-04 22:20:04 shopware6platform-shopware-1  |                       );
2023-01-04 22:20:04 shopware6platform-shopware-1  |                   ELSEIF (NEW.price = OLD.price OR NEW.price IS NULL)
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           AND (NEW.currency_id = OLD.currency_id OR NEW.curre
2023-01-04 22:20:04 shopware6platform-shopware-1  |   ncy_id IS NULL)
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           AND (NEW.currency_price != OLD.currency_price OR (O
2023-01-04 22:20:04 shopware6platform-shopware-1  |   LD.currency_price IS NULL AND NEW.currency_price IS NOT NULL)) THEN
2023-01-04 22:20:04 shopware6platform-shopware-1  |                       SET NEW.price = JSON_UNQUOTE(JSON_EXTRACT(
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           NEW.currency_price,
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NE
2023-01-04 22:20:04 shopware6platform-shopware-1  |   W.currency_price), "$[0]")), ".gross")
2023-01-04 22:20:04 shopware6platform-shopware-1  |                       )) + 0.0;
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |                       SET NEW.currency_id = UNHEX(JSON_UNQUOTE(JSON_EXTRACT(
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           NEW.currency_price,
2023-01-04 22:20:04 shopware6platform-shopware-1  |                           CONCAT("$.", JSON_UNQUOTE(JSON_EXTRACT(JSON_KEYS(NE
2023-01-04 22:20:04 shopware6platform-shopware-1  |   W.currency_price), "$[0]")), ".currencyId")
2023-01-04 22:20:04 shopware6platform-shopware-1  |                       )));
2023-01-04 22:20:04 shopware6platform-shopware-1  |                   END IF;
2023-01-04 22:20:04 shopware6platform-shopware-1  |                   END IF;
2023-01-04 22:20:04 shopware6platform-shopware-1  |               END;':
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |   SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
2023-01-04 22:20:04 shopware6platform-shopware-1  |   d binary logging is enabled (you *might* want to use the less safe log_bin_
2023-01-04 22:20:04 shopware6platform-shopware-1  |   trust_function_creators variable)
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  | In Exception.php line 18:
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |   SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
2023-01-04 22:20:04 shopware6platform-shopware-1  |   d binary logging is enabled (you *might* want to use the less safe log_bin_
2023-01-04 22:20:04 shopware6platform-shopware-1  |   trust_function_creators variable)
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  | In PDOConnection.php line 55:
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |   SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
2023-01-04 22:20:04 shopware6platform-shopware-1  |   d binary logging is enabled (you *might* want to use the less safe log_bin_
2023-01-04 22:20:04 shopware6platform-shopware-1  |   trust_function_creators variable)
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:04 shopware6platform-shopware-1  | system:install [--create-database] [--drop-database] [--basic-setup] [-f|--force] [--no-assign-theme] [--shop-name SHOP-NAME] [--shop-email SHOP-EMAIL] [--shop-locale SHOP-LOCALE] [--shop-currency SHOP-CURRENCY] [--skip-jwt-keys-generation]
2023-01-04 22:20:04 shopware6platform-shopware-1  |
2023-01-04 22:20:06 shopware6platform-shopware-1  |
2023-01-04 22:20:06 shopware6platform-shopware-1  |  [ERROR] Cannot create private key /var/www/html/config/jwt/private.pem, it
2023-01-04 22:20:06 shopware6platform-shopware-1  |          already exists.
2023-01-04 22:20:06 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |  [OK] User "admin" successfully created.
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  | 15:20:07 CRITICAL  [console] Error thrown while running command "sales-channel:create:storefront --name=Storefront --url='http://localhost'". Message: "b"""An exception occurred while executing 'INSERT INTO `sales_channel` (`id`, `type_id`, `language_id`, `customer_group_id`, `currency_id`, `payment_method_id`, `shipping_method_id`, `country_id`, `navigation_category_id`, `navigation_category_version_id`, `footer_category_version_id`, `service_category_version_id`, `home_cms_page_version_id`, `navigation_category_depth`, `tax_calculation_type`, `access_key`, `created_at`) VALUES ('¡╩▀®6\'FhîªØ\0gÚÉm','è$0Ç¨.LqòF1KW|°+','/╗_ÔÔÜMp¬XT╬|ÒÔ\v','¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í','ÀÊUK\fÞG═é¾¼øÐ└▀╩','┘@╬\vÅÒENä±ÿ╩Øvs<','så├Nû═AÔ½:ù¨?n¦í','lQãÆI¡NJ▒═┐ðë¯2é','Cò▓MÖ?B(ò\x15Ë¨╗kÁ\v','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','3','horizontal','SWSCVEZMULHHBLLYQK5JWMHJOA','2023-01-04 15:20:07.856');':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'home_cms_page_version_id' in 'field list'" ["exception" => Doctrine\DBAL\Exception\InvalidFieldNameException { …},"command" => "sales-channel:create:storefront --name=Storefront --url='http://localhost'","message" => b"""  An exception occurred while executing 'INSERT INTO `sales_channel` (`id`, `type_id`, `language_id`, `customer_group_id`, `currency_id`, `payment_method_id`, `shipping_method_id`, `country_id`, `navigation_category_id`, `navigation_category_version_id`, `footer_category_version_id`, `service_category_version_id`, `home_cms_page_version_id`, `navigation_category_depth`, `tax_calculation_type`, `access_key`, `created_at`) VALUES ('¡╩▀®6\'FhîªØ\0gÚÉm','è$0Ç¨.LqòF1KW|°+','/╗_ÔÔÜMp¬XT╬|ÒÔ\v','¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í','ÀÊUK\fÞG═é¾¼øÐ└▀╩','┘@╬\vÅÒENä±ÿ╩Øvs<','så├Nû═AÔ½:ù¨?n¦í','lQãÆI¡NJ▒═┐ðë¯2é','Cò▓MÖ?B(ò\x15Ë¨╗kÁ\v','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','\x0F®\x1CÒÚjK┬¥K┘╬u,4%','3','horizontal','SWSCVEZMULHHBLLYQK5JWMHJOA','2023-01-04 15:20:07.856');':\n  \n  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'home_cms_page_version_id' in 'field list'  """]
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  | In AbstractMySQLDriver.php line 79:
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |   An exception occurred while executing 'INSERT INTO `sales_channel` (`id`, `
2023-01-04 22:20:07 shopware6platform-shopware-1  |   type_id`, `language_id`, `customer_group_id`, `currency_id`, `payment_metho
2023-01-04 22:20:07 shopware6platform-shopware-1  |   d_id`, `shipping_method_id`, `country_id`, `navigation_category_id`, `navig
2023-01-04 22:20:07 shopware6platform-shopware-1  |   ation_category_version_id`, `footer_category_version_id`, `service_category
2023-01-04 22:20:07 shopware6platform-shopware-1  |   _version_id`, `home_cms_page_version_id`, `navigation_category_depth`, `tax
2023-01-04 22:20:07 shopware6platform-shopware-1  |   _calculation_type`, `access_key`, `created_at`) VALUES ('��ߩ6\'Fh���\0g��m
2023-01-04 22:20:07 shopware6platform-shopware-1  |   ','�$0��.Lq�F1KW|�+','/�_���Mp�XT�|��
','ϽPӍAح��OȽ�','��UK
�G͂������
2023-01-04 22:20:07 shopware6platform-shopware-1  |   �','�@�
��EN���ʝvs<','s��N��A��:��?nݡ','lQƒI�NJ�ͿЉ�2�','C��M�?B(����k
2023-01-04 22:20:07 shopware6platform-shopware-1  |   �
','���jK¾K��u,4%','���jK¾K��u,4%','���jK¾K��u,4%','���jK¾K��u
2023-01-04 22:20:07 shopware6platform-shopware-1  |   ,4%','3','horizontal','SWSCVEZMULHHBLLYQK5JWMHJOA','2023-01-04 15:20:07.856
2023-01-04 22:20:07 shopware6platform-shopware-1  |   ');':
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'home_cms_page_versi
2023-01-04 22:20:07 shopware6platform-shopware-1  |   on_id' in 'field list'
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  | In Exception.php line 18:
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'home_cms_page_versi
2023-01-04 22:20:07 shopware6platform-shopware-1  |   on_id' in 'field list'
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  | In PDOConnection.php line 55:
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'home_cms_page_versi
2023-01-04 22:20:07 shopware6platform-shopware-1  |   on_id' in 'field list'
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:07 shopware6platform-shopware-1  | sales-channel:create:storefront [--id ID] [--name NAME] [--languageId LANGUAGEID] [--snippetSetId SNIPPETSETID] [--currencyId CURRENCYID] [--paymentMethodId PAYMENTMETHODID] [--shippingMethodId SHIPPINGMETHODID] [--countryId COUNTRYID] [--typeId [TYPEID]] [--customerGroupId CUSTOMERGROUPID] [--navigationCategoryId NAVIGATIONCATEGORYID] [--url URL]
2023-01-04 22:20:07 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  | 15:20:08 CRITICAL  [console] Error thrown while running command "theme:change --all Storefront". Message: "An exception occurred while executing 'SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id`' with params ["\x2f\xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\x7c\xe3\xe2\x0b"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_channel.translation.home_slot_config' in 'field list'" ["exception" => Doctrine\DBAL\Exception\InvalidFieldNameException { …},"command" => "theme:change --all Storefront","message" => """  An exception occurred while executing 'SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id`' with params ["\x2f\xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\x7c\xe3\xe2\x0b"]:\n  \n  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_channel.translation.home_slot_config' in 'field list'  """]
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  | In AbstractMySQLDriver.php line 79:
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |   An exception occurred while executing 'SELECT `sales_channel`.`id` as `sale
2023-01-04 22:20:08 shopware6platform-shopware-1  |   s_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_
2023-01-04 22:20:08 shopware6platform-shopware-1  |   channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`cust
2023-01-04 22:20:08 shopware6platform-shopware-1  |   omer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currenc
2023-01-04 22:20:08 shopware6platform-shopware-1  |   y_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as
2023-01-04 22:20:08 shopware6platform-shopware-1  |    `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `
2023-01-04 22:20:08 shopware6platform-shopware-1  |   sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_cha
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nnel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analytics
2023-01-04 22:20:08 shopware6platform-shopware-1  |   Id`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationC
2023-01-04 22:20:08 shopware6platform-shopware-1  |   ategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_chan
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_dept
2023-01-04 22:20:08 shopware6platform-shopware-1  |   h` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_cate
2023-01-04 22:20:08 shopware6platform-shopware-1  |   gory_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_categ
2023-01-04 22:20:08 shopware6platform-shopware-1  |   ory_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel
2023-01-04 22:20:08 shopware6platform-shopware-1  |   `.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`
2023-01-04 22:20:08 shopware6platform-shopware-1  |   , `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFoote
2023-01-04 22:20:08 shopware6platform-shopware-1  |   rId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hrefla
2023-01-04 22:20:08 shopware6platform-shopware-1  |   ngDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortNam
2023-01-04 22:20:08 shopware6platform-shopware-1  |   e`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculation
2023-01-04 22:20:08 shopware6platform-shopware-1  |   Type`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_ch
2023-01-04 22:20:08 shopware6platform-shopware-1  |   annel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`a
2023-01-04 22:20:08 shopware6platform-shopware-1  |   ctive` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sal
2023-01-04 22:20:08 shopware6platform-shopware-1  |   es_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_ch
2023-01-04 22:20:08 shopware6platform-shopware-1  |   annel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_chann
2023-01-04 22:20:08 shopware6platform-shopware-1  |   el.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_cha
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nnel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channe
2023-01-04 22:20:08 shopware6platform-shopware-1  |   l.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.
2023-01-04 22:20:08 shopware6platform-shopware-1  |   analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_chan
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sa
2023-01-04 22:20:08 shopware6platform-shopware-1  |   les_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at`
2023-01-04 22:20:08 shopware6platform-shopware-1  |   as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_
2023-01-04 22:20:08 shopware6platform-shopware-1  |   at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as
2023-01-04 22:20:08 shopware6platform-shopware-1  |    `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.
2023-01-04 22:20:08 shopware6platform-shopware-1  |   updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.trans
2023-01-04 22:20:08 shopware6platform-shopware-1  |   lation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sa
2023-01-04 22:20:08 shopware6platform-shopware-1  |   les_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translatio
2023-01-04 22:20:08 shopware6platform-shopware-1  |   n.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_cha
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nnel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sa
2023-01-04 22:20:08 shopware6platform-shopware-1  |   les_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled
2023-01-04 22:20:08 shopware6platform-shopware-1  |   `) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, CO
2023-01-04 22:20:08 shopware6platform-shopware-1  |   ALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.home
2023-01-04 22:20:08 shopware6platform-shopware-1  |   Name`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitl
2023-01-04 22:20:08 shopware6platform-shopware-1  |   e`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.trans
2023-01-04 22:20:08 shopware6platform-shopware-1  |   lation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.tra
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nslation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMeta
2023-01-04 22:20:08 shopware6platform-shopware-1  |   Description`,`sales_channel.translation.homeMetaDescription`) as `sales_cha
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nnel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALES
2023-01-04 22:20:08 shopware6platform-shopware-1  |   CE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.home
2023-01-04 22:20:08 shopware6platform-shopware-1  |   Keywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.cust
2023-01-04 22:20:08 shopware6platform-shopware-1  |   omFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .translation.customFields`) as `sales_channel.customFields`, `sales_channel
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_chan
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nel.translation.salesChannelId`, `sales_channel.translation.languageId` FRO
2023-01-04 22:20:08 shopware6platform-shopware-1  |   M `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_chann
2023-01-04 22:20:08 shopware6platform-shopware-1  |   el_id, `sales_channel.translation`.name as `sales_channel.translation.name`
2023-01-04 22:20:08 shopware6platform-shopware-1  |   , `sales_channel.translation`.home_slot_config as `sales_channel.translatio
2023-01-04 22:20:08 shopware6platform-shopware-1  |   n.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_chann
2023-01-04 22:20:08 shopware6platform-shopware-1  |   el.translation.homeEnabled`, `sales_channel.translation`.home_name as `sale
2023-01-04 22:20:08 shopware6platform-shopware-1  |   s_channel.translation.homeName`, `sales_channel.translation`.home_meta_titl
2023-01-04 22:20:08 shopware6platform-shopware-1  |   e as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`
2023-01-04 22:20:08 shopware6platform-shopware-1  |   .home_meta_description as `sales_channel.translation.homeMetaDescription`,
2023-01-04 22:20:08 shopware6platform-shopware-1  |   `sales_channel.translation`.home_keywords as `sales_channel.translation.hom
2023-01-04 22:20:08 shopware6platform-shopware-1  |   eKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.tra
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nslation.customFields`, `sales_channel.translation`.created_at as `sales_ch
2023-01-04 22:20:08 shopware6platform-shopware-1  |   annel.translation.createdAt`, `sales_channel.translation`.updated_at as `sa
2023-01-04 22:20:08 shopware6platform-shopware-1  |   les_channel.translation.updatedAt`, `sales_channel.translation`.sales_chann
2023-01-04 22:20:08 shopware6platform-shopware-1  |   el_id as `sales_channel.translation.salesChannelId`, `sales_channel.transla
2023-01-04 22:20:08 shopware6platform-shopware-1  |   tion`.language_id as `sales_channel.translation.languageId` FROM `sales_cha
2023-01-04 22:20:08 shopware6platform-shopware-1  |   nnel_translation` `sales_channel.translation` WHERE `sales_channel.translat
2023-01-04 22:20:08 shopware6platform-shopware-1  |   ion`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_c
2023-01-04 22:20:08 shopware6platform-shopware-1  |   hannel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`
2023-01-04 22:20:08 shopware6platform-shopware-1  |    LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_ch
2023-01-04 22:20:08 shopware6platform-shopware-1  |   annel`.`analytics_id` = `sales_channel.analytics`.`id`' with params ["\x2f\
2023-01-04 22:20:08 shopware6platform-shopware-1  |   xbb\x5f\xe2\xe2\x9a\x4d\x70\xaa\x58\x54\xce\x7c\xe3\xe2\x0b"]:
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_channel.trans
2023-01-04 22:20:08 shopware6platform-shopware-1  |   lation.home_slot_config' in 'field list'
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  | In Exception.php line 18:
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_channel.trans
2023-01-04 22:20:08 shopware6platform-shopware-1  |   lation.home_slot_config' in 'field list'
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  | In PDOStatement.php line 117:
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_channel.trans
2023-01-04 22:20:08 shopware6platform-shopware-1  |   lation.home_slot_config' in 'field list'
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  | theme:change [-s|--sales-channel SALES-CHANNEL] [--all] [--no-compile] [--] [<theme-name>]
2023-01-04 22:20:08 shopware6platform-shopware-1  |
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="load configuration from file" file=/etc/supervisord.conf
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="create process:php-fpm"
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="create process:nginx"
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="create process:shopware-empty-cache"
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="stop listening"
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="try to start program" program=php-fpm
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="try to start program" program=nginx
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="try to start program" program=shopware-empty-cache
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="success to start program" program=shopware-empty-cache
2023-01-04 22:20:08 shopware6platform-shopware-1  | time="2023-01-04T15:20:08Z" level=info msg="program stopped with status:exit status 0" program=shopware-empty-cache
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: using the "epoll" event method
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: nginx/1.22.1
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: OS: Linux 5.15.49-linuxkit
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: getrlimit(RLIMIT_NOFILE): 1048576:1048576
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: start worker processes
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: start worker process 79
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: start worker process 80
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: start worker process 81
2023-01-04 22:20:08 shopware6platform-shopware-1  | 2023/01/04 15:20:08 [notice] 78#78: start worker process 82
2023-01-04 22:20:09 shopware6platform-shopware-1  | [04-Jan-2023 15:20:09] NOTICE: fpm is running, pid 76
2023-01-04 22:20:09 shopware6platform-shopware-1  | [04-Jan-2023 15:20:09] NOTICE: ready to handle connections
2023-01-04 22:20:09 shopware6platform-shopware-1  | time="2023-01-04T15:20:09Z" level=info msg="success to start program" program=php-fpm
2023-01-04 22:20:09 shopware6platform-shopware-1  | time="2023-01-04T15:20:09Z" level=info msg="success to start program" program=nginx
2023-01-04 22:20:12 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:20:12 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:20:12 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:20:09 +0000 "GET /index.php" 500
2023-01-04 22:20:12 shopware6platform-shopware-1  | 2023/01/04 15:20:12 [info] 79#79: *1 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:20:43 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:20:43 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:20:43 shopware6platform-shopware-1  | 2023/01/04 15:20:43 [info] 81#81: *3 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:20:43 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:20:43 +0000 "GET /index.php" 500
2023-01-04 22:21:13 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:21:13 +0000 "GET /index.php" 500
2023-01-04 22:21:13 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:21:13 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:21:13 shopware6platform-shopware-1  | 2023/01/04 15:21:13 [info] 82#82: *5 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:21:44 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:21:44 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:21:44 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:21:43 +0000 "GET /index.php" 500
2023-01-04 22:21:44 shopware6platform-shopware-1  | 2023/01/04 15:21:44 [info] 80#80: *7 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:22:15 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:22:14 +0000 "GET /index.php" 500
2023-01-04 22:22:15 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:22:15 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:22:15 shopware6platform-shopware-1  | 2023/01/04 15:22:15 [info] 79#79: *9 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:22:45 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:22:45 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:22:45 shopware6platform-shopware-1  | 2023/01/04 15:22:45 [info] 79#79: *11 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:22:45 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:22:45 +0000 "GET /index.php" 500
2023-01-04 22:23:15 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:23:15 +0000 "GET /index.php" 500
2023-01-04 22:23:15 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:23:15 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:23:15 shopware6platform-shopware-1  | 2023/01/04 15:23:15 [info] 79#79: *13 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:23:45 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:23:45 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:23:45 shopware6platform-shopware-1  | 2023/01/04 15:23:45 [info] 79#79: *15 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:23:45 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:23:45 +0000 "GET /index.php" 500
2023-01-04 22:24:16 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:24:16 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:24:16 shopware6platform-shopware-1  | 2023/01/04 15:24:16 [info] 79#79: *17 client <IP_ADDRESS> closed keepalive connection
2023-01-04 22:24:16 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:24:16 +0000 "GET /index.php" 500
2023-01-04 22:24:46 shopware6platform-shopware-1  | <IP_ADDRESS> -  04/Jan/2023:15:24:46 +0000 "GET /index.php" 500
2023-01-04 22:24:46 shopware6platform-shopware-1  | <IP_ADDRESS> - - [04/Jan/2023:15:24:46 +0000] "GET /admin HTTP/1.1" 500 411 "-" "curl/7.83.1"
2023-01-04 22:24:46 shopware6platform-shopware-1  | 2023/01/04 15:24:46 [info] 79#79: *19 client <IP_ADDRESS> closed keepalive connection

set env BLUE_GREEN_DEPLOYMENT: 0 then it should work

@shyim It's worked, thanks!


Need to support stat tags in Cluster config

Title: Add tags to cluster stat
Description:
Currently cluster stat consists of scope name and stat name, for example:
cluster.cluster_0.update_success
in which cluster.cluster_0 is scope name, and update_success is stat name. The prefix is empty and tags are not supported.
We have a requirement which need to add additional information to cluster Prometheus metrics. My first thought is using alt_stat_name and encoding the information into it, then use stats_config.stats_tags to extract these information as tags in Prometheus output. But I run into a problem quickly: the information contains :, which will be converted to _. That's, the extracted tag will be mutated, which is not what we want. So I need to find another way to do it.
Considering Envoy's stat supports tags, I'm thinking add tags support  to cluster config could be a better way.
Please kindly let me know if I misunderstood any thing.
CC @envoyproxy/api-shepherds

Conceptually this seems fine but I'm not sure if we have a great way to ensure that it would apply to all cluster stats since there are a lot of per cluster stats that are created throughout the code base.
@jmarantz might have thoughts here

Conceptually this seems fine but I'm not sure if we have a great way to ensure that it would apply to all cluster stats since there are a lot of per cluster stats that are created throughout the code base.
@jmarantz might have thoughts here


Regex in Email displaying two messages

When using regex in email field, it displays two messages, one that is default and other i.e. passed as message. I want to display only the message which i passed.
https://jsfiddle.net/yeoman/436rvcut/3/

You're not using this plugin. This is a different project.


Investigate why some diseases match to multiple patterns

See this comment as an example:
https://github.com/monarch-initiative/mondo/pull/2268#issue-517185148

inflammatory_disease_by_site.yaml is the correct pattern for the example in #2268
specific_infectious_disease_by_location - the variable is  MONDO:0000001 disease, it should probably be more specific, like MONDO_0005550 'infectious disease'
specific_inflammatory_disease_by_site.yaml the variable is  MONDO:0000001 disease, it should probably be more specific too, MONDO_0021166 'inflammatory disease'

Are there other cases like this, @matentzn?

I think you are right! You should fix these patterns as you suggest! Other cases of overlapping patterns:

[ ] allergic_form_of_disease.yaml	basis_in_disruption_of_process.yaml
[ ] allergic_form_of_disease.yaml	disrupts_process.yaml
[ ] allergy.yaml	environmental_stimulus.yaml
[ ] allergy.yaml	specific_infectious_disease_by_agent.yaml
[ ] autoimmune_inflammation.yaml	specific_infectious_disease_by_location.yaml
[ ] autoimmune_inflammation.yaml	specific_inflammatory_disease_by_site.yaml
[ ] basis_in_disruption_of_process.yaml	allergic_form_of_disease.yaml
[ ] basis_in_disruption_of_process.yaml	disrupts_process.yaml
[ ] disease_by_dysfunctional_structure.yaml	specific_disease_by_dysfunctional_structure.yaml
[ ] disease_series_by_gene.yaml	specific_disease_by_dysfunctional_structure.yaml
[ ] disrupts_process.yaml	allergic_form_of_disease.yaml
[ ] disrupts_process.yaml	basis_in_disruption_of_process.yaml
[ ] environmental_stimulus.yaml	allergy.yaml
[ ] hemangioma.yaml	location.yaml
[ ] inborn_metabolic_disrupts.yaml	inborn_metabolic.yaml
[ ] inborn_metabolic.yaml	inborn_metabolic_disrupts.yaml
[ ] infectious_disease_by_agent.yaml	specific_infectious_disease_by_agent.yaml
[ ] inflammatory_disease_by_site.yaml	specific_infectious_disease_by_location.yaml
[ ] inflammatory_disease_by_site.yaml	specific_inflammatory_disease_by_site.yaml
[ ] leiomyoma.yaml	location.yaml
[ ] leiomyosarcoma.yaml	location.yaml
[ ] lipoma.yaml	location.yaml
[ ] location_top.yaml	location.yaml
[ ] location.yaml	hemangioma.yaml
[ ] location.yaml	leiomyoma.yaml
[ ] location.yaml	leiomyosarcoma.yaml
[ ] location.yaml	lipoma.yaml
[ ] location.yaml	location_top.yaml
[ ] location.yaml	lymphoma.yaml
[ ] location.yaml	melanoma.yaml
[ ] location.yaml	meningioma.yaml
[ ] location.yaml	neuroendocrine_neoplasm.yaml
[ ] location.yaml	rhabdomyosarcoma.yaml
[ ] location.yaml	small_cell_carcinoma.yaml
[ ] lymphoma.yaml	location.yaml
[ ] melanoma.yaml	location.yaml
[ ] meningioma.yaml	location.yaml
[ ] neuroendocrine_neoplasm.yaml	location.yaml
[ ] rhabdomyosarcoma.yaml	location.yaml
[ ] small_cell_carcinoma.yaml	location.yaml
[ ] specific_disease_by_dysfunctional_structure.yaml	disease_by_dysfunctional_structure.yaml
[ ] specific_disease_by_dysfunctional_structure.yaml	disease_series_by_gene.yaml
[ ] specific_infectious_disease_by_agent.yaml	allergy.yaml
[ ] specific_infectious_disease_by_agent.yaml	infectious_disease_by_agent.yaml
[ ] specific_infectious_disease_by_location.yaml	autoimmune_inflammation.yaml
[ ] specific_infectious_disease_by_location.yaml	inflammatory_disease_by_site.yaml
[ ] specific_infectious_disease_by_location.yaml	specific_inflammatory_disease_by_site.yaml
[ ] specific_inflammatory_disease_by_site.yaml	autoimmune_inflammation.yaml
[ ] specific_inflammatory_disease_by_site.yaml	inflammatory_disease_by_site.yaml
[ ] specific_inflammatory_disease_by_site.yaml	specific_infectious_disease_by_location.yaml

The entire list of all disease with duplicate matches this way can be found here.

hmm, for the specific_X patterns is there a way to say that filler should be a proper subclass of disease?

I think you just have to say the variable is the more specific subclass, like  for specific_infectious_disease_by_location
it should be:
classes:
infectious disease: MONDO:0005550
anatomical structure: UBERON:0000061

@nicolevasilevsky suggestion is the only way - you cant say "proper subclass" as in "any class that is a subclass of the filler, but not the filler itself.

@cmungall Is there any problem with Nicoles suggestion?


endpoint: fix panic if restored endpoint does no longer exist in k8s

The blamed commit was intended to silence not found errors during restoration, which are expected if the corresponding pod has been deleted asynchronously while the agent was down. However, it mistakenly modified the execution flow, breaking out of the switch (rather than returning) and eventually leading to accessing a nil pointer, with the obvious ill-fated consequences.
Let's fix this by restoring the original execution flow, and add a dedicated unit test to prevent regressions.
Fixes: 40130c7a208d ("endpoint: silence metadata resolver not found errors during restoration")

Fix potential Cilium agent panic during endpoint restoration, occurring if the corresponding pod gets deleted while the agent is restarting. This regression only affects Cilium v1.16.4.

/test


Improve ergonomics & performance of pudl.etl DAG

Our initial PUDL ETL DAG has a couple of clear performance bottlenecks, and a few assets or asset groups with more dependencies than are really necessary. Modest refactoring of some of these assets or asset groups could significantly reduce how long it takes the ETL to run, and make the actual dependencies between assets clearer.
There are also a few tweaks we can make to our IO Managers and other Dagster abstractions that will make the development / migration process smoother.
- [ ] #2417
- [ ] #2376
- [ ] #2385
- [ ] #2387
- [ ] https://github.com/catalyst-cooperative/pudl/issues/2431
- [ ] https://github.com/catalyst-cooperative/pudl/issues/2293
- [ ] https://github.com/catalyst-cooperative/pudl/issues/2264
- [ ] https://github.com/catalyst-cooperative/pudl/issues/2377
- [ ] #216
- [ ] #475
- [ ] https://github.com/catalyst-cooperative/pudl/issues/2444

I'm excited about these (proposed) changes! I wonder if it makes sense to set specific goals around speedup & ergonomic improvements, so we know when the performance is "good enough" - I could see myself falling down quite the rabbit hole here if we don't do that ahead of time...

I mean... I think it's good enough as it is! It's already waaay faster than before.  But I think the big 3 parallelizations (CEMS, Excel reads, disentangling EIA transform) will really help make local development feel more responsive (since many of us have 8-10 core) and will make running full nightly builds on an 8CPU instance take... an hour? Which will save a small amount of money, but maybe more importantly let us know more about the state of the code -- not just on dev and special occasions. I don't think these 3 improvements will be very complex to implement.
But beyond that I think we should focus on getting to where we can distribute just data and not software, with the usability improvements listed above helping to make that work more pleasant and productive. @bendnorman and I outlined several groups of assets that we need to bring in (not even all of them...) and it is, uh, kind of a lot. Hopefully once we get in the groove it's a turn-the-crank kind of thing, but even still it'll take a while.


Porting the bug fixes and UX changes to primary app

This pull request is now managed with CodeReviewHub. Refresh.


Date of administration data

In the readme, you mention that "Department of Health has also begun reporting doses on the date of administration. This data is not available in this repository yet."
Would you be able to point me to where DOH reports doses by administration date? I've spent quite a while scouring their website but can't seem to find it 😅

Hey, it's in the jurisdiction slide deck:

It'll only give you the last 7 days of doses by date of administration.

Ah, I'd found that but assumed it was just date of reporting data again as from a brief look it seemed to be the same numbers.
Doing a few more comparisons now, state clinics seem to match exactly the existing data in all.json, whereas primary and aged care have differences.
A little disappointing as when I read your note, I was hoping I could find some data that wasn't affected by the recent state clinic reporting glitches 😂


add register and until to ansible invoker pull runtime images tasks

retries and delays in ansible only applies to with until
They are being ignored, this PR adds the until and changes to the new form of loop from whith_items
Ref: https://docs.ansible.com/ansible/latest/user_guide/playbooks_loops.html#do-until-loops
If the until parameter isn’t defined, the value for the retries parameter is forced to 1.

Codecov Report

Merging #3806 into master will not change coverage.
The diff coverage is n/a.

@@           Coverage Diff           @@
##           master    #3806   +/-   ##
=======================================
  Coverage   75.13%   75.13%
=======================================
  Files         132      132
  Lines        6140     6140
  Branches      376      376
=======================================
  Hits         4613     4613
  Misses       1527     1527

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update 76dadd2...3ce5cdf. Read the comment docs.

Playground2/3332/ 🏃

Playground2/3333/ 🔵


Add placeholders for getters and setters

Resolves #170

Given https://github.com/emberjs/rfcs/pull/281 and the increased bug potential I've decided to not merge this implementation.


Compiling issues

Hi,
thanks for sharing. Can you provide more detail on how to get this running on a pi?
Running "make" results in errors due to missing references in the Makefile (nbprojects folder)

Honestly, it's been so long since I've had to deal with make files that I've forgotten how to use them properly.  I used Netbeans to set up this project, which created a whole bunch of files unrelated to the core code.  I decided not to commit those files since they weren't really relevant, but I must have not noticed the reference to the project folder in the makefile.
For my projects that use this "library", I have been referencing the source files directly. I have not configured it to compile into any sort of true library file to link against.
Now for getting it to run on a Pi, I have set up Netbeans to use the Pi as a build and run target. Here's an article I found that should get you started.  It looks pretty close to the setup I have.
https://pirobotblog.wordpress.com/2017/03/18/setting-up-netbeans-for-the-raspberry-pi/
You will need to link with the wiringPi library.  With the basic setup I have, the built executable gets placed in ./home/pi/.netbeans/remote/{RPi IP Address}/{Host name of machine with Netbeans}/{path to project folder}/dist/Release/GNU-Linux.  It's a long and complicated path, but it works and I haven't spent the time to simplify it.
Hopefully this helps.

I'm also struggling to get the example to compile:
/tmp/cc2HIuvo.o: In function `random8()':
DemoReel100.cpp:(.text+0xb4): undefined reference to `rand16seed'
/tmp/cc2HIuvo.o: In function `random16()':
DemoReel100.cpp:(.text+0x10c): undefined reference to `rand16seed'
/tmp/cc2HIuvo.o: In function `main':
DemoReel100.cpp:(.text+0x66c): undefined reference to `PiLED::PiLED(CRGB*, int)'
/tmp/cc2HIuvo.o: In function `rainbow()':
DemoReel100.cpp:(.text+0x8e4): undefined reference to `fill_rainbow(CRGB*, int, unsigned char, unsigned char)'
/tmp/cc2HIuvo.o: In function `confetti()':
DemoReel100.cpp:(.text+0x9e0): undefined reference to `fadeToBlackBy(CRGB*, unsigned short, unsigned char)'
DemoReel100.cpp:(.text+0xa68): undefined reference to `hsv2rgb_rainbow(CHSV const&, CRGB&)'
/tmp/cc2HIuvo.o: In function `sinelon()':
DemoReel100.cpp:(.text+0xaa8): undefined reference to `fadeToBlackBy(CRGB*, unsigned short, unsigned char)'
DemoReel100.cpp:(.text+0xb2c): undefined reference to `hsv2rgb_rainbow(CHSV const&, CRGB&)'
/tmp/cc2HIuvo.o: In function `bpm()':
DemoReel100.cpp:(.text+0xc3c): undefined reference to `ColorFromPalette(CRGBPalette16 const&, unsigned char, unsigned char, TBlendType)'
DemoReel100.cpp:(.text+0xc84): undefined reference to `PartyColors_p'
/tmp/cc2HIuvo.o: In function `juggle()':
DemoReel100.cpp:(.text+0xca8): undefined reference to `fadeToBlackBy(CRGB*, unsigned short, unsigned char)'
DemoReel100.cpp:(.text+0xd4c): undefined reference to `hsv2rgb_rainbow(CHSV const&, CRGB&)'
/tmp/cc2HIuvo.o: In function `__static_initialization_and_destruction_0(int, int)':
DemoReel100.cpp:(.text+0xde0): undefined reference to `PiLED::PiLED()'
/tmp/cc2HIuvo.o: In function `PiLED::show()':
DemoReel100.cpp:(.text._ZN5PiLED4showEv[_ZN5PiLED4showEv]+0x20): undefined reference to `PiLED::show(unsigned char)'
collect2: error: ld returned 1 exit status

@zinefer It looks like the compiler isn't seeing the PiLED/FastLED source. Make sure it's been added to your project properly.  I'm afraid I can't be much help other than that since there are so many ways to set up a project and I'm not even that familiar with how it works inside NetBeans, which is the IDE I used.

It is finding the files. If I change the path it throws a different error about that.
It's alright - I am worried this isn't going to work outside netbeans and that's not something I am interested in using for this project. Thanks!


1.10.2 cropConfig.json being completely ignored by farming station

Issue Description:
Farming station refuses to right click any crops. Even when I test with just the default cropConfig.json. file it smacks wheat like there's no right click option.
What happens:
Crop not being right-click harvested
What you expected to happen:
Crop being right-click harvested
Steps to reproduce:

Fill out cropConfig.json (or even let it use defaults)
Set up farming station
Crops grow and get smacked down instead of right-click harvested
...

Affected Versions (Do not use "latest"):
MC Version:
Forge Version: 2043
Core Mod Version:
Mod Version:

EnderIO: 1.10.2-<IP_ADDRESS>-beta
EnderCore: 1.10.2-<IP_ADDRESS>-beta
Minecraft: 1.10.2
Forge: 2043

Your most recent log file where the issue was present:
Doesn't seem relevant in this case aside from verifying if the RightClickCropHandler is registering, and yes it is.  If you need the fml client log I can supply it, but that is the only log file possible to give, as it isn't a crash and gives no errors.

Hopefully at some point the farming station can be made aware of the right click crops added to endercore's crop config, but as this isn't a bug like I assumed it must be, I'm closing the issue.

Right-click harvesting would be very useless for the farming station. Stuff would just drop on the ground...


Fix VideoDome Dispose

https://forum.babylonjs.com/t/videodome-clicktoplay-and-dispose-maybe-not-as-expected/28271/2

👍


Missing Gene Ontology annotations for noncoding RNA (Obtain from QuickGO or RNA central)

We are missing GO annotations to RNA
2 good sources of RNA GO annotations are
1- The EBI maintained QuickGO website (https://www.ebi.ac.uk/QuickGO/)
2- RNAcentral (https://rnacentral.org/).
An example being Malat1 where
The Open Targets Platform has an entry for MALAT1 and no available GO annotations in the platform (https://www.targetvalidation.org/target/ENSG00000251562).
2- UniProt does not have it as entry (rightly so since it is not a protein)
3- Ensembl has the entry but no GO annotations (https://www.ensembl.org/Homo_sapiens/Gene/Phenotype?db=core;g=ENSG00000251562;r=11:65497688-65506516)
4- RNAcentral has both the entry AND GO annotations (https://rnacentral.org/rna/URS0000A77400/9606)
5- EBI QuickGO website has the entry and the GO annotations (https://www.ebi.ac.uk/QuickGO/annotations?geneProductId=URS0000A77400_9606).
Wold it be possible to use the EBI QuickGO API to get these annotations?

Positive enhancement on the annotation of RNA targets. We'll eventually allocate appropriate resources. Not a short term priority unfortunately.

Closing as captured as part of a bigger task to revamp the GO annotation data feed #1037


Notifications bar is no longer working

Describe the bug
We received some user feedback from NO stating that the notification pane is not visible. In order to fix this, we will need to investigate any recent system changes and updates.
From Christian: "We are no longer able to click into notifications we receive. We can still see the text of them in the case notes section of each case file, and we also see the number of notifications by the bell symbol in the top right of the page, but the small bell icon in the top right corner of the homepage no longer pops up a display of recent notifications when clicked. When we click into the bell as normal, nothing pops up. As always, feel free to call or email with any questions."
Steps to reproduce
List any steps to reproduce behavior

Click on bell icon on top right.
You will see that the notifications pane does not open.

Expected behavior
When we click on the bell icon, the notifications pane should open/close and should also list recent notifications. This should work for both NO and Hawaii.
Checklist

[x] Indicate bug severity on the right

Additional context
Add any other context or screenshots about the feature request here.

When I click on the bell the notification pane will appear, but when I click on the bell again it doesn't close it
https://github.com/PublicDataWorks/complaint-manager/assets/134408135/eedb8aaf-b8c3-445b-88f5-7aae3cf73edb

Verified notifications bar is working as expected - bell icon can now open and close the notification pane.
Hawaii
https://github.com/PublicDataWorks/complaint-manager/assets/134408135/c8fc2157-cb3c-4d5f-8839-b86ab82f762a
NOIPM
https://github.com/PublicDataWorks/complaint-manager/assets/134408135/ee907f32-5425-413e-860c-d186d669f855


Let developer filter hyperlinks (and other content?)

Provide a way for the developer to filter links in messages. Some options:

Developer could provide a custom hyperlink click handler to handle navigation
Developer could provide a handler to filter out unwanted content (including but not limited to hyperlinks).

For tracking, the idea began here: https://github.com/Microsoft/BotFramework-WebChat/issues/199

I say wait until someone asks for this. I don't want to spend time adding configuration for hypothetical scenarios.

agree with @billba feedback.


update requirements.txt

update requirements.txt

@vansin Thank for your interests!
How about just renaming main.py to app.py?
And can I ask that this modification is for huggingface space, right?

@vansin Thank for your interests! How about just renaming main.py to app.py? And can I ask that this modification is for huggingface space, right?

yes

I forget to checkout a new branch~ and push it to the pr branch sorry~