admin.ERROR [5d4b6de3] [516a146] [3] [Eccube\Log\Logger:log:64] - システムエラーが発生しました。 
["DateTime::__construct(): Failed to parse time string (2014-03-20 11:09:26""") at position 19 ("): Unexpected character",
"C:\\xampp\\htdocs\\DIR\\app\\Plugin\\DataMigration4\\Controller\\Admin\\ConfigController.php",1605,"#0
 C:\\xampp\\htdocs\\DIR\\app\\Plugin\\DataMigration4\\Controller\\Admin\\ConfigController.php(1605): DateTime->__construct('2014-03-20 11:0...', Object(DateTimeZone))\n#1
 C:\\xampp\\htdocs\\DIR\\app\\Plugin\\DataMigration4\\Controller\\Admin\\ConfigController.php(569): Plugin\\DataMigration4\\Controller\\Admin\\ConfigController->convertTz('2014-03-20 11:0...')\n#2
 C:\\xampp\\htdocs\\DIR\\app\\Plugin\\DataMigration4\\Controller\\Admin\\ConfigController.php(398): Plugin\\DataMigration4\\Controller\\Admin\\ConfigController->saveToP(Object(Doctrine\\DBAL\\Connection), 
'C:\\\\xampp\\\\htdocs...', 'dtb_products', 'dtb_product')\n#3
 C:\\xampp\\htdocs\\DIR\\app\\Plugin\\DataMigration4\\Controller\\Admin\\ConfigController.php(120): Plugin\\DataMigration4\\Controller\\Admin\\ConfigController->saveProduct(Object(Doctrine\\DBAL\\Connection), 
'C:\\\\xampp\\\\htdocs...')\n#4
 C:\\xampp\\htdocs\\DIR\\vendor\\symfony\\http-kernel\\HttpKernel.php(151): Plugin\\DataMigration4\\Controller\\Admin\\ConfigController->index(Object(Symfony\\Component\\HttpFoundation\\Request), Object(Doctrine\\DBAL\\Connection))\n#5
 C:\\xampp\\htdocs\\DIR\\vendor\\symfony\\http-kernel\\HttpKernel.php(68): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)\n#6
 C:\\xampp\\htdocs\\DIR\\vendor\\symfony\\http-kernel\\Kernel.php(200): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)\n#7
 C:\\xampp\\htdocs\\DIR\\index.php(76): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#8 {main}"] [POST, /DIR/html/data_migration4/config, ::1, http://localhost/DIR/html/data_migration4/config, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36]
[y-m-d h:m:s] admin.INFO [5d4b6de3] [516a146] [3] [Eccube\Log\Logger:log:64] - LOGIC END ["data_migration4_admin_config"] [POST, /DIR/html/data_migration4/config, ::1, http://localhost/DIR/html/data_migration4/config, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36]

### mtb_device_type
update dtb_order set device_type_id = null where device_type_id not in (select id from mtb_device_type)

### dtb_mail_history

// 確認
select t1.id, t1.order_id, t2.id from dtb_mail_history t1
left join dtb_order t2 on t1.order_id = t2.id
where t2.id is null and t1.order_id is not null

// 更新
delete from dtb_mail_history where id in (
select id (select t1.id from dtb_mail_history t1 left join dtb_order t2 on t1.order_id = t2.id where t2.id is null and t1.order_id is not null) as tmp
);

### dtb_customer_favorite_product

// 確認
select t1.id, t1.customer_id , t2.id from dtb_customer_favorite_product t1
left join dtb_customer t2 on t1.customer_id = t2.id
where t2.id is null and t1.customer_id is not null

// 更新
delete from dtb_customer_favorite_product where id in (
select t1.id from dtb_customer_favorite_product t1
left join dtb_customer t2 on t1.customer_id = t2.id
where t2.id is null and t1.customer_id is not null
);

### dtb_shipping

// 確認
select t1.id, t1.order_id , t2.id from dtb_shipping t1
left join dtb_order t2 on t1.order_id = t2.id
where t2.id is null and t1.order_id is not null

// 更新
delete from dtb_shipping where id in (
select t1.id from dtb_shipping t1
left join dtb_order t2 on t1.order_id = t2.id
where t2.id is null and t1.order_id is not null
);

### dtb_delivery_fee
// 確認
select t1.id, t1.delivery_id , t2.id from dtb_delivery_fee t1
left join dtb_delivery t2 on t1.delivery_id = t2.id
where t2.id is null and t1.delivery_id is not null

// 更新
delete from dtb_delivery_fee where id in (
select t1.id from dtb_delivery_fee t1
left join dtb_delivery t2 on t1.delivery_id = t2.id
where t2.id is null and t1.delivery_id is not null
);

### dtb_customer_address

// 確認
select t1.id, t1.customer_id , t2.id from dtb_customer_address t1
left join dtb_customer t2 on t1.customer_id = t2.id
where t2.id is null and t1.customer_id is not null

// 更新
delete from dtb_customer_address where id in (
select t1.id from dtb_customer_address t1
left join dtb_customer t2 on t1.customer_id = t2.id
where t2.id is null and t1.customer_id is not null
)

### データ不整合用のダミー商品を作成

select nextval('dtb_product_id_seq')
select nextval('dtb_product_class_id_seq')

xxx, yyy

insert into dtb_product
(id, name, product_status_id, create_date ,update_date, discriminator_type )
values
(xxx, 'データ移行用', 3, '2020-07-09 00:00:00','2020-07-09 00:00:00', 'product')

insert into dtb_product_class
(id, product_id, sale_type_id , stock_unlimited ,price02 ,visible ,currency_code ,point_rate ,create_date ,update_date, discriminator_type )
values
(yyy, xxx, 1, true, 1000, true, 'JPY', 1, '2020-07-09 00:00:00','2020-07-09 00:00:00', 'productclass')

### 存在しないproduct_idを持ってる受注明細にダミー商品を紐付け
// 確認
select t1.id, t1.product_id, t2.id from dtb_order_item t1
left join dtb_product t2 on t1.product_id = t2.id
where t2.id is null and t1.product_id is not null

// 更新
update dtb_order_item set product_id = xxx, product_class_id = yyy
where id in (
select t1.id from dtb_order_item t1
left join dtb_product t2 on t1.product_id = t2.id
where t2.id is null and t1.product_id is not null
)

### 存在しないproduct_class_idを持ってる受注明細にダミー商品を紐付け

// 確認
select t1.id, t1.product_class_id, t2.id from dtb_order_item t1
left join dtb_product_class t2 on t1.product_class_id = t2.id
where t2.id is null and t1.product_class_id is not null

// 更新
update dtb_order_item set product_id = xxx, product_class_id = yyy
where id in (
select t1.id from dtb_order_item t1
left join dtb_product_class t2 on t1.product_class_id = t2.id
where t2.id is null and t1.product_class_id is not null
)

# 存在しないproduct_idを持ってるproduct_classを削除
// 確認
select t1.id, t1.product_id , t2.id from dtb_product_class as t1
left join dtb_product t2 on t1.product_id = t2.id
where t2.id is null and t1.product_id is not null

// 更新(product_stock)
delete from dtb_product_stock  where product_class_id in (
select t1.id from dtb_product_class as t1
left join dtb_product t2 on t1.product_id = t2.id where t2.id is null and t1.product_id is not null
)
// 更新(product_class)
delete from dtb_product_class  where id in (
select t1.id from dtb_product_class as t1
left join dtb_product t2 on t1.product_id = t2.id where t2.id is null and t1.product_id is not null
)

# dtb_product_category

## product
// 確認
select t1.product_id, t2.id from dtb_product_category t1
left join dtb_product t2 on t1.product_id = t2.id
where t1.product_id is not null and t2.id is null;

// 削除
delete from dtb_product_category
where product_id in (
select t1.product_id from dtb_product_category t1
left join dtb_product t2 on t1.product_id = t2.id
where t1.product_id is not null and t2.id is null)

## category
// 確認
select t1.category_id, t2.id from dtb_product_category t1
left join dtb_category t2 on t1.category_id = t2.id
where t1.category_id is not null and t2.id is null;

// 削除
delete from dtb_product_category where category_id in (
select t1.category_id from dtb_product_category t1
left join dtb_category t2 on t1.category_id = t2.id
where t1.category_id is not null and t2.id is null)

システムエラーが発生しました。 ["An exception occurred while executing 'INSERT INTO dtb_customer_favorite_product (create_date, update_date, customer_id, product_id, discriminator_type) VALUES (?, ?, ?, ?, ?)' with params [\"2022-01-31 03:32:13+0000\", \"2022-01-31 03:32:13+0000\", 6247, 314, \"customerfavoriteproduct\"]:\n\nSQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"dtb_customer_favorite_product_pkey\"\nDETAIL:  Key (id)=(6) already exists.","/Users/chihiro_adachi/repos/eccube_co/local/hornet-hsrzrlpa/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgre

 [2019-07-02 15:24:26] admin.ERROR [0b870052c09629c9f2032e6c6fb6cfe5] [30a330b] [2] [Eccube\Log\Logger:log:64] - システムエラーが発生しました。 ["An exception occurred while executing 'ALTER TABLE dtb_class_category ADD CONSTRAINT FK_9B0D1DBAB462FB2A FOREIGN KEY (class_name_id) REFERENCES dtb_class_name (id) NOT DEFERRABLE INITIALLY IMMEDIATE':\n\nSQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table \"dtb_class_category\" violates foreign key constraint \"fk_9b0d1dbab462fb2a\"\nDETAIL:  Key (class_name_id)=(0) is not present in table \"dtb_class_name\".","/var/ec-cube/src/Eccube/Service/

An exception occurred while executing 'INSERT INTO dtb_order_item (id, order_id, product_id, product_class_id, shipping_id, rounding_type_id, tax_type_id, tax_display_type_id, order_item_type_id, product_name, product_code, class_name1, class_name2, class_category_name1, class_category_name2, price, quantity, tax, tax_rate, tax_rule_id, currency_code, processor_name, point_rate, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);' with params ["1", "1", "2", "10", 1, 1, 1, 1, 1, "\u304a\u306a\u3079", "nabe-01", null, null, "", "", "1650", "1", 0, null, 1, "JPY", null, "10", "orderitem", "2", "2", "3", "11", null, 1, 1, 1, 1, "\u304a\u306a\u3079\u30ec\u30b7\u30d4", "recipe-01", null, null, "", "", "100", "1", 0, null, 1, "JPY", null, "10", "orderitem"]:

SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "tax_rate" violates not-null constraint
DETAIL: Failing row contains (1, 1, 2, 10, 1, 1, 1, 1, 1, おなべ, nabe-01, null, null, , , 1650.00, 1, 0, null, 1, JPY, null, 10, orderitem).

INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\HttpKernel\KernelInterface::getCacheDir()" might add "string" as a native return type declaration in the future. Do the same in implementation "Eccube\Kernel" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\HttpKernel\KernelInterface::getLogDir()" might add "string" as a native return type declaration in the future. Do the same in implementation "Eccube\Kernel" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\HttpKernel\KernelInterface::registerBundles()" might add "iterable" as a native return type declaration in the future. Do the same in implementation "Eccube\Kernel" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "ArrayAccess::offsetExists()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Eccube\Entity\AbstractEntity" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "ArrayAccess::offsetSet()" might add "void" as a native return type declaration in the future. Do the same in implementation "Eccube\Entity\AbstractEntity" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "ArrayAccess::offsetGet()" might add "mixed" as a native return type declaration in the future. Do the same in implementation "Eccube\Entity\AbstractEntity" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "ArrayAccess::offsetUnset()" might add "void" as a native return type declaration in the future. Do the same in implementation "Eccube\Entity\AbstractEntity" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	Deprecated: Eccube\Entity\Customer implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\HttpKernel\Bundle\Bundle::getContainerExtension()" might add "?ExtensionInterface" as a native return type declaration in the future. Do the same in child class "Eccube\EccubeBundle" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\HttpKernel\Bundle\Bundle::getContainerExtension()" might add "?ExtensionInterface" as a native return type declaration in the future. Do the same in child class "Plugin\Api42\Bundle\ApiBundle" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Doctrine\DBAL\Types\Type::convertToDatabaseValue()" might add "mixed" as a native return type declaration in the future. Do the same in child class "Eccube\Doctrine\DBAL\Types\UTCDateTimeType" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Doctrine\DBAL\Types\Type::convertToPHPValue()" might add "mixed" as a native return type declaration in the future. Do the same in child class "Eccube\Doctrine\DBAL\Types\UTCDateTimeType" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Doctrine\DBAL\Types\Type::requiresSQLCommentHint()" might add "bool" as a native return type declaration in the future. Do the same in child class "Eccube\Doctrine\DBAL\Types\UTCDateTimeType" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Doctrine\DBAL\Types\Type::convertToDatabaseValue()" might add "mixed" as a native return type declaration in the future. Do the same in child class "Eccube\Doctrine\DBAL\Types\UTCDateTimeTzType" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Doctrine\DBAL\Types\Type::convertToPHPValue()" might add "mixed" as a native return type declaration in the future. Do the same in child class "Eccube\Doctrine\DBAL\Types\UTCDateTimeTzType" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Doctrine\DBAL\Types\Type::requiresSQLCommentHint()" might add "bool" as a native return type declaration in the future. Do the same in child class "Eccube\Doctrine\DBAL\Types\UTCDateTimeTzType" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.factory.service" service is deprecated, use "session.storage.factory.native", "session.storage.factory.php_bridge" or "session.storage.factory.mock_file" instead.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native" service is deprecated, use "session.storage.factory.native" instead.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag" service is deprecated, create your own "session.storage.factory" instead.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Monolog\Formatter\FormatterInterface::format()" might add "mixed" as a native return type declaration in the future. Do the same in implementation "EasyCorp\EasyLog\EasyLogFormatter" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "base_template_class" option on Twig\Environment is deprecated since Twig 2.7.0.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setDiscount()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setDeliveryFeeTotal()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setCharge()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setTax()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setTotal()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setAddPoint()" method will require a new "$addPoint|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Order::setUsePoint()" method will require a new "$usePoint|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setTotal()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setDeliveryFeeTotal()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setDiscount()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setCharge()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setTax()" method will require a new "$total|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setAddPoint()" method will require a new "$addPoint|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: The "Eccube\Entity\Cart::setUsePoint()" method will require a new "$usePoint|int" argument in the next major version of its interface "Eccube\Entity\ItemHolderInterface", not defining it is deprecated.
{
    "exception": {}
}
INFO
15:30:35
php	Deprecated: Eccube\Entity\Member implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Class "Eccube\Entity\Member" should implement method "Symfony\Component\Security\Core\User\UserInterface::getUserIdentifier(): string": returns the identifier for this user (e.g. its username or email address).
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\Security\Core\User\UserInterface::getRoles()" might add "array" as a native return type declaration in the future. Do the same in implementation "Eccube\Entity\Member" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}
INFO
15:30:35
php	User Deprecated: Method "Symfony\Component\Security\Core\User\UserInterface::getUsername()" might add "string" as a native return type declaration in the future. Do the same in implementation "Eccube\Entity\Member" now to avoid errors or add an explicit @return annotation to suppress this message.
{
    "exception": {}
}

Unique violation: 7 ERROR:  duplicate key value violates unique constraint "dtb_delivery_time_pkey" DETAIL:  Key (id)=(1) already exists