Page 1 of 1

Issue with inserting realtime.txt in mysqlDB

Posted: Thu 25 Jun 2015 2:37 pm
by Raijin
Hi...

I need some help

I am using cron job to insert realtime.txt data into mysql DB

php -q /home/xxxxx/public_html/utils/importCumulusFile.php type=realtime key=xxxx table=RealTime file=../data/realtime.txt

cron job works fine but the LogDateTime field is inserted with 0000-00-00 00:00:00 instead of current time stamp for the first time imsert and then no other records are inserted

Thanks in Advance
Raijin

Re: Issue with inserting realtime.txt in mysqlDB

Posted: Fri 26 Jun 2015 7:06 am
by Raijin
Solved the issue...The issue is with system date format settings...