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 |
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> > > 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 > > 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 |
Free forum by Nabble | Edit this page |