Просмотр поста

AlkatraZ, Проверить надо блокировку таблиц, с query что то из базы возвращает.
General error: 2014 Cannot execute queries while other unbuffered queries are active.

// /system/src/Utility/Cleanup.php line 37
    private function cleanupTable(string $table, string $timestampField, int $condition): void
    {
        //$this->pdo->query('LOCK TABLE `' . $table . '` WRITE');
        //$this->pdo->query('DELETE FROM `' . $table . '` WHERE `' . $timestampField . '` < ' . $condition);
        //$this->pdo->query('OPTIMIZE TABLE `' . $table . '`');
        //$this->pdo->query('UNLOCK TABLES');
        $this->pdo->exec('LOCK TABLE `' . $table . '` WRITE');
        $this->pdo->query('DELETE FROM `' . $table . '` WHERE `' . $timestampField . '` < ' . $condition);
        $this->pdo->query('OPTIMIZE TABLE `' . $table . '`');
        $this->pdo->exec('UNLOCK TABLES');
    }