Index Problem

  • giannissak
    Participant
    4 months, 4 weeks ago #30271

    Hi Patrice,
    when running index post data i ‘m getting the folowing error.
    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 wp_posts AS A WHERE ((post_modified = ‘2022-06-02 08:40:13’ AND ID > 13042) OR (post_modified > ‘2022-06-02 08:40:13’)) AND ( post_status IN (‘publish’) AND ( post_type = ‘product’ ) ) ORDER BY post_modified ASC, ID ASC LIMIT 1</b><br><br>Last post date:<br><b>2022-06-02 08:40:13</b><br><br>Last post ID:<br><b>13042</b><br><br>Post to be sent:<br><b>{ “id”: 13618, “PID”: 13618, “type”: “product”, “meta_type_s”: “post_type”, “displaymodified”: “2022-06-02T08:55:49Z”, “title”: “STANLEY FATMAX \u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0391 304mm \u039c\u0395 \u03a0\u0399\u0395\u03a3\u039f\u039c\u0395\u039d\u039f \u039a\u039f\u03a5\u039c\u03a0\u0399 \u03a1\u03a5\u0398\u039c\u0399\u03a3\u0397\u03a3 (0-84-649)”, “title_s”: “STANLEY FATMAX \u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0391 304mm \u039c\u0395 \u03a0\u0399\u0395\u03a3\u039f\u039c\u0395\u039d\u039f \u039a\u039f\u03a5\u039c\u03a0\u0399 \u03a1\u03a5\u0398\u039c\u0399\u03a3\u0397\u03a3 (0-84-649)”, “permalink”: “https:\/\/n-baxevanis.gr\/product\/stanley-fatmax-%ce%b3%ce%ba%ce%b1%ce%b6%ce%bf%cf%84%ce%b1%ce%bd%ce%b1%ce%bb%ce%b9%ce%b1-304mm-%ce%bc%ce%b5-%cf%80%ce%b9%ce%b5%cf%83%ce%bf%ce%bc%ce%b5%ce%bd%ce%bf-%ce%ba%ce%bf%cf%85%ce%bc%cf%80%ce%b9\/”, “product_stock_str”: “n”, “wpsolr_on_sale_str”: [ “n” ], “post_status_s”: “publish”, “content”: “\u03a0\u03bf\u03bb\u03bb\u03b1\u03c0\u03bb\u03ad\u03c2 \u03a7\u03c1\u03ae\u03c3\u03b5\u03b9\u03c2 – \u0392\u03b9\u03bf\u03bc\u03b7\u03c7\u03b1\u03bd\u03b9\u03ba\u03ad\u03c2, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03b9\u03ba\u03ad\u03c2, \u03b1\u03c5\u03c4\u03bf\u03ba\u03b9\u03bd\u03ae\u03c4\u03bf\u03c5 \u03ba\u03b1\u03b9 DIY\r\n\r\n\u03a3\u03c5\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03af\u03b1 \u03c0\u03bf\u03c5 \u03b4\u03af\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03b4\u03bf\u03ba\u03b9\u03bc\u03ae\u03c2 \u03c4\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf\u03c5\r\n\r\n\u03a0\u03b1\u03c4\u03b5\u03bd\u03c4\u03b1\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf\u03c2 \u03bc\u03b7\u03c7\u03b1\u03bd\u03b9\u03c3\u03bc\u03cc\u03c2 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b7\u03c2 \u03c1\u03cd\u03b8\u03bc\u03b9\u03c3\u03b7\u03c2\r\n\r\n\u0395\u03cd\u03ba\u03bf\u03bb\u03b7 \u03c3\u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03bb\u03cc\u03b3\u03c9 \u03c4\u03bf\u03c5 \u03ba\u03bf\u03bc\u03b2\u03af\u03bf\u03c5 \u03c1\u03cd\u03b8\u03bc\u03b9\u03c3\u03b7\u03c2 PushLock\u2122 simple. outofstock. \u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3. \u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391. \u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3. \u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3. Stanley. \u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3. 75 mm. 0.56 kg. n”, “post_author_s”: “0”, “author”: “”, “menu_order_i”: 0, “PID_i”: 13618, “author_s”: “”, “displaydate”: “2022-02-04T09:48:30Z”, “displaydate_dt”: “2022-02-04T09:48:30Z”, “date”: “2022-02-04T09:48:30Z”, “displaymodified_dt”: “2022-06-02T08:55:49Z”, “modified”: “2022-06-02T08:55:49Z”, “displaymodified_dt_i”: 1654160149000, “displaymodified_dt_y_i”: 2022, “displaymodified_dt_ym_i”: 6, “displaymodified_dt_yw_i”: 22, “displaymodified_dt_yd_i”: 153, “displaymodified_dt_md_i”: 2, “displaymodified_dt_wd_i”: 5, “displaymodified_dt_dh_i”: 8, “displaymodified_dt_dm_i”: 55, “displaymodified_dt_ds_i”: 49, “displaydate_dt_i”: 1643968110000, “displaydate_dt_y_i”: 2022, “displaydate_dt_ym_i”: 2, “displaydate_dt_yw_i”: 5, “displaydate_dt_yd_i”: 35, “displaydate_dt_md_i”: 4, “displaydate_dt_wd_i”: 6, “displaydate_dt_dh_i”: 9, “displaydate_dt_dm_i”: 48, “displaydate_dt_ds_i”: 30, “date_i”: 1643968110000, “date_y_i”: 2022, “date_ym_i”: 2, “date_yw_i”: 5, “date_yd_i”: 35, “date_md_i”: 4, “date_wd_i”: 6, “date_dh_i”: 9, “date_dm_i”: 48, “date_ds_i”: 30, “displaydate_i”: 1643968110000, “displaydate_y_i”: 2022, “displaydate_ym_i”: 2, “displaydate_yw_i”: 5, “displaydate_yd_i”: 35, “displaydate_md_i”: 4, “displaydate_wd_i”: 6, “displaydate_dh_i”: 9, “displaydate_dm_i”: 48, “displaydate_ds_i”: 30, “modified_i”: 1654160149000, “modified_y_i”: 2022, “modified_ym_i”: 6, “modified_yw_i”: 22, “modified_yd_i”: 153, “modified_md_i”: 2, “modified_wd_i”: 5, “modified_dh_i”: 8, “modified_dm_i”: 55, “modified_ds_i”: 49, “comments”: [], “numcomments”: 0, “categories_str”: [], “categories”: [ “simple”, “outofstock”, “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3”, “\u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3”, “Stanley”, “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3”, “75 mm”, “0.56 kg”, “n” ], “flat_hierarchy_categories_str”: [], “non_flat_hierarchy_categories_str”: [], “tags”: [], “product_type_str”: [ “simple” ], “flat_hierarchy_product_type_str”: [ “simple” ], “non_flat_hierarchy_product_type_str”: [ “simple” ], “product_visibility_str”: [ “outofstock” ], “flat_hierarchy_product_visibility_str”: [ “outofstock” ], “non_flat_hierarchy_product_visibility_str”: [ “outofstock” ], “product_cat_str”: [ “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3”, “\u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3” ], “flat_hierarchy_product_cat_str”: [ “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391->\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3->\u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3->\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391->\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391->\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3->\u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3” ], “non_flat_hierarchy_product_cat_str”: [ “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3”, “\u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3”, “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391”, “\u0395\u03a1\u0393\u0391\u039b\u0395\u0399\u0391 \u03a7\u0395\u0399\u03a1\u039f\u03a3”, “\u03a0\u0395\u039d\u03a3\u0395\u03a3-\u039a\u039f\u03a6\u03a4\u0395\u03a3” ], “pa_brands_str”: [ “Stanley” ], “flat_hierarchy_pa_brands_str”: [ “Stanley” ], “non_flat_hierarchy_pa_brands_str”: [ “Stanley” ], “pa_categories_str”: [ “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3” ], “flat_hierarchy_pa_categories_str”: [ “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3” ], “non_flat_hierarchy_pa_categories_str”: [ “\u0393\u039a\u0391\u0396\u039f\u03a4\u0391\u039d\u0391\u039b\u0399\u0395\u03a3” ], “pa_esw-dia-siagwnwn_str”: [ “75 mm” ], “flat_hierarchy_pa_esw-dia-siagwnwn_str”: [ “75 mm” ], “non_flat_hierarchy_pa_esw-dia-siagwnwn_str”: [ “75 mm” ], “pa_varos_str”: [ “0.56 kg” ], “flat_hierarchy_pa_varos_str”: [ “0.56 kg” ], “non_flat_hierarchy_pa_varos_str”: [ “0.56 kg” ] }</b><br><br>{“nb_results”:0,”status”:0,”message”:”failed to parse”,”indexing_complete”:false}

    wpsolr
    Keymaster
    4 months, 4 weeks ago #30272

    Thanks for the debug log.

    But can you see an error message (but ”failed to parse”)?

    giannissak
    Participant
    4 months, 4 weeks ago #30274

    where should i see that error ?

    giannissak
    Participant
    4 months, 4 weeks ago #30275

    Error code: parsererror
    Error message: SyntaxError: Unexpected token P in JSON at position 0

    wpsolr
    Keymaster
    4 months, 4 weeks ago #30276

    In your debug.log?

    giannissak
    Participant
    4 months, 3 weeks ago #30294

    Have no errors when indexing in debug.log

    giannissak
    Participant
    4 months, 3 weeks ago #30308

    i keep getting Error code: parsererror
    Error message: SyntaxError: Unexpected token P in JSON at position 0
    i can’t find any error , can you please help me .

    wpsolr
    Keymaster
    4 months, 3 weeks ago #30310

    Can you edit and save your post 13618?

    giannissak
    Participant
    4 months, 3 weeks ago #30312

    yes, i can,
    also, if update the product , it pass the index but it stack to the next one e.c,

    wpsolr
    Keymaster
    4 months, 3 weeks ago #30315

    Did you see the “(WPSOLR) Post updated in index XXX” notice while saving your post?

    giannissak
    Participant
    4 months, 3 weeks ago #30316

    (WPSOLR) Product updated in index , Yes!

    wpsolr
    Keymaster
    4 months, 3 weeks ago #30317

    In your debug trace, do you see “ or ” characters?

    giannissak
    Participant
    4 months, 3 weeks ago #30318

    no, i don’t

    wpsolr
    Keymaster
    4 months, 3 weeks ago #30319

    I took your post json content, and indexed it from the /document menu in my Solr admin. Can you do it too?

    Image wpsolr-index-from-solr-admin-1024x530.png of

    giannissak
    Participant
    4 months, 3 weeks ago #30323

    no , i use elasticsearch

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic.