Hi all,
I had a blog that I backed up in JSON format and I also had create a small command line application to generate all the blog posts into a custom database I had installed locally on my Windows machine. It had all imported successfully with no errors.
Building the same application on Linux (elementary OS to be more specific), and I end up with the following error:
'Date') Incorrect datetime value: 'Date' for column 'dateposted' at row 1
The code used to generate the date value is as follows:
var date = Date.fromString(post.updated_at);
news.dateposted = date;
news.dateposted is a type SDateTime but when I use the insert function on the SPOD object, the error as above occurs.
However, adding the following trace call as below:
var date = Date.fromString(post.updated_at);
trace(date);
news.dateposted = date;
Works, as if for some reason in C++ context, the date is not valid until it’s value is used at runtime in that specific circumstance. I’m wondering if there may be a bug in hxcpp or if it’s a bug in Haxe. I shouldn’t have to trace the date value in order that the SPOD macro successfully inserts Mysql records, that seems very unusual.