Re :Re: Re :Re: Re :Re: Keyword search is not working

Posted by puranisank on Jul 08, 2006; 10:33am
URL: http://ofbiz.116.s1.nabble.com/Re-Re-Re-Re-Re-Re-Keyword-search-is-not-working-tp140567.html

I am getting the following error when tried \"AutoCreateKeywordsForAllProducts\"

Error calling event: org.ofbiz.webapp.event.EventHandlerException: Problems processing event: org.ofbiz.base.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value : introductionDate [INTRODUCTION_DATE] (6) (Value \'0000-00-00\' can not be represented as java.sql.Timestamp)) (Error creating GenericValue (SQL Exception while getting value : introductionDate [INTRODUCTION_DATE] (6) (Value \'0000-00-00\' can not be represented as java.sql.Timestamp))) [hidden email] wroteThe first page of the Catalog Manager in the centerarea at the bottom there is a link that says AutoCreate Keywords for All Products. Did you try that?--- [hidden email] wrote:> Yes,  have changed the flag.But still getting> the same> [hidden email]> wroteWhen you create a product, you have to set to Y> the flag \"autoCreateKeywords\" (in the edit product> page).Jacopopuranisan
 [hidden email] wrote:> I> am working in ecommerce of opentaps8.3I created a> new store of product_store_id=10000 and> product_store_group_id=SandS.I cleared the data in> the entity \"product_store_keyword_ovrd\".When I> search for a product say ss-100, I am getting the> result \"No Results found\" for all products I have> stored in the table>\"Product\"[hidden email]> wroteMore details,> [hidden email] wrote:>> Hi,Keyword search is not working for us.Could I> please get some tips in knowing what are the tables> involved in this.This is a critical error.Thanks inadvancePurani