PW 3.0.200 after updating MAX_JOIN_SIZE problem

[Nomak]

Hey folks,

after updating one of my websites to PW 3.0.200, going to the Processwire admin panel and klicking on "setup > logs > session" (same with "> messages" etc.) fires the following error:

Exception: SQLSTATE[42000]: Syntax error or access violation: 1104 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 (in wire/core/PagesPathFinder.php line 356)

Does anyone know how to solve this issue?

Best

[sz-ligatur]

Hello @Nomak, I have the same error here on my live setup, getting this error on e.g. pagelister, view a log, edit template or field – did you find a solution?

SQLSTATE[42000]: Syntax error or access violation: 1104 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 
in File: .../www/agi-placementtest/wire/core/PagesPathFinder.php:356

I guess it's related to mySQL 8 – any idea what I can do to fix this?

ProcessWire: 3.0.229
PHP: 8.1.22-he.0
Webserver: Apache
MySQL Server: 8.0.35-27
MySQL Client: mysqlnd 8.1.22-he.0

File: .../www/agi-placementtest/wire/core/PagesPathFinder.php:356

346:            $selects = implode(', ', $selects);
347:            $joins = implode(" \n", $joins);
348:            $wheres = implode(" AND ", $wheres);
349:            $sql = "SELECT $selects \nFROM pages \n$joins \nWHERE $wheres";
350:            $query = $database->prepare($sql);
351:    
352:            foreach($binds as $bindKey => $bindValue) {
353:                $query->bindValue(":$bindKey", $bindValue);
354:            }
355:    
356:            $query->execute();	// <-------- error here

357:            $rowCount = (int) $query->rowCount();
358:            $row = $query->fetch(\PDO::FETCH_ASSOC);
359:            $query->closeCursor();
360: