Hi,
Having an issue with Scheduler Calling/Passing data from a MYSQL ‘TIMESTAMP’ field.
I have set the Database field as ‘Timestamp’ with a DEFAULT as ‘CURRENT_TIMESTAMP’ , then pass this into the ToolTip. (Defined ‘timeSTAMP’ in connector.php)
Issue is when I generate a event via the Scheduler the ‘TIMESTAMP’ generates 0000-00-00 00:00:00
but when event generate from within PHPMyAdmin timestamp generating correctly and being passed through too the tooltip.
From reading online I believe MYSQL generates 0000-00-00 00:00:00 when invalid datatype assigned.
So from this method is Scheduler attempting to insert data into the ‘timestamp’ field? Even though I am only wanting to pull it and let SQL generate it.
Cheers for any help.
CODE OF TOOL TIP:
<script src="codebase/ext/dhtmlxscheduler_tooltip.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript" charset="utf-8">
// template to display as tooltip
scheduler.templates.tooltip_date_format=scheduler.date.date_to_str("%Y-%m-%d %H:%i");
scheduler.templates.tooltip_text = function(start,end,event) {
return "<b>Event:</b> "+event.text+"<br/><b>Last Modified:</b>"+event.timeSTAMP+"<br><b>Start date:</b> "+scheduler.templates.tooltip_date_format(start)+"<br/><b>End date:</b> "+scheduler.templates.tooltip_date_format(end);
};
