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

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


If I were to guess, your product doesn't have an
introduction date.  I don't know why it would need
that date because you didn't post enough of the log.

--- [hidden email] wrote:

> 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