▼テンプレート
[EC-CUBE]4.0.6-p1
[レンタルサーバ]さくらインターネットレンタルサーバー
[データベース]mysql
[導入プラグインの有無]
Coupon Plugin for EC-CUBE4
簡単ブログ Pro for EC-CUBE4
[現象]
上記プラグインをインストールしようとするとエラーが出てしまいます。
対応方法、助言を頂けますと助かります。

["An exception occurred while executing
'ALTER TABLE plg_productplus_dtb_product_data CHANGE product_item_id product_item_id INT NOT NULL':\n\nSQLSTATE[HY000]:
General error: 3780 Referencing column 'product_item_id' and referenced column 'id' in foreign key constraint 'FK_C9B2965AC3B649EE' are incompatible.",]

エラーメッセージは上記の通りで外部キー制約に関して互換性の問題が発生しているとのことです。

参照先と参照元は以下の通りです
参照元： `product_item_id` int unsigned NOT NULL
参照先： `id` int unsigned NOT NULL AUTO_INCREMENT

両テーブルの既存データは正しく登録されており、齟齬はありません。
外部キー制約を外して、再設定を行っても同じ結果となりました。

お手数ですが、よろしくお願いいたします。

plg_productplus_dtb_product_dataというテーブルは、「Coupon Plugin for EC-CUBE4」では使用していないはずです。
「Coupon Plugin for EC-CUBE4」はインストールおよび有効化できるのではないでしょうか。

----------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EC-CUBEインテグレートパートナー【ゴールド】ランク
M&I Works
URL: https://miworks.biz/
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

ご返信ありがとうございます。

別のプラグインで使用しているテーブルとなります。
仰る通り該当のプラグインでは使用していないのですが、
ログのエラー箇所（「ERROR」となっている箇所）はそこのみとなります。

>[2024-10-31 15:22:03] admin.ERROR [001dd5eb] [b9b2856] [2] [Eccube\Log\Logger:log:64] - システムエラーが発生しました。

ちなみにその後のログに下記のようなものもあるのですが、
上記のエラー後にインストールが実行し続けるということもあり得ますか？
>[2024-10-31 15:25:12] php.INFO [001dd5eb] [400c6eb] [2] [Symfony\Component\Debug\ErrorHandler:handleError:532] - User Deprecated: Not quoting the scalar "%name% %plugin_version% は EC-CUBE %eccube_version% には対応していません。続行しますか？"

> 仰る通り該当のプラグインでは使用していないのですが、
> ログのエラー箇所（「ERROR」となっている箇所）はそこのみとなります。

別のプラグインという事なので、対象のプラグインが競合などにてエラーが発生しているかと思います。
有料プラグインであれば、提供元に確認してみてください。

----------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EC-CUBEインテグレートパートナー【ゴールド】ランク
M&I Works
URL: https://miworks.biz/
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

度々すみません。

>plg_productplus_dtb_product_dataというテーブルは、「Coupon Plugin for EC-CUBE4」では使用していないはずです。

おっしゃる通り、該当のテーブルは別のプラグインで使用（作成）しており、
インストール対象のプラグインとは全く関連しないのですが、
競合エラーが発生してしまうのでしょうか？

引用：


事前に導入しているプラグインの処理が、今回導入しようとしているプラグインと競合してエラーが発生するということは起こりえます。

balisys社さんからもコメントされている通りです。

----------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EC-CUBEインテグレートパートナー【ゴールド】ランク
M&I Works
URL: https://miworks.biz/
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

関係ないテーブルでも発生し得るんですね。
一旦提供元に確認してみます。
ご回答ありがとうございました。

提供元に確認しましたが、「システムエラー」が出ていないため、わからないとのことでした。

CMSのプラグイン一覧に表示されるが、インストール実行しても出来ない（実行後もインストールボタンが表示される）とはどのような状況が発生しているかわかりますでしょうか。

ログにもエラーはありません。
以下インストールログとなります。

---------------
**************** CMBlogPro ****************
<warning>Deprecation warning: require.ec-cube/CMBlogPro is invalid, it should not contain uppercase characters. Please use ec-cube/cmblogpro instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/ContactManagement4 is invalid, it should not contain uppercase characters. Please use ec-cube/contactmanagement4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/Coupon4 is invalid, it should not contain uppercase characters. Please use ec-cube/coupon4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/CsvImportProductExt4 is invalid, it should not contain uppercase characters. Please use ec-cube/csvimportproductext4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/EccubePaymentLite4 is invalid, it should not contain uppercase characters. Please use ec-cube/eccubepaymentlite4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/HsdSameCategory is invalid, it should not contain uppercase characters. Please use ec-cube/hsdsamecategory instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/JoolenCheckedItemBlock4 is invalid, it should not contain uppercase characters. Please use ec-cube/joolencheckeditemblock4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/ProductPlus is invalid, it should not contain uppercase characters. Please use ec-cube/productplus instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/SearchPlus is invalid, it should not contain uppercase characters. Please use ec-cube/searchplus instead. Make sure you fix this as Composer 2.0 will error.</warning>
<warning>Deprecation warning: require.ec-cube/SocialLogin4 is invalid, it should not contain uppercase characters. Please use ec-cube/sociallogin4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[10.8MiB/1.52s] <warning>Warning from https://repo.packagist.org: Support for Composer 1 will be shutdown on August 1st 2025. You should upgrade to Composer 2. See https://blog.packagist.com/shutting-down-packagist-org-support-for-composer-1-x/</warning>
[146.0MiB/2.96s] Using version ^1.2 for ec-cube/CMBlogPro
[146.0MiB/2.96s] ./composer.json has been updated
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/CMBlogPro is invalid, it should not contain uppercase characters. Please use ec-cube/cmblogpro instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/ContactManagement4 is invalid, it should not contain uppercase characters. Please use ec-cube/contactmanagement4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/Coupon4 is invalid, it should not contain uppercase characters. Please use ec-cube/coupon4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/CsvImportProductExt4 is invalid, it should not contain uppercase characters. Please use ec-cube/csvimportproductext4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/EccubePaymentLite4 is invalid, it should not contain uppercase characters. Please use ec-cube/eccubepaymentlite4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/HsdSameCategory is invalid, it should not contain uppercase characters. Please use ec-cube/hsdsamecategory instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/JoolenCheckedItemBlock4 is invalid, it should not contain uppercase characters. Please use ec-cube/joolencheckeditemblock4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/ProductPlus is invalid, it should not contain uppercase characters. Please use ec-cube/productplus instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/SearchPlus is invalid, it should not contain uppercase characters. Please use ec-cube/searchplus instead. Make sure you fix this as Composer 2.0 will error.</warning>
[146.3MiB/3.18s] <warning>Deprecation warning: require.ec-cube/SocialLogin4 is invalid, it should not contain uppercase characters. Please use ec-cube/sociallogin4 instead. Make sure you fix this as Composer 2.0 will error.</warning>
[149.6MiB/3.33s] <warning>Dependency "ec-cube/plugin-installer" is also a root requirement, but is not explicitly whitelisted. Ignoring.</warning>
[149.4MiB/3.33s] Loading composer repositories with package information
[151.5MiB/5.12s] <warning>Warning from https://repo.packagist.org: Support for Composer 1 will be shutdown on August 1st 2025. You should upgrade to Composer 2. See https://blog.packagist.com/shutting-down-packagist-org-support-for-composer-1-x/</warning>
[151.5MiB/5.13s] Updating dependencies
[756.8MiB/75.13s] <warning>Package auth0/php-jwt is abandoned, you should avoid using it. Use auth0/auth0-php instead.</warning>
[756.8MiB/75.13s] <warning>Package doctrine/doctrine-cache-bundle is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package doctrine/reflection is abandoned, you should avoid using it. Use roave/better-reflection instead.</warning>
[756.8MiB/75.13s] <warning>Package easycorp/easy-log-handler is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package php-cs-fixer/diff is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package sensio/framework-extra-bundle is abandoned, you should avoid using it. Use Symfony instead.</warning>
[756.8MiB/75.13s] <warning>Package sensio/generator-bundle is abandoned, you should avoid using it. Use symfony/maker-bundle instead.</warning>
[756.8MiB/75.13s] <warning>Package setasign/fpdi-tcpdf is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package swiftmailer/swiftmailer is abandoned, you should avoid using it. Use symfony/mailer instead.</warning>
[756.8MiB/75.13s] <warning>Package symfony/class-loader is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package symfony/debug is abandoned, you should avoid using it. Use symfony/error-handler instead.</warning>
[756.8MiB/75.13s] <warning>Package symfony/inflector is abandoned, you should avoid using it. Use EnglishInflector from the String component instead.</warning>
[756.8MiB/75.13s] <warning>Package symfony/security is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package symfony/swiftmailer-bundle is abandoned, you should avoid using it. Use symfony/mailer instead.</warning>
[756.8MiB/75.13s] <warning>Package symfony/web-server-bundle is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package twig/extensions is abandoned, you should avoid using it. No replacement was suggested.</warning>
[756.8MiB/75.13s] <warning>Package zendframework/zend-code is abandoned, you should avoid using it. Use laminas/laminas-code instead.</warning>
[756.8MiB/75.13s] <warning>Package zendframework/zend-eventmanager is abandoned, you should avoid using it. Use laminas/laminas-eventmanager instead.</warning>
[757.9MiB/75.16s] Generating optimized autoload files
[760.9MiB/77.74s] <warning>Warning: Ambiguous class resolution, "Eccube\Entity\Customer" was found in both "$baseDir . '/app/proxy/entity/src/Eccube/Entity/Customer.php" and "/home/indigolamb6/www/ec-cube-dev-2023/src/Eccube/Entity/Customer.php", the first will be used.</warning>
[760.9MiB/77.74s] <warning>Warning: Ambiguous class resolution, "Eccube\Entity\Delivery" was found in both "$baseDir . '/app/proxy/entity/src/Eccube/Entity/Delivery.php" and "/home/indigolamb6/www/ec-cube-dev-2023/src/Eccube/Entity/Delivery.php", the first will be used.</warning>
[760.9MiB/77.74s] <warning>Warning: Ambiguous class resolution, "Eccube\Entity\Order" was found in both "$baseDir . '/app/proxy/entity/src/Eccube/Entity/Order.php" and "/home/indigolamb6/www/ec-cube-dev-2023/src/Eccube/Entity/Order.php", the first will be used.</warning>
[760.9MiB/77.74s] <warning>Warning: Ambiguous class resolution, "Eccube\Entity\OrderItem" was found in both "$baseDir . '/app/proxy/entity/src/Eccube/Entity/OrderItem.php" and "/home/indigolamb6/www/ec-cube-dev-2023/src/Eccube/Entity/OrderItem.php", the first will be used.</warning>
[760.9MiB/77.74s] <warning>Warning: Ambiguous class resolution, "Eccube\Entity\Product" was found in both "$baseDir . '/app/proxy/entity/src/Eccube/Entity/Product.php" and "/home/indigolamb6/www/ec-cube-dev-2023/src/Eccube/Entity/Product.php", the first will be used.</warning>
[760.9MiB/77.74s] <warning>Warning: Ambiguous class resolution, "Eccube\Entity\ProductClass" was found in both "$baseDir . '/app/proxy/entity/src/Eccube/Entity/ProductClass.php" and "/home/indigolamb6/www/ec-cube-dev-2023/src/Eccube/Entity/ProductClass.php", the first will be used.</warning>
[759.2MiB/78.45s] Memory usage: 759.22MiB (peak: 891.68MiB), time: 78.45s
--------------

コマンドラインにてプラグインをインストールしてみてください。

●参考サイト
https://qiita.com/nanasess/items/791c9ec98f69ada93ea0#%E3%82%B3%E3%83%9E%E3%83%B3%E3%83%89%E3%83%A9%E3%82%A4%E3%83%B3%E3%81%A7%E3%81%AE%E3%83%97%E3%83%A9%E3%82%B0%E3%82%A4%E3%83%B3%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB

コマンドラインにてプラグインのインストールにてエラーが出るようなら、しっかりとした調査が必要なので専門家やEC-CUBEインテグレートパートナーに調査・インストール含めて相談することをオススメ致します。
https://www.ec-cube.net/integrate/partner/

----------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
EC-CUBEインテグレートパートナー【ゴールド】ランク
M&I Works
URL: https://miworks.biz/
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>