Server error when fetching search index
Sentry Issue: FOODSHARINGDE-BETA-BACKEND-1CT
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'CONCAT("\"",region.name,"\";\"",IFNULL(mailbox.name, ""),"\";\"",parent.name,...' at line 13
File "/src/Modules/Core/Database.php", line 659, in Foodsharing\Modules\Core\Database::preparedQuery
return $statement->executeQuery();
File "/src/Modules/Core/Database.php", line 441, in Foodsharing\Modules\Core\Database::fetchAll
$out = $this->preparedQuery($query, $params)->fetchAllAssociative();
File "/src/Modules/Search/SearchGateway.php", line 234, in Foodsharing\Modules\Search\SearchGateway::getWorkingGroupsForSearchIndex
[$foodsaverId, $foodsaverId, $foodsaverId]);
File "/src/Modules/Search/SearchTransactions.php", line 101, in Foodsharing\Modules\Search\SearchTransactions::searchIndex
$result->workingGroups = $this->searchGateway->getWorkingGroupsForSearchIndex($foodsaverId);
File "/src/RestApi/SearchRestController.php", line 119, in Foodsharing\RestApi\SearchRestController::searchIndex
$results = $this->searchTransactions->searchIndex();
...
(10 additional frame(s) were not displayed)
Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'CONCAT("\"",region.name,"\";\"",IFNULL(mailbox.name, ""),"\";\"",parent.name,...' at line 13
File "/src/Modules/Core/Database.php", line 659, in Foodsharing\Modules\Core\Database::preparedQuery
return $statement->executeQuery();
File "/src/Modules/Core/Database.php", line 441, in Foodsharing\Modules\Core\Database::fetchAll
$out = $this->preparedQuery($query, $params)->fetchAllAssociative();
File "/src/Modules/Search/SearchGateway.php", line 234, in Foodsharing\Modules\Search\SearchGateway::getWorkingGroupsForSearchIndex
[$foodsaverId, $foodsaverId, $foodsaverId]);
File "/src/Modules/Search/SearchTransactions.php", line 101, in Foodsharing\Modules\Search\SearchTransactions::searchIndex
$result->workingGroups = $this->searchGateway->getWorkingGroupsForSearchIndex($foodsaverId);
File "/src/RestApi/SearchRestController.php", line 119, in Foodsharing\RestApi\SearchRestController::searchIndex
$results = $this->searchTransactions->searchIndex();
...
(10 additional frame(s) were not displayed)
Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'CONCAT("\"",region.name,"\";\"",IFNULL(mailbox.name, ""),"\";\"",parent.name,...' at line 13
File "/src/Modules/Core/Database.php", line 659, in Foodsharing\Modules\Core\Database::preparedQuery
return $statement->executeQuery();
File "/src/Modules/Core/Database.php", line 441, in Foodsharing\Modules\Core\Database::fetchAll
$out = $this->preparedQuery($query, $params)->fetchAllAssociative();
File "/src/Modules/Search/SearchGateway.php", line 234, in Foodsharing\Modules\Search\SearchGateway::getWorkingGroupsForSearchIndex
[$foodsaverId, $foodsaverId, $foodsaverId]);
File "/src/Modules/Search/SearchTransactions.php", line 101, in Foodsharing\Modules\Search\SearchTransactions::searchIndex
$result->workingGroups = $this->searchGateway->getWorkingGroupsForSearchIndex($foodsaverId);
File "/src/RestApi/SearchRestController.php", line 119, in Foodsharing\RestApi\SearchRestController::searchIndex
$results = $this->searchTransactions->searchIndex();
...
(9 additional frame(s) were not displayed)