New install - Errors

[mhunter]

Well, I've just completed a new install and am still having a couple of problems, hope someone can help me. I've turned on the debugging and found the following errors:

6/20/2003 11:43:53 PM mcsTemperature Plugin GetWeather: Item cannot be found in the collection corresponding to the requested name or ordinal.

I've tried all kinds of options for location, like city, accid code, with no luck.

And the other error I've been receiving is:
6/20/2003 11:42:53 PM mcsTemperature Plugin Debug Change Field because Syntax error in INSERT INTO statement., error number=-2147217900, Fields=Temp05,4,UpstairsHall,4,OutsidePhone,4,Basement,4,HVA C-Out,4,Garage,4,T05Ext,4,Attic,4,Office,4

6/20/2003 11:42:53 PM mcsTemperature Plugin Debug Log Temperature Sensor Count=9, INSERT INTO Temperature(SampleDate,Temp05,UpstairsHall,OutsidePhone,Base ment,HVAC-Out,Garage,T05Ext,Attic,Office) SELECT #2003-06-20 11:42:53 PM# AS QT,7597 AS Q0,7340 AS Q1,5561 AS Q2,6967 AS Q3,7316 AS Q4,7170 AS Q5,7552 AS Q6,6170 AS Q7,7835 AS Q8

Any help would be appreciated.
Thanks
Mike

[Michael McSharry]

Special characters are not allowed in field names. I saw a hyphen in there.

Dont know about the collection reference. No collection is explicitly used there, but database fields may apply to this category.

You welcome to email the two ini file and database so I can replicate the problem.