I’m trying to get the MySQL option within WD Version: 10.37Q-(b75) running but without luck thus far.
Connection to database and table are OK.
Selecting only stationid, date, time and temperature still results in all possible field options to be taken up in the mysqltable.
Although I could delete the columns in the database table, I have not been able to identify the file which contains the sql command, allowing me to amend the necessary INSERT command.
Moreover, the only response I’m getting is:
“You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) VALUES (‘MeteoMontauroux’,‘2011-9-15’,‘12:28:00’,26.8,)’ at line 1”
Since the table was generated by WD, I have no control over the syntax. Anyone having an idea how to tackle this?
Rgds
Dick
make sure to use the latest version of wdmysql
to fix the problem with your long station name
http://www.weather-display.com/downloadfiles/wdmysql.zip
(its included in the latest update of WD too)
Hi Brian,
thanks for attending to the issue. However, no luck thus far for which the following applies.
Running WD Version: 10.37Q-(b78), WDMYSQL vers. 10.1 on a Windows Server 2003, Enterprise edition.
Assumed that using “Setup Custom”, a database/table had to be defined separately upfront, i.e. the “Create Table” button in WDMYSQL 10.1 is solely for the purpose of the predefined table.
The following applies: table consists of %station_id%-station_id (Varchar2), %date%-date(Date), %time%-time(Time) and %temperature%-temperature(float).
This data was replicated using the “Setup Custom” with “enabled” ticked and button “ON”. The resultent registry entry is as per mysqlcustom2.bmp.
‘Connect to database now’ results in ‘Login-,Database- and table OK’ - ‘SAVE’ - ‘Start Logging’ stalls ‘Data Received’ update on WD main screen. Mem Usage of WDMYSQL = 2.468K, no data received after five minutes trial in db, ‘TEST’ results in:
“You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) VALUES (‘Montauroux’,‘2011-9-16’,‘14:07:00’,24.9,)’ at line 1”.
No custommysqlout.txt and custommysqlin.txt files could be located.
‘Data Received’ update on WD main screen continues after stopping ‘WDMYSQL’ process.
Hope this info is of use for further analysis,
Rgds
Dick
Apologies, VARCHAR(2) should read VARCHAR(20)
looks like the problem is the , at the end
try a new update
http://www.weather-display.com/downloadfiles/wdmysql.zip
Brian,
thanks for standing by. However, no luck, i.e. no data in the custom database. Even if I replicate the custom database using the create table function, thereby only selecting stationid, date, time and temperature, it generates a table with ALL fields predefined in the Create Table window. I have given up and running a external cron job instead. Many thanks for your support thus far.
Rgds
Dick
please do no give up
as I need to figure out what the problem is in case someone else has this problem
what is the latest error showing now?
i.e was that end comma removed now?
(it might still be there)
Brian,
The following observations are made with the updated WDMYSQL.exe made available in yr. posting of 16th Sept. Pls. note that the version nr. still reads 10.1
Before any testing, I have cleaned all custom fields and put the swith on OFF.
The resultant reg.entries of MySQL and MySql Custom read as per attachment. If the “latest data” in MySQL is supposed to reflect the clientraw.txt content, I have my doubts whether this is correct, i.e. I miss a date format after location name if I’m not mistaken.
quote:"
12345 0.0 0.0 115 23.7 72 1014.9 0.0 2.6 430.0 0.000 0.000 23.4 44 0.0 19 0.0 0 0 0.0 -100.0 255.0 -100.0 -100.0 -100.0 -100.0 -100 -100 -100 12 02 58 MeteoMontauroux 0 29 17 9 100 100 100 100 100 100 100 23.7 29.9 23.8 16.1 19 Mostly_Cloudy/Dry -0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 18.3 2203.3 17 30.5 20.0 23.8 16.1 1.6 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 22.5 23.3 23.8 23.4 23.2 23.1 23.3 23.5 23.7 23.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 23.8 16.1 23.7 0.0 0 22:19:25 2011/06/14 115 0 0 -100.0 -100.0 16 0 0 0 0 257.0 23.4 23.4 30.3 1015.9 1014.6 0 12:00 14:43 33.7 17.4 19.2 14.8 0 2011 -17.8 1 -1 1 174 122 130 132 132 132 132 132 115 115 0.0 255.0 0.0 20.3 43.61917 -6.78333 0.0 93 71 0.0 06:34 - - - - - - !!C10.37Q!!
"unquote
After a complete restart of WD, OPEN mySql, leave switch “OFF”, “run the wdmysql.exe program now”. Setup Custom for the following fields with swich ON: %station_id%-station_id (Varchar20), %date%-date(Date), %time%-time(Time) and %temperature%-temperature(float).
SAVE - CONNECT TO DATABASE - Login, database, Table OK - Every Minute - Start Logging - Mem Usage wdmysql.exe 6.568K dropped to 3.156K. Waited 10 minutes, NO DATA in database. Pushing TEST, resulted in:
quote "
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘%station_id%,‘2011-09-18’,‘21:50:00’)’ at line 1
"unquote
Switched off the Custom database and “CREATE DATABASE”, Connect to Database, Create Table resulting in Table Created OK, Table Opened OK. Reviewing database in GRID reveals that all possible parameters, even those NOT selected have been defined in database. The station_id field is still VARCHAR(10) instead of (20). Changed to (20), SAVED and started 1 minuted interval. After 10mins waiting - NO DATA in database.
Pushing TEST, resulted in:
quote "
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘%station_id%,‘2011-09-18’,‘22:03:00’)’ at line 1
"unquote
%stationname%
not
%station-id%