質問 > フロント機能 > キーワードを入れて商品検索するとエラーが出る件 |
フロント機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
pfizzjapan |
投稿日時: 2018/8/20 1:31
対応状況: −−−
|
常連 登録日: 2017/2/17 居住地: 投稿: 58 |
Re: キーワードを入れて商品検索するとエラーが出る件 ご回答いただきありがとうございます。
src/Eccube/Application.phpとEccube\Doctrine\ORM\Query\Normalize.phpはあらためて更新してみましたが、エラーのままでした。 vendor内のファイルを全てあらためて更新してみたほうがよいでしょうか。 現時点で、デバッグモードで確認した際のエラー全文は下記になります。 2/2 QueryException in QueryException.php line 52: [Syntax Error] line 0, col 132: Error: Expected known function, got 'NORMALIZE' in QueryException.php line 52 at QueryException::syntaxError('line 0, col 132: Error: Expected known function, got 'NORMALIZE'', object(QueryException)) in Parser.php line 448 at Parser->syntaxError('known function', array('value' => 'NORMALIZE', 'type' => '100', 'position' => '132')) in Parser.php line 3287 at Parser->CustomFunctionDeclaration() in Parser.php line 3259 at Parser->FunctionDeclaration() in Parser.php line 2818 at Parser->StringPrimary() in Parser.php line 2798 at Parser->StringExpression() in Parser.php line 3085 at Parser->LikeExpression() in Parser.php line 2478 at Parser->SimpleConditionalExpression() in Parser.php line 2384 at Parser->ConditionalPrimary() in Parser.php line 2360 at Parser->ConditionalFactor() in Parser.php line 2328 at Parser->ConditionalTerm() in Parser.php line 2303 at Parser->ConditionalExpression() in Parser.php line 2401 at Parser->ConditionalPrimary() in Parser.php line 2360 at Parser->ConditionalFactor() in Parser.php line 2333 at Parser->ConditionalTerm() in Parser.php line 2303 at Parser->ConditionalExpression() in Parser.php line 1327 at Parser->WhereClause() in Parser.php line 876 at Parser->SelectStatement() in Parser.php line 843 at Parser->QueryLanguage() in Parser.php line 268 at Parser->getAST() in Parser.php line 351 at Parser->parse() in Paginator.php line 263 at Paginator->getCountQuery() in Paginator.php line 123 at Paginator->count() at count(object(Paginator)) in PaginatorListener.php line 47 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(Query), '1', '20') in ProductController.php line 98 at ProductController->index(object(Application), object(Request)) at call_user_func_array(array(object(ProductController), 'index'), array(object(Application), object(Request))) 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/2 QueryException in QueryException.php line 41: SELECT p, MIN(pc.price02) as HIDDEN price02_min FROM Eccube\Entity\Product p INNER JOIN p.ProductClasses pc WHERE p.Status = 1 AND (NORMALIZE(p.name) LIKE NORMALIZE(:keyword0) OR NORMALIZE(p.search_word) LIKE NORMALIZE(:keyword0)) GROUP BY p ORDER BY price02_min ASC, p.id DESC in QueryException.php line 41 at QueryException::dqlError('SELECT p, MIN(pc.price02) as HIDDEN price02_min FROM Eccube\Entity\Product p INNER JOIN p.ProductClasses pc WHERE p.Status = 1 AND (NORMALIZE(p.name) LIKE NORMALIZE(:keyword0) OR NORMALIZE(p.search_word) LIKE NORMALIZE(:keyword0)) GROUP BY p ORDER BY price02_min ASC, p.id DESC') in Parser.php line 448 at Parser->syntaxError('known function', array('value' => 'NORMALIZE', 'type' => '100', 'position' => '132')) in Parser.php line 3287 at Parser->CustomFunctionDeclaration() in Parser.php line 3259 at Parser->FunctionDeclaration() in Parser.php line 2818 at Parser->StringPrimary() in Parser.php line 2798 at Parser->StringExpression() in Parser.php line 3085 at Parser->LikeExpression() in Parser.php line 2478 at Parser->SimpleConditionalExpression() in Parser.php line 2384 at Parser->ConditionalPrimary() in Parser.php line 2360 at Parser->ConditionalFactor() in Parser.php line 2328 at Parser->ConditionalTerm() in Parser.php line 2303 at Parser->ConditionalExpression() in Parser.php line 2401 at Parser->ConditionalPrimary() in Parser.php line 2360 at Parser->ConditionalFactor() in Parser.php line 2333 at Parser->ConditionalTerm() in Parser.php line 2303 at Parser->ConditionalExpression() in Parser.php line 1327 at Parser->WhereClause() in Parser.php line 876 at Parser->SelectStatement() in Parser.php line 843 at Parser->QueryLanguage() in Parser.php line 268 at Parser->getAST() in Parser.php line 351 at Parser->parse() in Paginator.php line 263 at Paginator->getCountQuery() in Paginator.php line 123 at Paginator->count() at count(object(Paginator)) in PaginatorListener.php line 47 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(Query), '1', '20') in ProductController.php line 98 at ProductController->index(object(Application), object(Request)) at call_user_func_array(array(object(ProductController), 'index'), array(object(Application), object(Request))) 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 |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
キーワードを入れて商品検索するとエラーが出る件 | pfizzjapan | 2018/8/19 13:45 |
Re: キーワードを入れて商品検索するとエラーが出る件 | red | 2018/8/19 23:47 |
» Re: キーワードを入れて商品検索するとエラーが出る件 | pfizzjapan | 2018/8/20 1:31 |
Re: キーワードを入れて商品検索するとエラーが出る件 | red | 2018/8/20 10:17 |
Re: キーワードを入れて商品検索するとエラーが出る件 | pfizzjapan | 2018/8/24 11:12 |
Re: キーワードを入れて商品検索するとエラーが出る件 | pfizzjapan | 2018/8/30 13:58 |
Re: キーワードを入れて商品検索するとエラーが出る件 | eccubeUser | 2019/7/5 15:41 |