Adam Heath wrote:
> rohit wrote:
>> Hi Adam,
>>
>> Can you please re-check the commit. I am running postgres 8.4 on FC8 and JDK
>> 1.6._17. I am still getting the error as below:
>
> What were you doing at the time? What was your start page? What form
> values did you fill out? Which submit button did you hit? Please be
> specific, because I did look at this, and couldn't repeat it the last
> time(or did fix a problem).
I've imported data into postgresql 8.4, when to /catalog/control/main,
typed 'widget' into the keyword search box on the left menu, and
didn't get any error. Got 8 results.
Are you *sure* you are running the latest ofbiz?
>
> <general>
> It's also best to include the series of steps that you have done when
> reporting a problem. This way anyone else can repeat the issue.
> </general>
>
>> 2010-06-14 03:58:48,600 (TP-Processor5) [ ControlServlet.java:144:INFO ]
>> [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since
>> last(Begin):0.0]]
>> 2010-06-14 03:58:48,604 (TP-Processor5) [ KeywordSearchUtil.java:235:INFO ]
>> Expanded keyword [gizmos], got set: []
>> 2010-06-14 03:58:48,605 (TP-Processor5) [ RequestHandler.java:638:INFO ]
>> Ran Event
>> [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride]
>> from [request], result is [success]
>> 2010-06-14 03:58:48,646 (TP-Processor5) [ RequestHandler.java:741:INFO ]
>> Rendering View [keywordsearch],
>> sessionId=2173C489A0B096AA162A2EFBFD169C0B.jvm1
>> 2010-06-14 03:58:48,703 (TP-Processor5) [ ScreenFactory.java:128:INFO ]
>> Got 30 screens in 0.054s from:
>> file:/mnt/data-store/ofbizsvn/trunk/specialpurpose/ecommerce/widget/CatalogScreens.xml
>>
>> 2010-06-14 03:58:48,720 (TP-Processor5) [ KeywordSearchUtil.java:235:INFO ]
>> Expanded keyword [gizmos], got set: []
>> 2010-06-14 03:58:48,720 (TP-Processor5) [ ProductSearch.java:272:INFO ]
>> Finished initial setup of keywords, doingBothAndOr=false,
>> andKeywordFixedSet={%gizmo%}
>> keywordFixedOrSetAndList={}
>> 2010-06-14 03:58:48,721 (TP-Processor5) [ ProductSearch.java:625:INFO ]
>> topCond=((pcm2ThruDate IS NULL OR pcm2ThruDate > '2010-06-14 03:58:48.719')
>> AND pcm2FromDate < '2010-06-14 03:58:48.719' AND pcm2ProductCategoryId IN
>> ('CATALOG1_SEARCH'))
>> 2010-06-14 03:58:48,749 (TP-Processor5) [ ProductSearch.java:790: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(DISTINCT
>> TOTAL_RELEVANCY) FROM ((public.PRODUCT PROD LEFT OUTER JOIN
>> public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID =
>> PRODCI.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
>> PK1.KEYWORD LIKE ? AND ((PCM2.THRU_DATE IS NULL OR PCM2.THRU_DATE > ?) AND
>> PCM2.FROM_DATE < ? AND PCM2.PRODUCT_CATEGORY_ID IN (?)))) (ERROR: column
>> "total_relevancy" does not exist
>> Position: 23)
>> ---- cause
>> ---------------------------------------------------------------------
>> Exception: org.postgresql.util.PSQLException
>> Message: ERROR: column "total_relevancy" does not exist
>> Position: 23
>> ---- stack trace
>> ---------------------------------------------------------------
>> org.postgresql.util.PSQLException: ERROR: column "total_relevancy" does not
>> exist
>> Position: 23
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>>
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
>>
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
>>
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
>>
>> 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:387)
>> org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1073)
>>
>> org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
>>
>> org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:765)
>>
>> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
>>
>> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:960)
>>
>> 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)
>> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
>>
>> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
>>
>> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
>>
>> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
>> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
>> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
>> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
>>
>> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
>> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
>> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
>> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>>
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>>
>> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>>
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>>
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>>
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>>
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>>
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>>
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>>
>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
>> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
>> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
>> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
>> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
>> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
>>
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
>>
>> java.lang.Thread.run(Thread.java:619)
>
