On Monday, 6 March 2017 16:11:02 UTC+10, Hartmut Schweidler wrote:
> YES I would like to insert values like maxSolarRad, windrun and other > into the old database "weewx" > Good, we both have a common understanding of what you are trying to do. 1. I have 89 fields in my database > Ok, 89 fields, that is impressive. I understand your schema is defined in schemas.py but there is a difference between having the schema defined in schemas.py and actually having the fields included in your archive table. WeeWX uses schemas.py when first creating your archive table and then it is largely ignored. So if you created your database/archive table and then changed schemas.py your changes will not necessarily be refected in your archive table. There is an easy way to check, you appear to be using mySQL so lets get into MySQL and have a look at the archive table schema that is in use and see what is there. Use the following commands to first get into the mySQL client and then look at the archive table schema (assumes your mySQL user is root and your database is archive_mysql, change as required to suit your setup): $ mysql -u root -p mysql> USE archive_mysql mysql> DESC archive; Post the output from DESC archive;. Does it show maxSolarRad, cloudbase and windrun? If so that is fine, if not then you need to follow the steps I outlined in my first post to add these fields to your archive table. Gary
