KoolReport's Forum

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

RawSQL Bug on Dashboard v 3.3.1 #2553

Open Andre Van Der Walt opened this topic on on Jan 31, 2022 - 12 comments

Andre Van Der Walt commented on Jan 31, 2022

Good day

I get the following error after upgrading to version 3.3.1 of the dashboard package when using rawSQL: "query error >> [table 'database.__raw__' doesn't exist]"

KoolReport commented on Feb 7, 2022

May I see your raw query, please post me the whole class file containing the query

Andre Van Der Walt commented on Feb 7, 2022
<?php

namespace Name/Space;

use \koolreport\dashboard\fields\Text;
use AutoMaker;
use koolreport\dashboard\widgets\Table;

class BugExample extends Table
{
    protected function dataSource()
    {
        return AutoMaker::rawSQL("SELECT
                                      ColumnName
                                    FROM
                                      db.table");
    }

    protected function fields()
    {
        return [
            Text::create("ColumnName"),
        ];
    }
}
Andre Van Der Walt commented on Feb 9, 2022

Any feedback here?

KoolReport commented on Feb 9, 2022

I have sent to dev.team to inspect, I will keep you update.

Luis Brillas commented on Feb 18, 2022

any update or workaround?

KoolReport commented on Feb 18, 2022

@Andre @Luis: Our dev.team has spotted the issue and have fixed it. The fix will be available in next release within this month.

Luis Brillas commented on Feb 19, 2022

Ookey, great!!. Thanks!!

Andre Van Der Walt commented on Apr 20, 2022

It seems this is not yet resolved. When can we expect a resolution?

KoolReport commented on Apr 22, 2022

Really sorry for the late reply. You will see the new update today.

Andre Van Der Walt commented on Apr 22, 2022

Excellent, thank you.

Luis Brillas commented on Apr 22, 2022

Great!!. Thaks!! :)

KoolReport commented on Apr 22, 2022

We've just release Dashboard 3.5.0 with KoolReport Pro 5.10.0, you may update now. Please let us know if any issue.

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
bug
solved

Dashboard