KoolReport's Forum

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

KoolReports on Linux #2655

Open Mark Zonavetch opened this topic on on Apr 29, 2022 - 3 comments

Mark Zonavetch commented on Apr 29, 2022

We have a report created with a connection to a MySQL database using the visualquery tool.

When we run it on windows XAMPP with PHP 5.6 or 7+ it works correctly.

When we run it on Linux PHP 5.6 or 7+ it fails. No PHP errors exist. The only JS error is: ReferenceError: KoolReport is not defined

On windows, when viewing the page source the page begins with multiple JS includes, css, etc, and renders correctly.

On linux, the page renders only large print $this->dataStore('vqDS') and the html table, but no data, does not render correctly ,and give the JS error that KoolReport is not defined.

The page starts with this on our linux servers, which is not on the page when it is loaded / rendered on Windows and works corretly. <!-- Latest compiled and minified CSS --> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

I've not found any documentation on the module requirements for PHP for koolreports to work correctly. What modules/includes are required? Also, do any of the directories need to be writeable? I've set the entire koolreports directory to 755 with no change. For install we have koolreports directory under /var/www/html/assets/koolreports Report is under /var/www/html/reports/plc_vq in our setup, we have included autoload as: require_once(__DIR__."/../../assets/koolreport/core/autoload.php");
KoolReport commented on May 1, 2022

Would you mind to send us the url of your online report. You may send to our email support@koolreport.com

Sebastian Morales commented on May 2, 2022

On Linux, pls make sure your report view's file name must match the class name case sensitively. Otherwise KoolReport can not find the view file (since Linux file and directory names are case sensitive) so it dumps a report's all datastores instead of rendering the view file. Rgds,

Mark Zonavetch commented on May 2, 2022

Thank you. Case sensitivity was the 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
help needed
solved

VisualQuery