Возникла ошибка в Postman после запроса

возникла ошибка "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoices.0' in 'field list' in /var/www/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php:212\nStack trace:\n#0 /var/www/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php(212): PDOStatement->execute()\n#1 /var/www/src/App/src/Service/DebitCreditClientsService.php(59): Laminas\Db\Adapter\Driver\Pdo\Statement->execute()\n#2 /var/www/src/App/src/Handler/DebitCreditClientsHandler.php(35): App\Service\DebitCreditClientsService->get('2023-01-02:2023...', false, 0, 0)\n#3 /var/www/vendor/laminas/laminas-stratigility/src/Middleware/RequestHandlerMiddleware.php(46): App\Handler\DebitCreditClientsHandler->handle(Object(Laminas\Diactoros\ServerRequest))\n#4 /var/www/vendor/mezzio/mezzio/src/Middleware/LazyLoadingMiddleware.php(26): Laminas\Stratigility\Middleware\RequestHandlerMiddleware-

 function get($period = '', $isIncludingTax = true)
{   
    if ($period == '') {                  
        $period = date("Y-m-d", mktime(0, 0, 0, date("m", strtotime("-11 month")), 1, date("Y", strtotime("-11 month"))))
                  . ':' .
                  date("Y-m-d", mktime(0, 0, 0, date("m"), date("t"), date("Y")));                    
    }

    $sql = new Sql($this->adapter);

    $select = $sql->select($this->_dbPrefix . 'invoices', $this->adapter);

    $select->columns([
        'invoice_type'          => new \Laminas\Db\Sql\Predicate\Expression("'invoices'"),
        'data',
        'invoice_id'            => 'id',
        'invoice_number'        => new \Laminas\Db\Sql\Predicate\Expression('CONCAT(idu_pref, idu)'),
        'id',
        'data_pay',
        'amount_paid',
        'payed',
        'paymentdate',
        'total_count'           => new \Laminas\Db\Sql\Predicate\Expression('COUNT(*)'),
        'total_incoming_amount' => 0,
        'total_invoice_amount'  => new \Laminas\Db\Sql\Predicate\Expression('SUM(calc_total_excl)'),
    ]);

    $result = $sql->prepareStatementForSqlObject($select)->execute();

    $result = [
        [
            "name"        => "Invoices",
            "values"      => $this->getInvoiceData($isIncludingTax, $period),
            "type"        => "invoices",
            "translation" => $this->translateService->translate('Invoices'),
        ],
        [
            "name"        => "Incoming",
            "values"      => $this->getIncomingInvoiceData($isIncludingTax, $period),
            "type"        => "incoming",
            "translation" => $this->translateService->translate('Incoming'),
        ],
        [
            'name'        => 'Contacts',
            'values'      => $this->getContacts($isIncludingTax, $period),
            'type'        => 'contacts',
            'translation' => $this->translateService->translate('Contacts'),
        ],
    ];

    return $result;
}

Ответы (0 шт):