質問 > 管理機能 > Paid決済の連携がうまくいかない |
管理機能
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
tatsuo |
投稿日時: 2015/5/12 11:32
対応状況: −−−
|
新米 登録日: 2014/12/8 居住地: 投稿: 5 |
Paid決済の連携がうまくいかない 追記==
過去スレッド拝見しましたが、決済処理中は手動で管理画面から削除する方法しかないということでしょうか。 ==== お世話になります。どなたか教えてください。 Paid決済システムを導入しております。 ECCUBE2.13.2 MySQL5.6.14 先日お客様からの決済で、下記エラーが生じて、 決済処理中のまま、ステータスが変わりません。 Paid側に聞いたところ、ECCUBE→Paidでは問題はないそうで、 ECCUBEの仕様でエラー発生していると言われました。 情報が足りないかもしれませんが、どなたか何かご存じの方 いらしたら教えてください。 2015/05/10 23:49:32 /products/detail.php Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () ] MDB2 Error: syntax error _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_1495cfa04729f6de9121df54f8c23dc1cb41937acf FROM 'SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () '] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1] on [/home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087)] from 81.144.138.34 customer_id = /home/users/2/main.jp-ikehiko/web/products/detail.php(28): LC_Page_Products_Detail_Ex->init /home/users/2/main.jp-ikehiko/web/data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php(44): LC_Page_Products_Detail->init /home/users/2/main.jp-ikehiko/web/data/class/pages/products/LC_Page_Products_Detail.php(66): LC_Page->init /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(115): LC_Page->doLocalHookpointBefore /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(206): SC_Helper_Plugin->doAction /home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_Plugin.php(145): call_user_func_array (): MemberCategory->auth_product_detail /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(96): MemberCategory->belong_to_member_caegory /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(117): MemberCategory->member_category_exist /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(134): SC_Query->count /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(142): SC_Query->get /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(675): SC_Query->getOne /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(691): SC_Query->prepare /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1016): SC_Query->error /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087): trigger_error 2015/05/10 22:34:43 /products/detail.php Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () ] MDB2 Error: syntax error _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_14b2bbc4318d8d2a40917cc37d92b2e0e45f62cafe FROM 'SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () '] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1] on [/home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087)] from 157.55.39.115 customer_id = /home/users/2/main.jp-ikehiko/web/products/detail.php(28): LC_Page_Products_Detail_Ex->init /home/users/2/main.jp-ikehiko/web/data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php(44): LC_Page_Products_Detail->init /home/users/2/main.jp-ikehiko/web/data/class/pages/products/LC_Page_Products_Detail.php(66): LC_Page->init /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(115): LC_Page->doLocalHookpointBefore /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(206): SC_Helper_Plugin->doAction /home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_Plugin.php(145): call_user_func_array (): MemberCategory->auth_product_detail /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(96): MemberCategory->belong_to_member_caegory /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(117): MemberCategory->member_category_exist /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(134): SC_Query->count /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(142): SC_Query->get /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(675): SC_Query->getOne /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(691): SC_Query->prepare /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1016): SC_Query->error /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087): trigger_error 2015/05/10 03:43:31 /products/detail.php Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () ] MDB2 Error: syntax error _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_14e5af1947ad258db4156179320ca4adc8cf796019 FROM 'SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () '] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1] on [/home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087)] from 37.187.142.28 customer_id = /home/users/2/main.jp-ikehiko/web/products/detail.php(28): LC_Page_Products_Detail_Ex->init /home/users/2/main.jp-ikehiko/web/data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php(44): LC_Page_Products_Detail->init /home/users/2/main.jp-ikehiko/web/data/class/pages/products/LC_Page_Products_Detail.php(66): LC_Page->init /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(115): LC_Page->doLocalHookpointBefore /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(206): SC_Helper_Plugin->doAction /home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_Plugin.php(145): call_user_func_array (): MemberCategory->auth_product_detail /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(96): MemberCategory->belong_to_member_caegory /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(117): MemberCategory->member_category_exist /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(134): SC_Query->count /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(142): SC_Query->get /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(675): SC_Query->getOne /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(691): SC_Query->prepare /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1016): SC_Query->error /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087): trigger_error 2015/05/09 10:39:39 /products/detail.php Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () ] MDB2 Error: syntax error _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_1460af301b5f9c542ccee87cb3bf3a1deea598f142 FROM 'SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () '] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1] on [/home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087)] from 207.46.13.122 customer_id = /home/users/2/main.jp-ikehiko/web/products/detail.php(28): LC_Page_Products_Detail_Ex->init /home/users/2/main.jp-ikehiko/web/data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php(44): LC_Page_Products_Detail->init /home/users/2/main.jp-ikehiko/web/data/class/pages/products/LC_Page_Products_Detail.php(66): LC_Page->init /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(115): LC_Page->doLocalHookpointBefore /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(206): SC_Helper_Plugin->doAction /home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_Plugin.php(145): call_user_func_array (): MemberCategory->auth_product_detail /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(96): MemberCategory->belong_to_member_caegory /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(117): MemberCategory->member_category_exist /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(134): SC_Query->count /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(142): SC_Query->get /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(675): SC_Query->getOne /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(691): SC_Query->prepare /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1016): SC_Query->error /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087): trigger_error 2015/05/07 22:56:25 /products/detail.php Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () ] MDB2 Error: syntax error _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_mysql_1443877f7ad7ad8bc720c496460d7046a308cc78b6 FROM 'SELECT COUNT(*) FROM dtb_category WHERE del_flg = 0 AND plg_membercategory_member_flg = 1 AND category_id IN () '] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1] on [/home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087)] from 69.58.178.59 customer_id = /home/users/2/main.jp-ikehiko/web/products/detail.php(28): LC_Page_Products_Detail_Ex->init /home/users/2/main.jp-ikehiko/web/data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php(44): LC_Page_Products_Detail->init /home/users/2/main.jp-ikehiko/web/data/class/pages/products/LC_Page_Products_Detail.php(66): LC_Page->init /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(115): LC_Page->doLocalHookpointBefore /home/users/2/main.jp-ikehiko/web/data/class/pages/LC_Page.php(206): SC_Helper_Plugin->doAction /home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_Plugin.php(145): call_user_func_array (): MemberCategory->auth_product_detail /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(96): MemberCategory->belong_to_member_caegory /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(117): MemberCategory->member_category_exist /home/users/2/main.jp-ikehiko/web/data/downloads/plugin/MemberCategory/MemberCategory.php(134): SC_Query->count /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(142): SC_Query->get /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(675): SC_Query->getOne /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(691): SC_Query->prepare /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1016): SC_Query->error /home/users/2/main.jp-ikehiko/web/data/class/SC_Query.php(1087): trigger_error 2015/05/07 13:47:55 /shopping/load_payment_module.php Warning(E_USER_WARNING): メイン部のテンプレートが存在しません。[/home/users/2/main.jp-ikehiko/web/data/Smarty/templates/default/.tpl] on [/home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_PageLayout.php(66)] from 223.219.6.203 2015/05/07 13:47:55 /shopping/load_payment_module.php Warning(E_USER_WARNING): ページ情報を取得できませんでした。 on [/home/users/2/main.jp-ikehiko/web/data/class/helper/SC_Helper_PageLayout.php(59)] from 223.219.6.203 2015/05/07 13:47:55 /shopping/load_payment_module.php Warning(E_WARNING): register_shutdown_function() [<a href='function.register-shutdown-function'>function.register-shutdown-function</a>]: Invalid shutdown callback 'LC_Page_Shopping_LoadPaymentModule_Ex::destroy' passed on [/home/users/2/main.jp-ikehiko/web/shopping/load_payment_module.php(32)] from 223.219.6.203 2015/05/07 11:37:35 /admin/order/edit.php Warning(E_WARNING): Invalid argument supplied for foreach() on [/home/users/2/main.jp-ikehiko/web/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php(862)] from 202.55.216.6 2015/05/07 11:37:35 /admin/order/edit.php Warning(E_WARNING): Invalid argument supplied for foreach() on [/home/users/2/main.jp-ikehiko/web/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php(862)] from 202.55.216.6 2015/05/06 19:53:10 /shopping/load_payment_module.php Warning(E_WARNING): register_shutdown_function() [<a href='function.register-shutdown-function'>function.register-shutdown-function</a>]: Invalid shutdown callback 'LC_Page_Shopping_LoadPaymentModule_Ex::destroy' passed on [/home/users/2/main.jp-ikehiko/web/shopping/load_payment_module.php(32)] from 153.176.139.149 |
yuh |
投稿日時: 2015/5/12 11:35
対応状況: −−−
|
神 登録日: 2013/1/9 居住地: 大阪 投稿: 1819 |
Re: Paid決済の連携がうまくいかない プラグインが原因と思います。
plg_membercategory_member_flg ↑ これに関係するプラグインを停止してください。 |
tatsuo |
投稿日時: 2015/5/18 15:09
対応状況: −−−
|
新米 登録日: 2014/12/8 居住地: 投稿: 5 |
Re: Paid決済の連携がうまくいかない yuh様
ご返信ありがとうございます。ご指摘の方法で連携できました。 本当にたすかりました。ありがとうございました。 |
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | トップ |