I got this error with the Old ImportCumulusData.php which had the wrong named in the table (DePint instead of DewPoint).nitrx wrote:Hmm confusing I get a ERROR - Bad Select Statement (1) error I use the old databse from David (the first one) http://apeldoorn.tk/weer/top10.php
As Mark says either use the latest script, or amemd your script to fix the error, drop the table and re-import it.
Alos check you table is called the same as Marks' in the SELECT statement. Mine was called DayData not daydata and MySQL databases are case sensitive.