質問 > 管理機能 > 商品マスターで「検索する」を押すとシステムエラー |
管理機能
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
ゲスト |
投稿日時: 2017/4/9 18:40
対応状況: −−−
|
商品マスターで「検索する」を押すとシステムエラー ▼テンプレート
[EC-CUBE] EC-CUBEのバージョン、3.0.14新規インストール [レンタルサーバ] レンタルサーバ名 coreserver [OS] 使用しているOS名、バージョン macos [PHP] 使用しているPHPのバージョン php5 [データベース] 使用しているDB名、バージョン ポスグレ [WEBサーバ] 使用しているWEBサーバ名、バージョン [ブラウザ] 使用しているブラウザ名、バージョン chrome [導入プラグインの有無] あれば導入プラグインを記載 [カスタマイズの有無] あればカスタマイズ内容を記載(できるだけ具体的に) [現象] 再現手順や、どのような現象が発生しているかなど、具体的に 商品検索するとシステムエラー デバックモードで見ると Syntax error 。。 どのようにすると良いでしょうか? Whoops, looks like something went wrong. 3/3 SyntaxErrorException in AbstractPostgreSQLDriver.php line 66: An exception occurred while executing 'SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0': SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "OVER" LINE 1: ...e8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER... ^ in AbstractPostgreSQLDriver.php line 66 at AbstractPostgreSQLDriver->convertException('An exception occurred while executing 'SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0': SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "OVER" LINE 1: ...e8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER... ^', object(PDOException)) in DBALException.php line 128 at DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0', array()) in Connection.php line 855 at Connection->executeQuery('SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0', array(), array(), null) in SingleSelectExecutor.php line 50 at SingleSelectExecutor->execute(object(Connection), array(), array()) in Query.php line 286 at Query->_doExecute() in AbstractQuery.php line 794 at AbstractQuery->execute(null, '3') in AbstractQuery.php line 598 at AbstractQuery->getScalarResult() in Paginator.php line 151 at Paginator->getIterator() at iterator_to_array(object(Paginator)) in PaginatorListener.php line 49 at PaginatorListener->items(object(ItemsEvent), 'knp_pager.items', object(EventDispatcher)) at call_user_func(array(object(PaginatorListener), 'items'), object(ItemsEvent), 'knp_pager.items', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(array(object(QueryBuilderSubscriber), 'items'), array(object(QueryBuilderSubscriber), 'items'), array(object(QueryBuilderSubscriber), 'items'), array(object(DBALQueryBuilderSubscriber), 'items'), array(object(PaginatorListener), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(ElasticaQuerySubscriber), 'items'), array(object(PropelQuerySubscriber), 'items'), array(object(SolariumQuerySubscriber), 'items'), array(object(ArraySubscriber), 'items'), array(object(UsesPaginator), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(CollectionSubscriber), 'items'), array(object(PropelQuerySubscriber), 'items'), array(object(SolariumQuerySubscriber), 'items'), array(object(ElasticaQuerySubscriber), 'items'), array(object(ArraySubscriber), 'items')), 'knp_pager.items', object(ItemsEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('knp_pager.items', object(ItemsEvent)) in Paginator.php line 113 at Paginator->paginate(object(QueryBuilder), '1', '10', array('wrap-queries' => true)) in ProductController.php line 97 at ProductController->index(object(Application), object(Request), null) at call_user_func_array(array(object(ProductController), 'index'), array(object(Application), object(Request), null)) in HttpKernel.php line 144 at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64 at HttpKernel->handle(object(Request), '1', true) in Application.php line 586 at Application->handle(object(Request)) in Application.php line 563 at Application->run() in index_dev.php line 104 2/3 PDOException in PDOConnection.php line 106: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "OVER" LINE 1: ...e8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER... ^ in PDOConnection.php line 106 at PDOConnection->query('SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0') in Connection.php line 852 at Connection->executeQuery('SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0', array(), array(), null) in SingleSelectExecutor.php line 50 at SingleSelectExecutor->execute(object(Connection), array(), array()) in Query.php line 286 at Query->_doExecute() in AbstractQuery.php line 794 at AbstractQuery->execute(null, '3') in AbstractQuery.php line 598 at AbstractQuery->getScalarResult() in Paginator.php line 151 at Paginator->getIterator() at iterator_to_array(object(Paginator)) in PaginatorListener.php line 49 at PaginatorListener->items(object(ItemsEvent), 'knp_pager.items', object(EventDispatcher)) at call_user_func(array(object(PaginatorListener), 'items'), object(ItemsEvent), 'knp_pager.items', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(array(object(QueryBuilderSubscriber), 'items'), array(object(QueryBuilderSubscriber), 'items'), array(object(QueryBuilderSubscriber), 'items'), array(object(DBALQueryBuilderSubscriber), 'items'), array(object(PaginatorListener), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(ElasticaQuerySubscriber), 'items'), array(object(PropelQuerySubscriber), 'items'), array(object(SolariumQuerySubscriber), 'items'), array(object(ArraySubscriber), 'items'), array(object(UsesPaginator), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(CollectionSubscriber), 'items'), array(object(PropelQuerySubscriber), 'items'), array(object(SolariumQuerySubscriber), 'items'), array(object(ElasticaQuerySubscriber), 'items'), array(object(ArraySubscriber), 'items')), 'knp_pager.items', object(ItemsEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('knp_pager.items', object(ItemsEvent)) in Paginator.php line 113 at Paginator->paginate(object(QueryBuilder), '1', '10', array('wrap-queries' => true)) in ProductController.php line 97 at ProductController->index(object(Application), object(Request), null) at call_user_func_array(array(object(ProductController), 'index'), array(object(Application), object(Request), null)) in HttpKernel.php line 144 at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64 at HttpKernel->handle(object(Request), '1', true) in Application.php line 586 at Application->handle(object(Request)) in Application.php line 563 at Application->run() in index_dev.php line 104 1/3 PDOException in PDOConnection.php line 104: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "OVER" LINE 1: ...e8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER... ^ in PDOConnection.php line 104 at PDO->query('SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0') in PDOConnection.php line 104 at PDOConnection->query('SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0') in Connection.php line 852 at Connection->executeQuery('SELECT DISTINCT product_id0, MIN(sclr10) AS dctrn_minrownum FROM (SELECT d0_.product_id AS product_id0, d0_.name AS name1, d0_.note AS note2, d0_.description_list AS description_list3, d0_.description_detail AS description_detail4, d0_.search_word AS search_word5, d0_.free_area AS free_area6, d0_.del_flg AS del_flg7, d0_.create_date AS create_date8, d0_.update_date AS update_date9, ROW_NUMBER() OVER(ORDER BY d0_.update_date DESC) AS sclr10 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.product_id = d1_.product_id AND (d1_.del_flg = 0) WHERE (d0_.del_flg = 0)) dctrn_result GROUP BY product_id0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 0', array(), array(), null) in SingleSelectExecutor.php line 50 at SingleSelectExecutor->execute(object(Connection), array(), array()) in Query.php line 286 at Query->_doExecute() in AbstractQuery.php line 794 at AbstractQuery->execute(null, '3') in AbstractQuery.php line 598 at AbstractQuery->getScalarResult() in Paginator.php line 151 at Paginator->getIterator() at iterator_to_array(object(Paginator)) in PaginatorListener.php line 49 at PaginatorListener->items(object(ItemsEvent), 'knp_pager.items', object(EventDispatcher)) at call_user_func(array(object(PaginatorListener), 'items'), object(ItemsEvent), 'knp_pager.items', object(EventDispatcher)) in EventDispatcher.php line 161 at EventDispatcher->doDispatch(array(array(object(QueryBuilderSubscriber), 'items'), array(object(QueryBuilderSubscriber), 'items'), array(object(QueryBuilderSubscriber), 'items'), array(object(DBALQueryBuilderSubscriber), 'items'), array(object(PaginatorListener), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(ElasticaQuerySubscriber), 'items'), array(object(PropelQuerySubscriber), 'items'), array(object(SolariumQuerySubscriber), 'items'), array(object(ArraySubscriber), 'items'), array(object(UsesPaginator), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(QuerySubscriber), 'items'), array(object(CollectionSubscriber), 'items'), array(object(PropelQuerySubscriber), 'items'), array(object(SolariumQuerySubscriber), 'items'), array(object(ElasticaQuerySubscriber), 'items'), array(object(ArraySubscriber), 'items')), 'knp_pager.items', object(ItemsEvent)) in EventDispatcher.php line 46 at EventDispatcher->dispatch('knp_pager.items', object(ItemsEvent)) in Paginator.php line 113 at Paginator->paginate(object(QueryBuilder), '1', '10', array('wrap-queries' => true)) in ProductController.php line 97 at ProductController->index(object(Application), object(Request), null) at call_user_func_array(array(object(ProductController), 'index'), array(object(Application), object(Request), null)) in HttpKernel.php line 144 at HttpKernel->handleRaw(object(Request), '1') in HttpKernel.php line 64 at HttpKernel->handle(object(Request), '1', true) in Application.php line 586 at Application->handle(object(Request)) in Application.php line 563 at Application->run() in index_dev.php line 104 2.7.24 aa4af5 500 ProductController index 2 1074 ms 28.5 MB 1 2 ms Database 13 |
|
468 |
投稿日時: 2017/4/9 19:22
対応状況: −−−
|
神 登録日: 2008/10/26 居住地: 投稿: 3217 |
Re: 商品マスターで「検索する」を押すとシステムエラー SQLの文法エラーが発生しているように見えますが、カスタマイズ等はされていますか?
|
umebius |
投稿日時: 2017/4/9 19:29
対応状況: −−−
|
神 登録日: 2016/7/22 居住地: 投稿: 2085 |
Re: 商品マスターで「検索する」を押すとシステムエラー ROW_NUMBER() OVER() はDoctrineでは動かなかった気がしますけど
ご自身で書かれました? Doctrineが内部で発行しているんですかね?
|
ゲスト |
投稿日時: 2017/4/9 22:10
対応状況: −−−
|
Re: 商品マスターで「検索する」を押すとシステムエラー 全然 何も 書いてません(てか かけません;)
zaifのプラグインとhtml飛ばすディレクトリ変更したくらいですね |
|
umebius |
投稿日時: 2017/4/9 22:16
対応状況: −−−
|
神 登録日: 2016/7/22 居住地: 投稿: 2085 |
Re: 商品マスターで「検索する」を押すとシステムエラー 支払い方法のデータベースを修正したらエラーになったのですか?
|
ゲスト |
投稿日時: 2017/4/9 22:31
対応状況: −−−
|
Re: 商品マスターで「検索する」を押すとシステムエラー 支払い方法を触ってからしか、商品検索しなかったので不明ですが
可能性ってありますか? |
|
umebius |
投稿日時: 2017/4/9 22:38
対応状況: −−−
|
神 登録日: 2016/7/22 居住地: 投稿: 2085 |
Re: 商品マスターで「検索する」を押すとシステムエラー ちなみにポスグレのバージョンって分かりますか?
|
umebius |
投稿日時: 2017/4/9 22:40
対応状況: −−−
|
神 登録日: 2016/7/22 居住地: 投稿: 2085 |
Re: 商品マスターで「検索する」を押すとシステムエラー あ、コアサーバーなんですね。
コアサーバーはポスグレ8.2系だった気が... そもそも動かないかも。 |
ゲスト |
投稿日時: 2017/4/9 22:45
対応状況: −−−
|
Re: 商品マスターで「検索する」を押すとシステムエラー そ そうなんですね
ver2は3年ほど動かして良かったのでver3も大丈夫かと思っていました |
|
umebius |
投稿日時: 2017/4/9 22:53
対応状況: −−−
|
神 登録日: 2016/7/22 居住地: 投稿: 2085 |
Re: 商品マスターで「検索する」を押すとシステムエラー やっぱり8.2ですね。8.2だとROW_NUMBER OVERは導入されていなかったと思うので、それでエラーになっているのではないでしょうか
https://www.coreserver.jp/function/ |
(1) 2 » |
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | トップ |