You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2010/11/22 18:16:14 UTC
[jira] Issue Comment Edited: (OFBIZ-4032) There are issues whit
search in eCommerce
[ https://issues.apache.org/jira/browse/OFBIZ-4032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12934513#action_12934513 ]
Jacques Le Roux edited comment on OFBIZ-4032 at 11/22/10 12:15 PM:
-------------------------------------------------------------------
And I have no problems with Derby locally... Could be an issue specific to Postgres...
{code}
2010-11-22 18:12:17,312 (http-0.0.0.0-28080-1) [ ControlServlet.java:147:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-11-22 18:12:17,343 (http-0.0.0.0-28080-1) [ ConfigXMLReader.java:120:INFO ] controller loaded: 0.0s, 277 requests, 92 views in jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml
2010-11-22 18:12:17,500 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [1000], got set: []
2010-11-22 18:12:17,515 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [gz], got set: []
2010-11-22 18:12:17,546 (http-0.0.0.0-28080-1) [ RequestHandler.java:634:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-11-22 18:12:17,546 (http-0.0.0.0-28080-1) [ RequestHandler.java:737:INFO ] Rendering View [keywordsearch], sessionId=B247E29FC739991B0C0962E5517881FB.jvm1
2010-11-22 18:12:17,562 (http-0.0.0.0-28080-1) [ ScreenFactory.java:130:INFO ] Got 30 screens in 0.016s from: file:/D:/workspace/ofbizDev/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [1000], got set: []
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [gz], got set: []
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={}
keywordFixedOrSetAndList={{%1000%, %gz%}}
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ ProductSearch.java:624:INFO ] topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-11-22 18:12:17.64') AND pcm2FromDate < '2010-11-22 18:12:17.64' AND p
cm2ProductCategoryId IN ('CATALOG1_SEARCH'))
2010-11-22 18:12:17,828 (http-0.0.0.0-28080-1) [ ProductSearch.java:762:ERROR]
---- exception report ----------------------------------------------------------
Error getting results from the product search query
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELECT COUNT(DISTINCT *) FROM ((public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODC
I.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND (P
K1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?) AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) GROUP BY PROD.PRODUCT_ID) TEMP_NAME (ERREUR: erreur d
e syntaxe sur ou prÞs de ½ * ╗)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERREUR: erreur de syntaxe sur ou prÞs de ½ * ╗
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou prÞs de ½ * ╗
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1071)
org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:749)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
KeywordSearch.run(KeywordSearch.groovy:35)
{code}
was (Author: jacques.le.roux):
And I have no problems with Derby locally... Could be an issue specific to Postgres...
2010-11-22 18:12:17,312 (http-0.0.0.0-28080-1) [ ControlServlet.java:147:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-11-22 18:12:17,343 (http-0.0.0.0-28080-1) [ ConfigXMLReader.java:120:INFO ] controller loaded: 0.0s, 277 requests, 92 views in jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml
2010-11-22 18:12:17,500 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [1000], got set: []
2010-11-22 18:12:17,515 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [gz], got set: []
2010-11-22 18:12:17,546 (http-0.0.0.0-28080-1) [ RequestHandler.java:634:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-11-22 18:12:17,546 (http-0.0.0.0-28080-1) [ RequestHandler.java:737:INFO ] Rendering View [keywordsearch], sessionId=B247E29FC739991B0C0962E5517881FB.jvm1
2010-11-22 18:12:17,562 (http-0.0.0.0-28080-1) [ ScreenFactory.java:130:INFO ] Got 30 screens in 0.016s from: file:/D:/workspace/ofbizDev/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [1000], got set: []
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [gz], got set: []
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={}
keywordFixedOrSetAndList={{%1000%, %gz%}}
2010-11-22 18:12:17,640 (http-0.0.0.0-28080-1) [ ProductSearch.java:624:INFO ] topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-11-22 18:12:17.64') AND pcm2FromDate < '2010-11-22 18:12:17.64' AND p
cm2ProductCategoryId IN ('CATALOG1_SEARCH'))
2010-11-22 18:12:17,828 (http-0.0.0.0-28080-1) [ ProductSearch.java:762:ERROR]
---- exception report ----------------------------------------------------------
Error getting results from the product search query
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELECT COUNT(DISTINCT *) FROM ((public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODC
I.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID) INNER JOIN public.PRODUCT_CATEGORY_MEMBER PCM2 ON PROD.PRODUCT_ID = PCM2.PRODUCT_ID WHERE ((PROD.IS_VARIANT <> ? AND (P
K1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?) AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) GROUP BY PROD.PRODUCT_ID) TEMP_NAME (ERREUR: erreur d
e syntaxe sur ou prÞs de ½ * ╗)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERREUR: erreur de syntaxe sur ou prÞs de ½ * ╗
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou prÞs de ½ * ╗
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1071)
org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:749)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
KeywordSearch.run(KeywordSearch.groovy:35)
> There are issues whit search in eCommerce
> -----------------------------------------
>
> Key: OFBIZ-4032
> URL: https://issues.apache.org/jira/browse/OFBIZ-4032
> Project: OFBiz
> Issue Type: Bug
> Components: specialpurpose/ecommerce
> Affects Versions: Release Branch 10.04, jQuery, SVN trunk
> Reporter: Jacques Le Roux
>
> Try gz-1000 or "gift card" and follow [this comment from OFBIZ-3789|https://issues.apache.org/jira/browse/OFBIZ-3789?focusedCommentId=12910997&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12910997] (last one)
> I guess it's also an issue for R10.04 (I did not try) R9.04 seems OK
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.