Product feed empty with scheduled generation

  • Resolved Ulrich

    (@ulrichboehm)


    11 months ago

    Hey guys,
    as soon as I use the scheduled feed generation, my feed is empty (zero byte file). The same happens if I use the update button in the feed overview. It only works fine if I edit the feed and click the update button within the edit view.

    While the scheduler tries to create the feed, the following error is shown in the server logs:

    [Tue Apr 23 19:52:51.523379 2024] [php:notice] [pid 2808518] [client ---] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) \n\t\t\tGROUP BY 3o184VSd_posts.ID\n\t\t\tORDER BY 3o184VSd_posts.ID ASC\n\t\t\tLIMIT ...' at line 5 for query \n\t\t\tSELECT SQL_CALC_FOUND_ROWS DISTINCT 3o184VSd_posts.ID\n\t\t\tFROM 3o184VSd_posts  LEFT JOIN 3o184VSd_term_relationships ON (3o184VSd_posts.ID = 3o184VSd_term_relationships.object_id) LEFT JOIN 3o184VSd_term_relationships AS RexPLL ON (3o184VSd_posts.ID = RexPLL.object_id)\n\t\t\tWHERE 1=1  AND ( \n  3o184VSd_term_relationships.term_taxonomy_id IN (103,107,111,115,119,123,152,218,294)\n) AND 3o184VSd_posts.post_type = 'product' AND ((3o184VSd_posts.post_status = 'publish')) AND (RexPLL.term_taxonomy_id IN()) \n\t\t\tGROUP BY 3o184VSd_posts.ID\n\t\t\tORDER BY 3o184VSd_posts.ID ASC\n\t\t\tLIMIT 0, 200\n\t\t made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('rex_feed_regenerate_feed_batch'), WP_Hook->do_action, WP_Hook->apply_filters, Rex_Feed_Scheduler->regenerate_feed_batch, Rex_Product_Feed_Factory::build, Rex_Product_Feed_Abstract_Generator->__construct, Rex_Product_Feed_Abstract_Generator->setup_products, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    It looks like the last RexPLL.term_taxonomy_id IN() is empty. There are no more visible errors in the edit view.

    Hope you can help me.
    Best regards,
    U

    • This topic was modified 11 months ago by Ulrich.
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @ulrichboehm,

    Thank you for reaching out. It seems like you’re encountering an issue with scheduled feed generation, which might be related to the Polylang plugin.

    To further investigate and assist you, could you please provide screenshots of your Polylang plugin settings? Specifically, we’d need to see:

    Screenshot 1: Polylang Plugin Settings

    Screenshot 2: Polylang Language Settings

    Once we have this information, we’ll be better able to diagnose and resolve the issue you’re experiencing.

    Best regards,

    Thread Starter Ulrich

    (@ulrichboehm)

    Hi,
    it looks like your hint with Polylang did the trick. I’ve found a message that we had a few posts without language (on the Polylang language settings page) and the possibility to set all (empty) posts to the default language. Since doing that the scheduled feed generation works like it should.

    Everyhting is resolved. Thank you for you support!

    Best regards,
    U

    Hi @ulrichboehm,

    It’s good to hear that the issue is resolved now.

    If you like using our plugin and are satisfied with our support we would appreciate it if you could leave a review for us here.

    A simple review from you will do wonders for us to build credibility and sustainability.

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Product feed empty with scheduled generation’ is closed to new replies.