New task don't get written to database

Gantt
#1

I have followed the how to start guide. I can read data from the database and I can update it(only if I created the task in database myself). Only problem is when I create a new task it doesn’t get added to the database. I’ve been trying to figure this out for days now any ideas ? I’m suspecting it’s something to do with date.

Using MySQL 5.7.14, Apache 2.4.23, PHP 5.6.25

myGannt.html

[code]!DOCTYPE html>

How to Start with dhtmlxGantt html, body{ margin:0px; padding:0px; height:100%; overflow:hidden; }
[/code]

data.php

[code]<?php

include (‘codebase/connector/gantt_connector.php’);

$res=mysql_connect(“localhost”,“root”,“root”);
mysql_select_db(“gantt”);

$gantt = new JSONGanttConnector($res);
$gantt->render_links(“gantt_links”,“id”,“source,target,type”);
$gantt->render_table(
“gantt_tasks”,
“id”,
“start_date,duration,text,progress,sortorder,parent”
);
?>
[/code]

#2

Hello,
please try enabling logging as shown here:
docs.dhtmlx.com/connector__php_ … idelogging
Then you’ll be able to see the error message in generated file.
As for the possible cause of the error - please check your table schema and make sure ‘id’ have auto increment value.

#3

I can confirm this happening when using a db other than MySQL. I am using Oracle.

I changed the column type of start_date to varchar and task creations now insert into the tasks table.