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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

puranisank
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
Reply | Threaded
Open this post in threaded view
|

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

cjhowe

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