No announcement yet.

Data Base too Small Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Data Base too Small Error

    <TABLE border=0 cellSpacing=2 cellPadding=0 width="100%"><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>5/16/2013 11:49:15 AM </TD><TD class=LOGType0 colSpan=3 align=left>runAccessActionQuery </TD><TD class=LOGEntry0 colSpan=8 align=left>INSERT INTO Forecast ([Time], v_Temp, v_CIcon, vWindS, vWindD, vBarometer, vHumidity, v_Real, vVisibility, v_LastUp, v_Forecast, F1Max, F2Max, F3Max, F4Max, F5Max, F1Min, F2Min, F3Min, F4Min, F5Min) VALUES (Now(),8100,'partlycloudy.gif',0,'NNW',2989,4600,8100,1000,# 5/16/2013 11:48:59 AM#,'5|6|7|1|2||||||partlycloudy.gif|partlycloudy.gif|chance tstorms.gif|partlycloudy.gif|mostlycloudy.gif|',8200,8200,79 00,7300,8200,5000,5000,5500,5500,6300) </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>5/16/2013 11:49:15 AM </TD><TD class=LOGType1 colSpan=3 align=left>Debug </TD><TD class=LOGEntry1 colSpan=8 align=left>The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.</TD></TR></TBODY></TABLE>

  • #2
    If you have access you can open the database to see the size of the fields. Normally they are setup to be 255 and the longest string you are showing is about 100. I guess you are setup for NOAA as your forecast source?


    • #3
      Weather Underground...I have it setup using WeatherXML...


      • #4
        The database population is done by WeatherXML. Post your question on that forum and CFGuy should be able to answer it. I suspect he will need the same information that I asked about the database field size. Likely what needs to happen is the field may be setup for only 100 characters and 102 are being written. It is an easy edit if you have Access.


        • #5
          I don't have access tho...I don't tkink I'm using SQL

          Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Program Files\HomeSeer HS2\data\mcsTemperature\mcsTemperature.mdb