| View previous topic :: View next topic |
| Author |
Message |
mhweather
Joined: 07 Aug 2005
Posts: 54
|
 Posted: Tue Sep 19, 2006 5:56 am Post subject: MySQL database import failing |
 |
|
I'm trying to turn on the MySQL function of Wview, and the initial database creation of all my existing WLK files is failing.
databaseinsertRecord: TableInsertRow failed.
raddatabaseTableQuery: mysql_query(); error 1054; unknown column 'nan' in field list.
From what I can see, its bombing out on these LOS (loss of signal) records where you have no valid data from the outside sensors. I tried to fix some of the records manually and the database import gets further along until the next LOS record. I know that some data validation is done for records, what can I do to manually edit these LOS records to get the MySQL import to work ? The LOS records do contain valid barometric and indoor data so I'd rather not just delete them. |
|
| Back to top |
|
 |
mhweather
Joined: 07 Aug 2005
Posts: 54
|
| Posted: Sun Sep 24, 2006 6:18 pm Post subject: |
|
|
| Just a followup, I manually edited the outdoor humidity field with WeatherLink and put a number in there (just repeating the last good value) and the record is accepted in the MySQL database. Anyone have an idea where in the code this check might be so I could do the bypass there and not have to examine 5yrs of database records ? |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
