Announcement

Collapse
No announcement yet.

Arithmetic operation resulted in an overflow

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Arithmetic operation resulted in an overflow

    Hi CFGUY.

    My System had been running very well, tweeting what is about to show up on which channel and I have got something like 100 followers so far. However for some reason it has stopped working today, when i go into the favorites i see my default ALL favorites entry, but in scheduled there is nothing.

    I turned on high level debugging, and when the scheduled page is visited i get the error below. It also does not tweet any of the shows so i assume this is related. Do you have any ideas on this one?

    <table border="0" cellpadding="0" cellspacing="2" width="100%"><tbody><tr><td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Error Scheduled: Arithmetic operation resulted in an overflow.</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 2, Cols: 1</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT deviceType, deviceText FROM deviceTypes ORDER BY deviceText</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 14, Cols: 23</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT s.favID, s.channelID, s.starttime, d.deviceName, t.deviceText, r.repeatText, l.title, c.channelNickName, c.channelNumber, s.isActive, f.userID, f.repeattype, f.intSun, f.intMon, f.intTue, f.intWed, f.intThu, f.intFri, f.intSat, f.starttime, l.episode, l.episodenum, s.scheduledID, s.inactiveReason FROM tvChannels c, tvListings l, scheduledFavs s, userFavs f, devices d, deviceTypes t, userFavsRepeats r WHERE c.channelID = l.channelID And l.channelID = s.channelID And l.starttime = s.starttime And s.favID = f.favID AND f.deviceID = d.deviceID AND d.deviceType = t.deviceType AND f.repeatType = r.repeatType AND f.isActive = 1 AND (s.ranTime IS NULL OR l.starttime > Now() ) AND l.endtime > Now() ORDER BY s.starttime Asc</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 4, Cols: 2</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT d.deviceID, d.deviceName, t.deviceText FROM devices d, deviceTypes t WHERE d.deviceType = t.devTypeID</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 0, Cols: 1</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT optionValue, optionName FROM userOptions WHERE optionName = 'scheduledLastUser' AND userID = 'Travis' </td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 0, Cols: 0</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:48 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">GenPage: name: pg = value: scheduled</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 0, Cols: 0</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT Distinct userID FROM userFavs ORDER BY userID</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 0, Cols: 24</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT f.favID, f.deviceID, f.title, f.channelID, f.starttime, f.repeattype, f.matchtype, f.prioritylevel, f.userID, f.intSun, f.intMon, f.intTue, f.intWed, f.intThu, f.intFri, f.intSat, c.channelNickName, f.keywords, f.episodeText, f.creditname, d.deviceName, d.deviceType, c.channelNumber,c.channelName, f.isActive FROM (userFavs AS f LEFT JOIN tvchannels AS c ON f.channelID = c.channelID) INNER JOIN devices AS d ON f.deviceID = d.deviceID ORDER BY d.devicename, f.priorityLevel, f.userID, f.isActive desc, f.repeattype, f.title, f.episodeText, f.keywords, f.creditname</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 0, Cols: 0</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:46 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">GenPage: name: pg = value: events</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Error Scheduled: Arithmetic operation resulted in an overflow.</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 2, Cols: 1</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT deviceType, deviceText FROM deviceTypes ORDER BY deviceText</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 14, Cols: 23</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT s.favID, s.channelID, s.starttime, d.deviceName, t.deviceText, r.repeatText, l.title, c.channelNickName, c.channelNumber, s.isActive, f.userID, f.repeattype, f.intSun, f.intMon, f.intTue, f.intWed, f.intThu, f.intFri, f.intSat, f.starttime, l.episode, l.episodenum, s.scheduledID, s.inactiveReason FROM tvChannels c, tvListings l, scheduledFavs s, userFavs f, devices d, deviceTypes t, userFavsRepeats r WHERE c.channelID = l.channelID And l.channelID = s.channelID And l.starttime = s.starttime And s.favID = f.favID AND f.deviceID = d.deviceID AND d.deviceType = t.deviceType AND f.repeatType = r.repeatType AND f.isActive = 1 AND (s.ranTime IS NULL OR l.starttime > Now() ) AND l.endtime > Now() ORDER BY s.starttime Asc</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 4, Cols: 2</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT d.deviceID, d.deviceName, t.deviceText FROM devices d, deviceTypes t WHERE d.deviceType = t.devTypeID</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 0, Cols: 1</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT optionValue, optionName FROM userOptions WHERE optionName = 'scheduledLastUser' AND userID = 'Travis' </td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 0, Cols: 0</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:44 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">GenPage: name: pg = value: scheduled</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:42 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">Array Rows: 0, Cols: 0</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:42 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:42 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">GenPage: name: pg = value: hstvtuner</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 148, Cols: 3</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT t.ratingID, t.rating, t.hideRating, u.IsAllowed FROM tvratings t, userratings u WHERE t.ratingID = u.ratingID AND u.UserID = 'Travis' </td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 95, Cols: 30</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT t.starttime, t.endtime, c.channelNumber, u.SortOrder, c.channelName, u.userid, t.title, t.episode, t.description, t.category, t.episodenum, t.audio, t.subtitles, t.ratingsystem, t.rating, c.channelNickName, c.channelID, c.channelIcon, c.channelNumber, t.videoaspect, t.videocolor, t.starrating, t.actors, t.guests, t.director, t.producers, t.hosts, t.repeatshowing, t.programyear, t.scheduledEvent, t.ratingadvisory FROM userChannels u, tvlistings t, tvchannels c WHERE u.channelID = t.channelID AND t.channelID = c.channelID AND u.userid = 'Travis' AND u.IsSelected = 1 AND u.IsAllowed = 1 AND c.viewHide = 0 AND ( (t.starttime >= #2012/03/10 14:00:00# AND t.starttime <= #2012/03/10 16:59:00#) OR (t.endtime >= #2012/03/10 14:01:00# And t.endtime <= #2012/03/10 16:59:00#) OR (t.starttime < #2012/03/10 14:00:00# AND t.endtime > #2012/03/10 16:59:00#) ) ORDER BY u.SortOrder, t.channelID, t.starttime</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 17, Cols: 2</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT c.channelID, c.channelname, c.channelnickname FROM tvChannels c, userChannels u WHERE u.channelID = c.channelID AND u.userID = 'Travis' AND u.IsSelected = 1 AND u.IsAllowed = 1 AND c.channelID IN (SELECT DISTINCT channelID FROM tvlistings) ORDER BY u.sortorder, c.channelname</td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 24, Cols: 1</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT OptionValue, OptionName FROM UserOptions WHERE UserID = 'Travis' AND OptionName IN ('intShowNameNum','intUseNickName','intDispShowLength','intS howYear','intShowRepeat','strShowAudio','strShowSubtles','st rShowRating','strShowEPNum','strShowCat','intShowVideo','int ShowActor','intShowGuest','intShowHost','intShowDirector','i ntShowProducer','intChanSortOrder', 'intHoursWide','intJumpWhen','intRepeatHours','intShowCatLeg end','intShowWeekDay','intShowGrid','tuneItem','gridChanSort Order') </td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 0, Cols: 0</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td></tr> <tr> <td colspan="1" class="LOGDateTime0" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType0" align="left"> HSTV </td><td colspan="8" class="LOGEntry0" align="left">Array Rows: 0, Cols: 1</td></tr> <tr> <td colspan="1" class="LOGDateTime1" nowrap="nowrap" align="left">3/10/2012 2:24:41 PM </td><td colspan="3" class="LOGType1" align="left"> HSTV </td><td colspan="8" class="LOGEntry1" align="left">SELECT optionValue, optionName FROM userOptions WHERE optionName = 'userStartPage' AND userID = 'Travis' </td></tr></tbody></table>
    HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

    Facebook | Twitter | Flickr | Google+ | Website | YouTube

  • #2
    On the General Optons page what values do you have for Number Of Days Ahead To Create Events?
    --
    Jeff Farmer
    HS 3, HSPhone
    My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
    Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

    Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

    Comment


    • #3
      It was set to 7, i changed that to 1 to see what it would do and came up with the same error.

      Was working perfectly, seems strange that it lasted weeks to a month and then started error-ing up now

      I had the Home Automation system working so that each morning (at about 2am) it would restart the system, just to prevent any issues with handles, or processes freezing the machine. It normally works fine but as of 2 days ago it just never started the HSTV back up doing tweets etc. The Guide Data is there, and always updates, but the Favorites don't seem to translate into Scheduled due to the error.

      Thanks for your help
      HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

      Facebook | Twitter | Flickr | Google+ | Website | YouTube

      Comment


      • #4
        Check to see what size the hstv database is.

        If it is at 2 Gigs or more that would explain getting errors when nothing has changed.

        If it is then use Access to Comact the database.

        I need to send you a newer version that has a feature built in to compact the database for you.
        I'll zip it up and send you instructions to upgrade. It will be tomorrow evening before I can get to it.
        --
        Jeff Farmer
        HS 3, HSPhone
        My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
        Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

        Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

        Comment


        • #5
          Surprisingly enough the database is quite small (around 10mb), i only have it set to keep 1 days history so the size does not get to big.

          The TV listings page is big, with about 4500 records so it is still importing, but having an error when it is trying to work out what to make favorite and then scheduled.
          HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

          Facebook | Twitter | Flickr | Google+ | Website | YouTube

          Comment


          • #6
            It was less than 10mb, but did a compress and repair and it is up and working now. Maybe for a future version there could be a utility that closes the db, runs a repair and compress and reopens it as an event, or something that could be run as a homeseer cleanup.

            Thanks for your help.
            HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

            Facebook | Twitter | Flickr | Google+ | Website | YouTube

            Comment


            • #7
              That is built into the most current version.
              You can add a HS event to run each evening to compact the database.
              I'll try to zip the new version up and send it to you tonight.
              --
              Jeff Farmer
              HS 3, HSPhone
              My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
              Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

              Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

              Comment

              Working...
              X