Database Connectivityea

Hello,

First, congratulations on your product which seems brilliant in charting data.

However I am only able to chart data based on inputted values and I am not able to use it with the options

• Chart Data Existing Database
• Chart Data Other Database

The symptoms are different

With "Chart Data Existing Database"

the system correctly identifies the tables in the current database.
However after specifying my own SQL query and before previewing the graph, when I attempt to save the chart

I get error messages:
Invalid field: Driver name:
Invalid field: Hostname:
Invalid field: User name:
Invalid field: Password:
Invalid field: Database Name:

I believe I should not receive these messages since all relevant data is read from configuration.php

I am not able to complete that particular chart.

With "Chart Data Other Database"

The system attempts to log in, starts to load the select box with the available tables and stays in the state indefinitely.

I am not able to pursue that particular chart.

While you component appears to be everything I need it fails miserably in some functions with should be absolutely easy to implement.

I also see a lack of documentation. I see a lot of examples of different charts but all for inputted data.

You should also provide a couple of examples of charts using the local database.

I will be expecting some help from you regarding these two issues

Thank you in advance

Hello Ricardo,

Thanks for appreciation. We are looking into the issues you pointed out, Will update you very soon on this.

Hello Ricardo,

We have corrected the issue , please download the latest version of vchart package from your order section.

We hope this response has sufficiently answered your questions. If not, please reply and we will answer your questions / querie s asap.

thanks
zaheer

Hi, Zaheer

Thank you very much for your fast reply.

I have installed the new version of the component and realized that the changes you have made greatly improve on the backed usability. Creating the charts is now much easier and a lot more intuitive.

Regarding the issues I raised

Chart Data Existing Database

Still not able to save a chart with local data, it still asks me for fields I feel I should not need to fill

Invalid field: Hostname:
Invalid field: User name:
Invalid field: Password:
Invalid field: Database Name:

HOWEVER

Chart Data Other Database

This one is now working perfectly and I am able through it to connect to local database as well.

So as far as my requirements go, i am now satisfied that your component and module (which to be fair I have not tested yet) attend my needs.

Thanks you very much.

PS: Just a very very small note to let you now that the component preview <DIV> is not centered and it is placed on the bottom right hand corner. That is, i believe, a minor bug. But i think that the beauty of your package totally requires it to be fixed.


Thank you very much for you help. I will rate you 5* in Joomla Extensions

Hello Zaheer

A different problem is the fact that I am not able to display the graph using the component view (attached to a menu item):

PHP Fatal error: Cannot use object of type stdClass as array in C:\wamp\www\hive\components\com_vchart\views\vchart\view.html.php on line 53
PHP Stack trace:
PHP 1. {main}() C:\wamp\www\hive\index.php:0
PHP 2. JApplicationCms->execute() C:\wamp\www\hive\index.php:40
PHP 3. JApplicationSite->doExecute() C:\wamp\www\hive\libraries\cms\application\cms.php:245
PHP 4. JApplicationSite->dispatch() C:\wamp\www\hive\libraries\cms\application\site.php:224
PHP 5. JComponentHelper::renderComponent() C:\wamp\www\hive\libraries\cms\application\site.php:178
PHP 6. JComponentHelper::executeComponent() C:\wamp\www\hive\libraries\cms\component\helper.php:332
PHP 7. require_once() C:\wamp\www\hive\libraries\cms\component\helper.php:352
PHP 8. JControllerLegacy->execute() C:\wamp\www\hive\components\com_vchart\vchart.php:36
PHP 9. VchartController->display() C:\wamp\www\hive\libraries\legacy\controller\legacy.php:722
PHP 10. JControllerLegacy->display() C:\wamp\www\hive\components\com_vchart\controller.php:32
PHP 11. VchartViewVchart->display() C:\wamp\www\hive\libraries\legacy\controller\legacy.php:685

Everyting is OK displaying the module in a template position, though i have not been able to use {loadposition} and {loadmodule} in articles

Hi,

The issue you mentioned has been corrected in the latest package, Please download it again after logging into your account on WDMtech.
Now you can create a Menu for Chart Layout.
You can use {vchartmodule [Chart ID]} keyword to load the Chart in Article Text e.g. {vchartmodule 1} for Chart ID 1.