Page 2 of 2

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Wed 06 May 2020 2:34 pm
by laulau
Hi,
In my realtime table the last clumn is "RG11rain" :o
Don't remember why :oops:

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Wed 06 May 2020 3:37 pm
by water01
You have not run the SQL on your database tables that Mark attached at the bottom of the 3076 release viewtopic.php?p=142085#p142085

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Wed 06 May 2020 4:18 pm
by mcrossley
The Realtime table does not contain RG11rain - that is in the Monthly table?

If that is your last column, then it looks like you have missed a previous SQL update. Compare your tables against the schema listed in the Wiki for the ImportCumulusFile utility and add the missing columns to all your tables.

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 7:33 am
by sfws
mcrossley wrote: Wed 06 May 2020 9:10 am Fixed my post now too.
water01 wrote: Wed 06 May 2020 8:58 am Thanks Mark. I had to modify your function as there were some errors (I am sure you do this to see if we can fix coding errors!!).
Unless it is my imagination, the number of opening and closing brackets does not match in one line of that function.
I was about to say in which line, but I won't as it seems the trend is being a bit vague.

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 10:47 am
by laulau
I'm running MX v3.6.0 but i dont't have 'feels like ' in realtime.txt ? :o
It's ok in dayfile and monthlog .
Strange isn't it ?

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 11:38 am
by water01
There is nothing in the release notes to say there were any changes to realtime.txt so I don't think it's strange.

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 11:54 am
by laulau
But in https://cumuluswiki.org/a/ImportCumulusFile feelslike was added in the realtime table :roll:

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 12:07 pm
by water01
And it is updated if you use the reatime MySQL feature in CumulusMX. I have data in the field as I have just checked. has done since May 4th late when I implemented build 3076

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 12:29 pm
by sfws
In MX, realtime.txt is not used. The realtime optional database table has no connection with logfile content, but both are updated at same interval.

Note, I am posting from my mobile as I have an electrician updating my power circuit today so I have not looked up anything for this reply

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 1:08 pm
by laulau
I'm not sure i can use the MX SQL internal facilities as my db isn't hosted locally.
My db is on OVH which host my website.

Re: Feels Like (in 3.6.0) and Humidex (not implemented)

Posted: Thu 07 May 2020 2:41 pm
by sfws
laulau wrote: Thu 07 May 2020 1:08 pm I'm not sure i can use the MX SQL internal facilities as my db isn't hosted locally.
My db is on OVH which host my website.
I am sure that the majority of MX users do not have a local db. So MX is designed for updating remote databases.