|
商品マスターで「検索する」を押すとシステムエラー ▼テンプレート [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
|