• Since the latest version (4.1.7), an infinite loop sends the following request, which blocks the display of the site.

    SELECT SQL_CALC_FOUND_ROWS  wp_3_posts.ID
    FROM wp_3_posts
    LEFT JOIN wp_3_term_relationships ON (wp_3_posts.ID = wp_3_term_relationships.object_id)  
    LEFT JOIN wp_3_term_relationships AS tt1 ON (wp_3_posts.ID = tt1.object_id) 
    LEFT JOIN wp_3_postmeta ON ( wp_3_posts.ID = wp_3_postmeta.post_id )  
    LEFT JOIN wp_3_postmeta AS mt1 ON ( wp_3_posts.ID = mt1.post_id AND mt1.meta_key = 'rwpp_sortorder_378' ) 
    LEFT JOIN wp_3_posts AS p2 ON (wp_3_posts.post_parent = p2.ID)  
    LEFT  JOIN wp_3_icl_translations wpml_translations                                                         
    ON wp_3_posts.ID = wpml_translations.element_id                                                                 
    AND wpml_translations.element_type = CONCAT('post_', wp_3_posts.post_type)                         
    WHERE 1=1  
    AND (   wp_3_posts.ID NOT IN (
                                     SELECT object_id
                                     FROM wp_3_term_relationships
                                     WHERE term_taxonomy_id IN (7)
                             )   AND   wp_3_term_relationships.term_taxonomy_id IN (378)   AND   tt1.term_taxonomy_id IN (378) ) 
    AND (   (     wp_3_postmeta.meta_key = 'rwpp_sortorder_378'     OR     mt1.post_id IS NULL   ) ) 
    AND wp_3_posts.post_type = 'product' 
    AND (((wp_3_posts.post_status = 'publish') OR (wp_3_posts.post_status = 'inherit' AND (p2.post_status = 'publish')))) 
    AND ( ( ( wpml_translations.language_code = 'fr' OR 0 ) AND wp_3_posts.post_type  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','wpsl_stores' )  ) OR wp_3_posts.post_type  NOT  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','wpsl_stores' )  )                         
    GROUP BY wp_3_posts.ID                         
    ORDER BY wp_3_postmeta.meta_value+0 ASC, wp_3_posts.menu_order ASC, wp_3_posts.post_title ASC                         
    LIMIT 0, 24;
    


    I had to deactivate the plugin to get back to normal.
    Thank you for correcting, because this plugin is really excellent and I can not live without it :).

    WordPress Environment
    WC Version: 8.0.3
    REST API Version: ? 8.0.3
    WC Blocks Version: ? 11.0.0
    Action Scheduler Version: ? 3.6.1
    Log Directory Writable: ?
    WP Version: 6.3.1
    WP Multisite: ?
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: – Server Environment
    
    Server Info: Apache
    PHP Version: 7.4.33
    PHP Post Max Size: 64 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 2000
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.39-MariaDB-log
    Max Upload Size: 20 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘The plugin completely blocks the display of the store.’ is closed to new replies.