Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Issue with inserting realtime.txt in mysqlDB

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
Raijin
Posts: 8
Joined: Fri May 09, 2014 6:39 am
Weather Station: Davis VP2 6152
Operating System: Windows 7
Location: Thaiyur,Chennai

Issue with inserting realtime.txt in mysqlDB

Postby Raijin » Thu Jun 25, 2015 2:37 pm

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

Raijin
Posts: 8
Joined: Fri May 09, 2014 6:39 am
Weather Station: Davis VP2 6152
Operating System: Windows 7
Location: Thaiyur,Chennai

Re: Issue with inserting realtime.txt in mysqlDB

Postby Raijin » Fri Jun 26, 2015 7:06 am

Solved the issue...The issue is with system date format settings...


Return to “3rd Party Tools”

Who is online

Users browsing this forum: No registered users and 3 guests