2. PHPRunner Tips and Tricks
  3. [SOLVED] trouble using CHART PLUGIN from xlinesoft
This topic is locked
[SOLVED]

trouble using CHART PLUGIN from xlinesoft

 		6/19/2024 6:23:31 AM
PHPRunner Tips and Tricks
author

Hi all,

I am having some trouble using the chart plugin from xlinesoft. i copied the plugin to view folder and able to select the plugin. I altered the initiating script for the plugin as below:

// SQL query both are INT value althought I believe floats should work //
$this->settings["sql"] = "SELECT floor(`min`) as mini,`ID` FROM `epf`";
$this->settings["xAxis"] = "ID";
$this->settings["yAxis"] = "mini";
$this->settings["type"] = "column";
$this->settings["title"] = "Number of Incidents";

but I always get this error message:

Fatal error: Declaration of ViewChart::showDBValue(&$data, $keylink) must be compatible with ViewControl::showDBValue(&$data, $keylink, $html = true) in /www/wwwroot/xxxx on line 16

Anyone have experience using this plugin can help?
256412 6/19/2024

// SQL query both are INT value althought I believe floats should work //

$this->settings["sql"] = "SELECT floor(min) as mini, ID FROM epf";

repost the corrucpted message above
Sergey Kornilov admin 6/20/2024

As first step, make sure that your SQL query works and returns data.

As a second step - try a different SQL query without aliases.

256412 6/24/2024

thanks for replying

  1. tested sql query working fine.
  2. removed alias
  3. using only int data for both axis

but same error message can cannot work.

Regards,
Gary
img alt

img alt

img alt

img alt

Sergey Kornilov admin 6/24/2024

Thank you for the update.

Just in case make sure you have the latest version of the plugin. I suggest downloading an updated version of the plugin from the marketplace just in case.

If the issue is still there, upload your project to Demo Account and contact support directly.
256412 6/25/2024

Hi Sergey,

I think I found the problem with this plugin. My server runs on Mysql 8.0, if I change the version to 7.4, it will work.

https://demo.asprunner.net/codecradle_outlook_com/test_chartplugin

I have uploaded the test project here. You can take a look if you are going to update it to work with mysql 8.0.
This post can consider closed.

Regards,
Gary
Sergey Kornilov admin 6/25/2024

It was updated already to support PHP 8.