KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Uncaught Error: Call to undefined method CI_DB_mysqli_result::unbuffered_row() #800

Open Kasun Wijayamanna opened this topic on on Apr 12, 2019 - 1 comments

Kasun Wijayamanna commented on Apr 12, 2019

Hi team, I have created one codeIgniter project. Here,i used use \koolreport\codeigniter\Friendship; method to connect database.

But, i have got error when getting data from database like,

 Uncaught Error: Call to undefined method CI_DB_mysqli_result::unbuffered_row() in C:\xampp\htdocs\myproj\application\libraries\koolreport\packages\codeigniter\CIDataSource.php:105

My source file is

<?php

require APPPATH."/libraries/koolreport/autoload.php";

class MyReport extends \koolreport\KoolReport
{
   use \koolreport\codeigniter\Friendship;
    use \koolreport\clients\Bootstrap;

    function settings()
    {
      return array(
            "assets"=>array(
                "path"=>"../../assets",
                "url"=>"assets",
            ),
           // "dataSources"=>array(
           //      "alljobs"=>array(
           //          "connectionString"=>"mysql:host=localhost;dbname=dbname",
           //          "username"=>"root",
           //          "password"=>"",
           //          "charset"=>"utf8"
           //      ),
           //  )
        );
        
    }
   protected function setup()
    {
        $this->src("default")
        ->query("select * from nrm_business")
        ->pipe($this->dataStore("jobs_list"));
    }
}

Need some solution. Appreciated.

KoolReport commented on Apr 12, 2019

There are two solutions:

  1. You may define your own datasource (again) in the settings() function
  2. Change CodeIgniter to use PDO instead of mysqli

Actually we have not known why the unbuffered_row() does not work as it is clearly shown in the codeigniter documentation.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None