Divi4 and Divi5 not compatible with remove calc rows - Scalability Pro and Auto infinite Scroll

[thinkjarvisdesignandmarketing]

PLEASE COMPLETE ALL STEPS TO SPEED UP BUG FIXES

If you turn on Remove Calc Rows on the front end when using Divi4 or the new Divi5 - The pagination gets removed completely from the front end output.

On larger sites - This causes Divi to become very slow when browsing through product archives.

We use REDIS and WP-Rocket along with other specific optimisations.

IMPORTANT CONTEXT

1. Divi by elegant themes pagination appears to be incompatible with SPRO remove calc rows.
2. This is causing us some major issues on some new large Divi4 and Divi5 sites we have developed
3. I am not sure if this is a sudden incompatibility or not
4. Divi4 has not had a major version release for a long time due to the move to Divi5
5. Divi5 has the same compatibility problem
6. The Divi Blog by default uses next and previous buttons so for compatibility with SPRO and Auto Infinite Scroll we normally install wp-pagenavi - A free plugin from wordpress.org https://wordpress.org/plugins/wp-pagenavi/ . This plugin adds numbered pagination to the blog pages.

Tell us which version number of our plugin(s) you are using.

Scalability Pro 6.18
Auto Inf 1.62

Tell us what you have tried so far.

Disabling all plugins.
Checking it against our other theme setup with Enfold which doesnt have this problem.

Is it possible to get a fix or compatibility fix so we can utilise these settings with Divi?
The fix will likely work in both Divi4 and the new Divi5 as the problem persists in both versions.

With calc rows set to slowest:
Works fine on both woocommerce and blog (with wp-pagenavi for blog compatibility)

With calc rows set to fastest
The pagination gets stripped out of the output code.

We have a live job that really needs this enabling - It has 49,000 products.

[thinkjarvisdesignandmarketing]

Any news on this?

Just pasting in the notes from our chat:

Possible cause: Divi is breaking one of these filters:

for calctotals

spro_add_query_alterations() - This is where the option is checked and hooks are added
spro_remove_sql_calc_found_rows_dynamically() - This is the function that gets hooked to 'pre_get_posts'
spro_maybe_fake_total_found_posts() - This gets called via 'post_limits_request' filter
spro_remove_sql_calc_found_rows() - This gets called via 'posts_request' filter
spro_set_fake_found_posts() - This gets called via 'posts_results' filter
spro_fake_found_posts() - This gets called via 'found_posts' filter

[thinkjarvisdesignandmarketing]

I have sent this thread to Divi support for comment this morning.

[thinkjarvisdesignandmarketing]

Divi support have passed the Remove_Calc_Rows issue to their compatibility team but I doubt they will do anything about it any time soon.

I am assuming that the Woo Product module in Divi is correctly using WooCommerce defaults but is not able to see the Scalability Pro fake fields.

Any news on investigating this?

[dhilditch]

Checked Scalability Pro 6.26.7 and Auto Infinite Scroll 1.71. SPRO still supplies fake found-post totals while Divi owns its own pagination renderer, and AIS depends on pagination links being present. Suggested fix: add a Divi query adapter that sets the effective found_posts/max_num_pages expected by its module before AIS reads the links.