A tip for future debugging. Google is your friend. When you see something that's strange in your log error, take the part that doesn't look to be containing any variables and do a google search. The pecurliar part of this error is: Illegal mix of collations and then it talks about differences in languages stuff.
Doing a Google search on "Illegal mix of collations" returns this gem of a solution among some other mysql issues with explaining the whys of it all: https://www.plainblack.com/etcetera/dbdmysqlst-execute-failed-illegal-mix-of-collations/3 --- dhilip kumar <[EMAIL PROTECTED]> wrote: > The following is the exact error I am getting > while trying to search a product > > > Error in product search > Exception: > org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the > following:SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT) > AS TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID > FROM PRODUCT PROD LEFT OUTER JOIN > PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = > PRODCI.PRODUCT_ID INNER JOIN PRODUCT_KEYWORD PK1 ON > PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD > LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY > PROD.PRODUCT_ID ORDER BY TOTAL_RELEVANCY DESC > (Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and > (latin1_general_cs,IMPLICIT) for operation '=') > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: SQL > Exception while executing the following:SELECT > DISTINCT SUM(PK1.RELEVANCY_WEIGHT) AS > TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID FROM > PRODUCT PROD LEFT OUTER JOIN PRODUCT_CALCULATED_INFO > PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID INNER > JOIN PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = > PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ? OR > PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER > BY TOTAL_RELEVANCY DESC (Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and > (latin1_general_cs,IMPLICIT) for operation '=') > > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:407) > > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:837) > > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:173) > > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1987) > > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:314) > > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:185) > > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:590) > > > > Thanks > Purani > > > > > > > > > > > gh of the log, prior to that error it > will tell what service was started and failed. > > 2) The issue is that Product.introductionDate is > null. > For whatever reason, the service is needing a > complete primary key where Product.introductionDate > is > not null. If you give your product an introduction > date in the format 2006-07-08 it will work > > 3) Can you please use a different email server? It's > escaping characters and not making them right before > they get sent. This makes it very dificult to read > your messages. > > --- [EMAIL PROTECTED] wrote: > > > The following is the error from the log > > > :-------------------------------------------------------------------------------- > > 266797[ > > RequestHandler.java:281:ERROR] Request > > UpdateAllKeywords caused an error with the > following > > message: 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)))266797[ > > RequestHandler.java:372:INFO ] > > [RequestHandler.doRequest]: Response is a > > view.266797[ > > RequestHandler.java:524:INFO ] > servletName=control, > > view=main266797[ > > PrimaryKeyFinder.java:132:INFO ] Returning null > > because found incomplete primary key in find: > > [GenericEntity:Product][productId,null()]266890[&n > > bsp; ServiceDispatcher.java:447:DEBUG] [[Sync > > service finished- total:0.0,since > last(Begin):0.0]] > > - 'catalog / > > > getProductCategoryAndLimitedMembers'266906[ > > GenericDelegator.java:600:ERROR] ---- exception > > report > > > ----------------------------------------------------------Failure > > in create operation for entity [ServerHit]: > > org.ofbiz.entity.GenericEntityException: Exception > > while inserting the following entity: > > > [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08 > > > 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/login?externalLoginKey=EL70492148788(java.lang.String)][re > > > > > questUrl,https://localhost:8443/catalog/control/UpdateAllKeywords(java.lang.String)][runningTimeMillis,234(java.lang.Long)][serverHostName,envisage1(java.lang.String)][serverIpAddress,192.168.1.9(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,13891(java.lang.String)] > > (while inserting: > > > [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08 > > > 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/login?externalLoginKey=EL70492148788(java.lang.String)][requestUrl,https://localhost:8443/catalog/control/UpdateAllKeywords(java.lang.String)][runningTimeMillis,234(java.lang.Lon > > > > > g)][serverHostName,envisage1(java.lang.String)][serverIpAddress,192.168.1.9(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,13891(java.lang.String)] > > (SQL Exception while executing the > following:INSERT > > INTO SERVER_HIT (VISIT_ID, CONTENT_ID, > > HIT_START_DATE_TIME, HIT_TYPE_ID, > > INTERNAL_CONTENT_ID, NUM_OF_BYTES, > > RUNNING_TIME_MILLIS, USER_LOGIN_ID, PARTY_ID, > > STATUS_ID, REQUEST_URL, REFERRER_URL, > > ID_BY_IP_CONTACT_MECH_ID, > > REF_BY_WEB_CONTACT_MECH_ID, SERVER_IP_ADDRESS, > > SERVER_HOST_NAME, LAST_UPDATED_STAMP, > > LAST_UPDATED_TX_STAMP, CREATED_STAMP, > > CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, > > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry > > 'REQUEST' for key 2))). Rolling back > > transaction.Exception: > > org.ofbiz.entity.GenericEntityExceptionMessage: > > Exception while inserting the following entity: > > > [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08 > > 15:52 > > > > > :15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08 > > > 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08 > > > 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08 > > [EMAIL PROTECTED] > wroteIf > > I were to guess, your product doesn't have > > anintroduction date. I don't know why it would > > needthat date because you didn't post enough of > the > > log.--- [EMAIL PROTECTED] 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 > === message truncated ===
