IMPORTANT! The server may go down soon - possibly permanently. Please read the latest post in Announcements and News

FTP is broken. I advise all users using my server for their web site to make alternative arrangements.

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 5 guests