Fatal error: Uncaught Exception: dataSource is required for Table in C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\widgets\koolphp\Table.php:119 Stack trace: #0 C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\core\Widget.php(157): koolreport\widgets\koolphp\Table->onInit() #1 C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\core\Widget.php(760): koolreport\core\Widget->__construct(Array) #2 C:\xampp\htdocs\kool\koolreport\BMLO\LOReport.view.php(9): koolreport\core\Widget::create(Array) #3 C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\KoolReport.php(584): include('C:\xampp\htdocs...') #4 C:\xampp\htdocs\kool\koolreport\BMLO\index.php(12): koolreport\KoolReport->render() #5 {main} thrown in C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\widgets\koolphp\Table.php on line 119

I'm following this example: https://www.youtube.com/watch?v=ZomIqvpVMo8

I have mysql running and the database on localhost. I can connect via a test php file.

I have the pro version of koolreport and also the dashboard. I downloaded both from my licenses and set up the auth.json. dashboard_4.2.0 koolreport_pro_6.2.0. I haven't unzipped the dashboard yet because I'm not sure where I should unzip it to or if I need it for this "test." I am confused that my composer.json says this: "name": "koolreport/core",

"version":"6.1.0", (I downloaded 6.2 zip so I expected it to say 6.2)

I have gone into my php.ini file and uncommented these 2 lines; extension=fileinfo extension=gd

In the directory I created following the tutorial, I ran composer require koolreport/core and it created the vendor dir as expected.

My dataSource is this:

    return array(
        "dataSources"=>array(
            "automaker"=>array(
                "connectionString"=>"mysql:host=localhost;dbname=automaker",
                "username"=>"root",
                "password"=>"",
                "charset"=>"utf8"

            )
        )
    );

Using MySql Workbench, I'm able to connect and run the query, producing results as expected. I just can't get it to run as it does in the tutorial via the index.php without the above error.

I just ran through all these steps again and tested my db connection using the code above in a php file - it works. The index.php file from the tutorial I just tried is now throwing this error:

Warning: require_once(../vendor/autoload.php): Failed to open stream: No such file or directory in C:\xampp\htdocs\kool\koolreport\BMLO\index.php on line 3

Fatal error: Uncaught Error: Failed opening required '../vendor/autoload.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\kool\koolreport\BMLO\index.php:3 Stack trace: #0 {main} thrown in C:\xampp\htdocs\kool\koolreport\BMLO\index.php on line 3

I think this is a set up/config error but after days of trying, I'm really getting upset and lost I can't get kookreports pro to work. I spent a lot of money on this.

C:\xampp\htdocs\kool\koolreport\BMLO\index.php is where I have the index.php file. C:\xampp\htdocs\kool\koolreport\core\ is the path for the core.

This is my statement: require_once "../vendor/autoload.php"; C:\xampp\htdocs\kool\koolreport\BMLO\vendor\autoload.php

Updated. Now I get this error:

Fatal error: Uncaught Exception: dataSource is required for Table in C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\widgets\koolphp\Table.php:119 Stack trace: #0 C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\core\Widget.php(157): koolreport\widgets\koolphp\Table->onInit() #1 C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\core\Widget.php(760): koolreport\core\Widget->__construct(Array) #2 C:\xampp\htdocs\kool\koolreport\BMLO\LOReport.view.php(9): koolreport\core\Widget::create(Array) #3 C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\KoolReport.php(584): include('C:\xampp\htdocs...') #4 C:\xampp\htdocs\kool\koolreport\BMLO\index.php(8): koolreport\KoolReport->render() #5 {main} thrown in C:\xampp\htdocs\kool\koolreport\BMLO\vendor\koolreport\core\src\widgets\koolphp\Table.php on line 119

Is there a number I can call? This method of "support" is very slow. Right now, I'm at 4 days and I still can't use koolreport.

Let me put down everything again: contents of index.php

require_once "vendor/autoload.php";

require_once "LOReport.php";

$LOReport = new LOReport;
$LOReport->run()->render();

Contents of LOReport.php

<?php


class LOReport extends \koolreport\KoolReport
{
    //Create settings()
    protected function settings()
    {
        return array(
            "dataSources"=>array(
                "automaker"=>array(
                    "connectionString"=>"mysql:host=localhost;dbname=automaker",
                    "username"=>"root",
                    "password"=>"",
                    "charset"=>"utf8"

                )
            )
        );
    }


    //Setup report
    protected function setup()
    {
        //we will get the top ten paying customers
        $this->src("automaker")
        ->query("
            SELECT customers.customerName, sum(payments.amount) as salesamount
            FROM payments
            JOIN customers on customers.customerNumber = payments.customerNumber
            GROUP BY customers.customerName
            LIMIT 10
            ")
            ->pipe($this->dataStore("result"));
        }
    }

Contents of LOReport.view.php ` <htmL>

<head>
    <title> Top 10 </title>
</head>
<body>

<?php

\koolreport\widgets\koolphp\Table::create(array(

    "datasource"=>$this->dataStore("result")
));

?> </body> </html>

That worked!

Now I can start working on the pro tutorials to learn this stuff. Any advice?

I was trying out a different sample and I have an error: on that one I found a post that says "Please add package Inputs to KoolReport" - given I'm so new, can you help me understand what that means and what I need to do?

Is it not possible to run the tutorial without Composer installed?

Following your last instructions for installing Composer/KoolReport Pro: In the "Install Commercial Packages with Composer" popup window in Step 1 "Create file auth.json next to your composer.json with following content". However, the KoolReport Pro 6.2.0 download contains almost 50 versions of composer.json in different directories. Which one should be used?

I figured out the issue. None of the potential solutions you had suggested worked.

The issue was much simplier: the folder structure. When I unzipped the pro package, the "examples" folder was unzipped inside the koolreport folder. Once I moved it to examples folder to be adjacent to the kookreport folder, everything started working. as expected. I'm not sure how I moved the examples folder into the koolreport folder but that was my issue and solution.

Thanks for your help.