Synchronize index not working.
- OEMParticipant4 years, 5 months ago #19758
I get the following error (I removed some parts for security reasons):
An error or timeout occured.
Error code: parsererror
Error message: SyntaxError: JSON Parse error: Unable to parse JSON string
{“models_nb_results”:{“product”:1},”nb_results”:1,”status”:0,”indexing_complete”:false,”debug_text”:”Posts excluded from the index:<br><b><\/b><br><br>******** DEBUG ACTIVATED – Beginning of new loop (batch size) *******<br><br>******** DEBUG ACTIVATED – Query documents from last post date *******<br><br>Query:<br><b>SELECT ID, post_modified, post_parent, post_type FROM 42cUR9_posts AS A WHERE ((post_modified = ‘2016-01-11 03:00:42’ AND ID > 9543) OR (post_modified > ‘2016-01-11 03:00:42’)) AND ( post_status NOT IN (‘auto-draft’) AND ( post_type = ‘product’ ) ) ORDER BY post_modified ASC, ID ASC LIMIT 1<\/b><br><br>Last post date:<br><b>2016-01-11 03:00:42<\/b><br><br>Last post ID:<br><b>9543<\/b><br><br>Post to be sent:<br><b>{\n \”id\”: \”9544\”,\n \”PID\”: \”9544\”,\n \”type\”: \”product\”,\n \”meta_type_s\”: \”post_type\”,\n \”displaymodified\”: \”2016-01-11T03:01:04Z\”,\n \”title\”: \”Coilovers AP BMW S\\u00e9rie 5 Limousine F10 (5L)\”,\n \”title_s\”: \”Coilovers AP BMW S\\u00e9rie 5 Limousine F10 (5L)\”,\n \”permalink\”: \”https:\\\/\\\/***************\\/home\\\/produto\\\/coilovers-ap-bmw-serie-5-limousine-f10-5l-9\\\/\”,\n \”post_status_s\”: \”publish\”,\n \”content\”: \”Coilovers AP, BMW S\\u00e9rie 5 Limousine F10 (5L) 535dKit suspens\\u00e3o desportiva regul\\u00e1vel em alturaExcelente rela\\u00e7\\u00e3o qualidade\\\/pre\\u00e7oTecnologia KWNotas do fabricante (traduzido do Alem\\u00e3o, pode conter erros ortogr\\u00e1ficos):1 = N\\u00e3o \\u00e9 para ve\\u00edculos com all-volante.27 = No caso de ve\\u00edculos equipados com controlo de amortecimento eletr\\u00f4nico \\u00e9 desmantelar-los. 535d, 03\\\/2010- AP. F10 (5L). Gas\\u00f3leo. BMW. S\\u00e9rie 5 Limousine. 535d. 220. GF20-080. COILAP6379\”,\n \”snippet_s\”: \”535d, 03\\\/2010-\”,\n \”post_author_s\”: \”0\”,\n \”author\”: \”\”,\n \”menu_order_i\”: 0,\n \”PID_i\”: \”9544\”,\n \”author_s\”: \”\”,\n \”displaydate\”: \”2016-01-11T03:01:04Z\”,\n \”displaydate_dt\”: \”2016-01-11T03:01:04Z\”,\n \”date\”: \”2016-01-11T03:01:04Z\”,\n \”displaymodified_dt\”: \”2016-01-11T03:01:04Z\”,\n \”modified\”: \”2016-01-11T03:01:04Z\”,\n \”displaymodified_dt_i\”: \”1452481264\”,\n \”displaymodified_dt_y_i\”: \”2016\”,\n \”displaymodified_dt_ym_i\”: \”1\”,\n \”displaymodified_dt_yw_i\”: \”2\”,\n \”displaymodified_dt_yd_i\”: \”11\”,\n \”displaymodified_dt_md_i\”: \”11\”,\n \”displaymodified_dt_wd_i\”: \”2\”,\n \”displaymodified_dt_dh_i\”: \”3\”,\n \”displaymodified_dt_dm_i\”: \”1\”,\n \”displaymodified_dt_ds_i\”: \”4\”,\n \”displaydate_dt_i\”: \”1452481264\”,\n \”displaydate_dt_y_i\”: \”2016\”,\n \”displaydate_dt_ym_i\”: \”1\”,\n \”displaydate_dt_yw_i\”: \”2\”,\n \”displaydate_dt_yd_i\”: \”11\”,\n \”displaydate_dt_md_i\”: \”11\”,\n \”displaydate_dt_wd_i\”: \”2\”,\n \”displaydate_dt_dh_i\”: \”3\”,\n \”displaydate_dt_dm_i\”: \”1\”,\n \”displaydate_dt_ds_i\”: \”4\”,\n \”date_i\”: \”1452481264\”,\n \”date_y_i\”: \”2016\”,\n \”date_ym_i\”: \”1\”,\n \”date_yw_i\”: \”2\”,\n \”date_yd_i\”: \”11\”,\n \”date_md_i\”: \”11\”,\n \”date_wd_i\”: \”2\”,\n \”date_dh_i\”: \”3\”,\n \”date_dm_i\”: \”1\”,\n \”date_ds_i\”: \”4\”,\n \”displaydate_i\”: \”1452481264\”,\n \”displaydate_y_i\”: \”2016\”,\n \”displaydate_ym_i\”: \”1\”,\n \”displaydate_yw_i\”: \”2\”,\n \”displaydate_yd_i\”: \”11\”,\n \”displaydate_md_i\”: \”11\”,\n \”displaydate_wd_i\”: \”2\”,\n \”displaydate_dh_i\”: \”3\”,\n \”displaydate_dm_i\”: \”1\”,\n \”displaydate_ds_i\”: \”4\”,\n \”modified_i\”: \”1452481264\”,\n \”modified_y_i\”: \”2016\”,\n \”modified_ym_i\”: \”1\”,\n \”modified_yw_i\”: \”2\”,\n \”modified_yd_i\”: \”11\”,\n \”modified_md_i\”: \”11\”,\n \”modified_wd_i\”: \”2\”,\n \”modified_dh_i\”: \”3\”,\n \”modified_dm_i\”: \”1\”,\n \”modified_ds_i\”: \”4\”,\n \”comments\”: [],\n \”numcomments\”: 0,\n \”categories_str\”: [],\n \”categories\”: [\n \”AP\”,\n \”F10 (5L)\”,\n \”Gas\\u00f3leo\”,\n \”BMW\”,\n \”S\\u00e9rie 5 Limousine\”,\n \”535d\”,\n \”220\”,\n \”GF20-080\”,\n \”COILAP6379\”\n ],\n \”flat_hierarchy_categories_str\”: [],\n \”non_flat_hierarchy_categories_str\”: [],\n \”tags\”: [],\n \”product_cat_str\”: [\n \”AP\”\n ],\n \”flat_hierarchy_product_cat_str\”: [\n \”Suspens\\u00e3o->Coilovers->AP\”\n ],\n \”non_flat_hierarchy_product_cat_str\”: [\n \”Suspens\\u00e3o\”,\n \”Coilovers\”,\n \”AP\”\n ],\n \”pa_chassis_str\”: [\n \”F10 (5L)\”\n ],\n \”flat_hierarchy_pa_chassis_str\”: [\n \”F10 (5L)\”\n ],\n \”non_flat_hierarchy_pa_chassis_str\”: [\n \”F10 (5L)\”\n ],\n \”pa_combustivel_str\”: [\n \”Gas\\u00f3leo\”\n ],\n \”flat_hierarchy_pa_combustivel_str\”: [\n \”Gas\\u00f3leo\”\n ],\n \”non_flat_hierarchy_pa_combustivel_str\”: [\n \”Gas\\u00f3leo\”\n ],\n \”pa_marca_str\”: [\n \”BMW\”\n ],\n \”flat_hierarchy_pa_marca_str\”: [\n \”BMW\”\n ],\n \”non_flat_hierarchy_pa_marca_str\”: [\n \”BMW\”\n ],\n \”pa_modelo_str\”: [\n \”S\\u00e9rie 5 Limousine\”\n ],\n \”flat_hierarchy_pa_modelo_str\”: [\n \”S\\u00e9rie 5 Limousine\”\n ],\n \”non_flat_hierarchy_pa_modelo_str\”: [\n \”S\\u00e9rie 5 Limousine\”\n ],\n \”pa_motor_str\”: [\n \”535d\”\n ],\n \”flat_hierarchy_pa_motor_str\”: [\n \”535d\”\n ],\n \”non_flat_hierarchy_pa_motor_str\”: [\n \”535d\”\n ],\n \”pa_potencia_str\”: [\n \”220\”\n ],\n \”flat_hierarchy_pa_potencia_str\”: [\n \”220\”\n ],\n \”non_flat_hierarchy_pa_potencia_str\”: [\n \”220\”\n ],\n \”pa_referencia_str\”: [\n \”GF20-080\”\n ],\n \”flat_hierarchy_pa_referencia_str\”: [\n \”GF20-080\”\n ],\n \”non_flat_hierarchy_pa_referencia_str\”: [\n \”GF20-080\”\n ],\n \”_price_f\”: [],\n \”_price_str\”: [],\n \”_sku_str\”: [\n \”COILAP6379\”\n ]\n}<\/b><br><br>”}{“nb_results”:0,”status”:8,”message”:”Error on line 384 of file \****************** (removed)*******\/wp-content\/plugins\/wpsolr-pro\/wpsolr\/core\/ajax_solr_services.php: Trying to access array offset on value of type null”,”indexing_complete”:false}
————————————————————
Might be related. 2 days ago, I have the following Woocommerce log entry:
2020-05-01T11:16:30+00:00 CRITICAL Uncaught Solarium\Exception\HttpException: Solr HTTP error: OK (400)
{
“error”:{
“metadata”:[
“error-class”,”org.apache.solr.common.SolrException”,
“root-error-class”,”org.apache.solr.common.SolrException”],
“msg”:”undefined field undefined”,
“code”:400}}
in /var/www/vhosts/oemperformance.com/httpdocs/home/wp-content/plugins/wpsolr-pro/wpsolr/core/vendor/solarium/solarium/library/Solarium/Core/Query/Result/Result.php:106
Stack trace:
*********(removed remaining text for security resons)2020-05-01T11:16:32+00:00 CRITICAL Uncaught Solarium\Exception\HttpException: Solr HTTP error: OK (400)
{
“error”:{
“metadata”:[
“error-class”,”org.apache.solr.common.SolrException”,
“root-error-class”,”org.apache.solr.common.SolrException”],
“msg”:”undefined field undefined”,
“code”:400}}
in /var/www/vhosts/*********(removed remaining text for security resons)OEMParticipant4 years, 5 months ago #19761org.apache.solr.common.SolrException: org.apache.solr.search.SyntaxError: Cannot parse ‘product_tag_str:”2.5 (15″ Wheels)”‘: Encountered ” “)” “) “” at line 1, column 32.
Was expecting one of:
<EOF>
<AND> …
<OR> …
<NOT> …
“+” …
“-” …
<BAREOPER> …
“(” …
“*” …
“^” …
<QUOTED> …
<TERM> …
<FUZZY_SLOP> …
<PREFIXTERM> …
<WILDTERM> …
<REGEXPTERM> …
“[” …
“{” …
<LPARAMS> …
“filter(” …
<NUMBER> …at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:219)
at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:302)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:211)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:2596)
at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:802)
at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:579)
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:420)
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:352)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
at org.eclipse.jetty.server.handler.InetAccessHandler.handle(InetAccessHandler.java:177)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:500)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.solr.search.SyntaxError: Cannot parse ‘product_tag_str:”2.5 (15″ Wheels)”‘: Encountered ” “)” “) “” at line 1, column 32.
Was expecting one of:
<EOF>
<AND> …
<OR> …
<NOT> …
“+” …
“-” …
<BAREOPER> …
“(” …
“*” …
“^” …
<QUOTED> …
<TERM> …
<FUZZY_SLOP> …
<PREFIXTERM> …
<WILDTERM> …
<REGEXPTERM> …
“[” …
“{” …
<LPARAMS> …
“filter(” …
<NUMBER> …at org.apache.solr.parser.SolrQueryParserBase.parse(SolrQueryParserBase.java:267)
at org.apache.solr.search.LuceneQParser.parse(LuceneQParser.java:49)
at org.apache.solr.search.QParser.getQuery(QParser.java:174)
at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:208)
… 44 more
Caused by: org.apache.solr.parser.ParseException: Encountered ” “)” “) “” at line 1, column 32.
Was expecting one of:
<EOF>
<AND> …
<OR> …
<NOT> …
“+” …
“-” …
<BAREOPER> …
“(” …
“*” …
“^” …
<QUOTED> …
<TERM> …
<FUZZY_SLOP> …
<PREFIXTERM> …
<WILDTERM> …
<REGEXPTERM> …
“[” …
“{” …
<LPARAMS> …
“filter(” …
<NUMBER> …at org.apache.solr.parser.QueryParser.generateParseException(QueryParser.java:885)
at org.apache.solr.parser.QueryParser.jj_consume_token(QueryParser.java:767)
at org.apache.solr.parser.QueryParser.TopLevelQuery(QueryParser.java:132)
at org.apache.solr.parser.SolrQueryParserBase.parse(SolrQueryParserBase.java:263)
… 47 more
Last Check: 04/05/2020, 20:21:34
Show dates in UTCOEMParticipant4 years, 5 months ago #19762org.apache.solr.common.SolrException: undefined field undefined
at org.apache.solr.schema.IndexSchema.getDynamicFieldType(IndexSchema.java:1319)
at org.apache.solr.schema.IndexSchema$SolrQueryAnalyzer.getWrappedAnalyzer(IndexSchema.java:462)
at org.apache.lucene.analysis.DelegatingAnalyzerWrapper$DelegatingReuseStrategy.getReusableComponents(DelegatingAnalyzerWrapper.java:86)
at org.apache.lucene.analysis.Analyzer.tokenStream(Analyzer.java:192)
at org.apache.lucene.util.QueryBuilder.createFieldQuery(QueryBuilder.java:262)
at org.apache.solr.parser.SolrQueryParserBase.newFieldQuery(SolrQueryParserBase.java:527)
at org.apache.solr.parser.QueryParser.newFieldQuery(QueryParser.java:62)
at org.apache.solr.parser.SolrQueryParserBase.getFieldQuery(SolrQueryParserBase.java:1102)
at org.apache.solr.parser.SolrQueryParserBase.getFieldQuery(SolrQueryParserBase.java:544)
at org.apache.solr.parser.SolrQueryParserBase.handleQuotedTerm(SolrQueryParserBase.java:841)
at org.apache.solr.parser.QueryParser.Term(QueryParser.java:549)
at org.apache.solr.parser.QueryParser.Clause(QueryParser.java:278)
at org.apache.solr.parser.QueryParser.Query(QueryParser.java:162)
at org.apache.solr.parser.QueryParser.TopLevelQuery(QueryParser.java:131)
at org.apache.solr.parser.SolrQueryParserBase.parse(SolrQueryParserBase.java:263)
at org.apache.solr.search.LuceneQParser.parse(LuceneQParser.java:49)
at org.apache.solr.search.QParser.getQuery(QParser.java:174)
at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:208)
at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:302)
at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:211)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:2596)
at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:802)
at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:579)
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:420)
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:352)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
at org.eclipse.jetty.server.handler.InetAccessHandler.handle(InetAccessHandler.java:177)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:500)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
at java.lang.Thread.run(Thread.java:748)OEMParticipant4 years, 5 months ago #19766Ok, now what? What is your suggestion? How do I resolve this? Do you have another means of contact other than a public forum?
I have other issues as well, such as:
– Using ajax, breadcrumbs not updating correctly with all the levels of categories -> subcategories, although permalink works correctly. When not using ajax there is no problem.
– select2 drop down list.. number of maximum facet results in the drop down list. There seems to be a max number of facets to be displayed. I need to adjust one of them to show more. For example, I have a brand that has a catalogue for most makes of cars. The drop down list will not show all makes for selection because the list is big. It goes from Audi.. Austin… till VW.. Volvo… but it stops half way. So I only get the makes from A to K… and the rest is missing.
You must be logged in to reply to this topic.