Custom WD MYSQL

[Chipperdog]

I will PM you server details shortly...

Brian - I checked out 7.3 but it still doesn't work...it now looks like during the first minute it is using the non-custom DB format because it says adding missed data but in the bottom window says can't find 'station_id' field.  In the OUT file the time looks fine and by using just %date% I have an illegal date format in the output but it totally ignores this.  If I used %date-year%-%date-month%-%date-day% the date format is then correct however it still results in the time error.  The message states a blank '' entry but in the OUT file the time looks fine.     The tags appear to be correctly parsed so I don't understand why the INSERT fails.  Am I the only one having these problems?  Thank you for trying...

Connected OK to the table
adding missed data now
Inserted data OK 8:30:31 PM
Inserted data OK 8:31:31 PM
Error , count 0

ERROR: MySQLDataset1: Field 'station_id' not found at time/date 8:30:31 PM 06/20/07
ERROR: [1292] #22007Incorrect time value: '' for column 'time' at row 1:
Client:4.1.14
Server:5.0.41-community-nt at time/date 8:31:31 PM 2007/06/20
ERROR: [1292] #22007Incorrect time value: '' for column 'time' at row 1:
Client:4.1.14

IN: %date% %time% %temp% %hum% %dew% %baro% %avgspd% %maxgstnodp% %dirdeg% %dayrn% %currentrainratehr% %VPsolar% %VPuv% %VPet% %THSW% %heati% %windch%

OUT: 06/20/2007 20:29 73.2 48 52.3 29.951 2.5 25 269 0.73 0.00 11 0.0 0.21 68.7 77.1 73.2

[Weather Display]

hi
if you could PM a screen shot of your custom mysql setup
and your mysql server details, so i can test here

[Chipperdog]

PM sent...

[Weather Display]

ok, i found the mistake i made
use this update:
http://www.weather-display.com/downloadfiles/wdmysql.zip
vers 7.4

[Chipperdog]

Date and Time are being entered now 
The rest of the data is all zeros but not in the customout file.  I see your entry at 15:02 and you can see the one's I've added below.  The startup still gives the missing "station_id" field error and that minute is skipped. 

My mysqlcustomout.txt and clientraw files go to a subdirectory of my main weather folder if that means anything.  This doesn't affect MML or WDL as they work fine.  Just a thought...
custommysqlout.txt: 06/20/2007 23:27 66.1 60 51.8 29.993 1.1 25 299 0.73 0.00 0 0.0 0.22 63.0 66.1 66.1


Connected OK to the table
adding missed data now
Inserted data OK 11:15:31 PM
Inserted data OK 11:16:31 PM

date   time   temperature   humidity   dewpoint   barometer   windspeed   windgust   wind_direction   rain   raint_rate   solar   uv   et   thws   heat_index   wind_chill
6/21/2007   15:02:00   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
6/20/2007   23:16:00   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
6/20/2007   23:17:00   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
6/20/2007   23:18:00   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0

[Weather Display]

one thing to check, dont have any units in your custom tags....untick to include units in the custom web page setup in the web files/web page setup

[Chipperdog]

Brian - it was unchecked already because I use some of these tags in a PHP script on my main weather page.

[kv-swe]

Hi
It seems like wdmysql adds a space at the end of all values and that gives this error:
ERROR: '18.1 ' is not a valid floating point value for field 'thsw' at time/date 15:01:31 2007/06/21


  Krister

[Chipperdog]

Interesting error (18.1) - I've never seen that one before and I don't have spaces in mysqlcustomout.txt.  Brian has access to my DB so I'm sure when he gets time he will continue to help us fix this.

Brian,
Question: What is the data grid at the bottom of the WDmysql window?  Is this a troubleshooting item you used during custom DB development and just didn't remove?

[Weather Display]

Krister was correct
fixed version 7.5:
http://www.weather-display.com/downloadfiles/wdmysql.zip

if you click on load up database grid, you can see the data in that grid at the bottom of the sreen,,,and you can even delete data etc

also, chipperdog, you made a type in your rain rate in the table...you have a t in there,...( i changed the name to match in the wdmysql program)

[kv-swe]

Hi again
It works now  but some of the tags starts with spaces like this:
| 0|...........Max solar expected for the time of day
|  0.0|....................today's rain  , and that gives this error:
ERROR: MySQLDataset1: Field '' not found at time/date 01:24:31 2007/06/22
The program thinks that the space is a new field so following fields move a step.
Is it possible to tell the program to ignore repeated delimiters or maybe use something else as delimiter?

  Krister

[Weather Display]

ok, yes, more than one space ending up the output file will cause the data read in to be shifted...
email me your current output file and i will work on that problem 

[Chipperdog]

Brian - Thanks for the hard work on this one!    Version 7.5 is updating for me and appears to be filling all fields properly.  Krister's findings were a big help.  I was starting to believe I was the only one this wasn't working for considering the thread has over 1000 hits.  It sounds like the final version is close based on the delimiter issue.

Jeff (Chipperdog)

also, chipperdog, you made a type in your rain rate in the table...you have a t in there,...( i changed the name to match in the wdmysql program)

    I can't believe I didn't catch that! 

[weatherc]

Hi Folks!

This is a old thread but my problem is just about wdmysql.
I had setup custom wdsql and my table is ok like the custom.
The problem is, when it update it remove all old data so I have allways only 1 line with data in my table.
If start from scratch and use the table what inbuilt in wdsql all works fine, but I wanted to use the custom due to smaller size of table.
I use wdsql vers 7.7

Henkka

[broadstairs]

Sounds like maybe you have the box checked which says 'Do not append the data'?

Stuart