Type: Error

Message: Call to a member function execute() on boolean

Filename: /app/vendor/koolreport/core/src/datasources/MySQLDataSource.php

Line Number: 384

Tracing through the code I see this is the source of the problem: $stmt = $this->prepareAndBind($query, $searchParams); << $stmt is false and this is why $stmt->execute() is failing $stmt->execute();

The problem is this second line $stmt = $this->prepareAndBind($query, $searchParams);
$stmt->execute(); //line 384

$searchParams[] is empty. $stmt is false because that is being returned by prepareAndBind(). I think it should be a structure. Is this a known bug?

$stmt = $this->connection->prepare($query);

Here is the value of query that is causing prepare() to fail.

    SELECT e.employee, e.employee_title, e.w2_wages as wages,  t.risk, 
         CASE 
             WHEN risk='low' THEN  e.w2_wages
             WHEN risk='medium' THEN  e.w2_wages*.5
             ELSE 0
          END as QREs 
    FROM employees as e, titles as t
    WHERE e.email='richb201@gmail.com' AND e.campaign= 'Apple'  
    AND t.email='richb201@gmail.com' AND t.campaign= 'Apple' 
    AND e.employee_title=t.title
    ORDER BY e.employee
    

Is it possible that the query is just too long? I think that this query was working a day or two ago. Please advise?

Ok. I'll give it a try. The actual buffer above came out of the debugger. The SQL seems good. Btw, another module that uses Koolr also gives the same error. That one had not been modified. This is the reason I think this may be not an application error but a system issue. That SQL statement was working fine.

How should I 'create a mysqli yourself'? My application creates $this->db and uses it. But $this in the MyReport is different from the $this I use in my application.

I have three "reports"; MyDashboard, MyReport, and My ExportExcel. Each has its own settings() and setup(). MyDashboard (which runs at startup) seems to work fine still.

David, can you tell me where in koolreport_pro-4.7.1 I can find an example of a simple koolreport table report that you know works? I'd like to trade out my MyReport and replace it with your example.This will prove whether it is an application problem or something deeper.

Solved. Somehow my connection string was set to go to a different database than I use. I have no idea how this happened since I don't have such database name.

One more quick question. I have two piecharts that are generated by

PieChart::create(array(
    "title"=>"Number of employees",
    "dataSource"=>$this->dataStore("titles_pie"),
    "columns"=>array("title","employee_count")
)
);
PieChart::create(array(
        "title"=>"Number of employees",
        "dataSource"=>$this->dataStore("titles_pie"),
        "columns"=>array("title","employee_count")
)
);

Can I get these two to appear side by side?