Dhtmlxgantt connector render issue

[inel_ananth]

I am using a dhtmlxgantt connector to render.While page loading i got only the value instead of gand data render on browser.pls see the error

can anyone help me?

[ramil]

Hello,
There are many reasons why it might happen.
First, you need to check that you set the Data Processor transaction mode correctly. Then you need to check the server URL. For example:

gantt.load("http://192.168.1.55/data");
 
var dp = new gantt.dataProcessor("http://192.168.1.55/data");
dp.init(gantt);
dp.setTransactionMode("POST");

If these settings are correct, it might be related to the configuration, and it is hard to suggest what might be the cause. Please, send me your full package with all necessary Javascript files (or any other package where I can reproduce it). I will check what might be wrong.

[inel_ananth]

Thanks for your reply.
I tried as you suggested.Same output i got it…I am using the following code for development.I can get the data in the browser but not rendering in the given div element

========Render issue - Browser(Google Chrome) Start================

========Render issue - Browser(Google Chrome) Start================

========PHP Code Start================

========PHP Code Stop================

========Template Code Start================

========Template Code Stop================

Pls see the above development code and give your valuable solution.

[ramil]

Hello,
Unfortunately, I couldn’t reproduce the issue by using the connector. Here is a demo that you can run via Apache:
https://files.dhtmlx.com/30d/842148a77c91404c7c9c98e8e780e260/connector_demo.zip
You need to specify the database parameters in the data.php file. And apply the following code to generate the tables:

CREATE TABLE `gantt_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` int(11) NOT NULL,
  `target` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  PRIMARY KEY (`id`)
);
 
CREATE TABLE `gantt_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `duration` int(11) NOT NULL DEFAULT 0,
  `progress` float NOT NULL DEFAULT 0,
  `sortorder` int(11) NOT NULL DEFAULT 0,
  `parent` int(11) NOT NULL,
  PRIMARY KEY (`id`)
);

I suppose the issue might be related to the wrong URL. I was able to reproduce the issue with Ruby on Rails project. I can get the JSON output if I enter the following URL:

http://0.0.0.0:3000/api/data

Screenshot

But if I specify the URL correctly, I see the tasks:

Screenshot

If that doesn’t help you, please, send me your whole project or any project where I can reproduce the issue locally.

[inel_ananth]

The suggested code is working fine while using of PHP with mysql.But in my case i am using php,smarty and postgresql.

1. I can fetch data from postgresql (see the below screenshot)
   
   

2.the path for rendering the data also specified correctly.

But the fetched data not render in the gannt chart.

Note : Is it possible to take it remotely to see the exact problem?

[ramil]

Hello,
Usually, we don’t do screen sharing sessions and our tech support is limited to the email support only.

I didn’t test how it works with PostgreSQL database. I will investigate it, but I don’t specialize in PostgreSQL, so I cannot tell you how long it will take.