Invalid list SQL

[Norwegian_Rat]

Hi, 

Suddenly we got a "Invalid list SQL" error when we click on "Active shopping carts" from the Activity overview and the customers tab. 

Both Error in log says this:

Message:
ThirtyBeesDatabaseException: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

Location:
classes/Customer.php line 827, classes/controller/AdminController.php line 1184

Can anyone help shed some light on this? Not being able to modify customers could become a serious issue down the road 🙂

we're on latest bleeding edge and php 8.3.30

 

Thanx in advance