I am having a proplem when my system calls weather.php
I am getting the follow database error:
Database error in vBulletin 2.2.6:
Invalid SQL:
INSERT INTO weather_userdata
(userid,time,city,subdiv,country,region,temp,cicon ,wind_spd,wind_dir,barometer,h umidity,realfeel,uv,vis,lastup,context,forecastday 1,forecastday2,forecastday3,fo recastday4,forecastday5,forecasticon1,forecasticon 2,forecasticon3,forecasticon4, forecasticon5,forecasttype1,forecasttype2,forecast type3,forecasttype4,forecastty pe5,forecasthigh1,forecasthigh2,forecasthigh3,fore casthigh4,forecasthigh5,foreca stlow1,forecastlow2,forecastlow3,forecastlow4,fore castlow5)
VALUES
('1','1029394185','','','','','0°F','','0 mph','','0 inHg','','0°F','','0 mi','','','Saturday','Saturday','Saturday','Saturd ay','Saturday','','','','','', 'Unknown Type','Unknown Type','Unknown Type','Unknown Type','Unknown Type','0°F','0°F','0°F','0°F','0&d eg;F','0°F','0°F','0&d eg;F','0°F','0°F')
mysql error: Unknown column 'forecasticon1' in 'field list'
mysql error number: 1054
As you can see, weather.php is calling for colums that don't exist. The sql file for this does not create these colums in the table either. Is this a bug, or have I done something wrong. Also, where are people putting the $weather insert? I don't understand how this works as there isn't a template called weather, just weather_main.
|