▼テンプレート
[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

SQLの文法エラーが発生しているように見えますが、カスタマイズ等はされていますか？

----------------
株式会社シロハチ
■ECCUBE2系、3系構築カスタマイズご相談ください。
■EC-CUBE3マニュアル
■blog

ROW_NUMBER() OVER() はDoctrineでは動かなかった気がしますけど
ご自身で書かれました？

Doctrineが内部で発行しているんですかね？

----------------
EC-CUBEカスタマイズ・高速化・脆弱性対策・SEO ご相談ください。

2系・3系から4系へのバージョンアップ実績豊富

全然　何も　書いてません（てか　かけません；）

zaifのプラグインとhtml飛ばすディレクトリ変更したくらいですね

支払い方法のデータベースを修正したらエラーになったのですか？

支払い方法を触ってからしか、商品検索しなかったので不明ですが
可能性ってありますか？

ちなみにポスグレのバージョンって分かりますか？

あ、コアサーバーなんですね。
コアサーバーはポスグレ8.2系だった気が...
そもそも動かないかも。

そ　そうなんですね
ver2は３年ほど動かして良かったのでver3も大丈夫かと思っていました

やっぱり8.2ですね。8.2だとROW_NUMBER OVERは導入されていなかったと思うので、それでエラーになっているのではないでしょうか
https://www.coreserver.jp/function/