Announcement

Collapse
No announcement yet.

Error in Log

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

  • CFGuy
    replied
    Try running the compact and repair. Its size is fine. It doesn't need compacted but something must be wrong with the database file since you are getting errors when the queries are run. See if the repair will fix it.

    Leave a comment:


  • jayman13
    replied
    Originally posted by CFGuy View Post
    Are you using an access database? If so, check to see how big the file is. If it is getting close or over 2 Gb, then it needs to be compacted.
    I am using Access and the database file is only 34 mb.

    Leave a comment:


  • CFGuy
    replied
    Are you using an access database? If so, check to see how big the file is. If it is getting close or over 2 Gb, then it needs to be compacted.

    Leave a comment:


  • jayman13
    started a topic Error in Log

    Error in Log

    I keep getting this error every 2-3 days. Any idea how I can fix them?

    4/30/2013 4:29:54 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:29:54 PM ~!~Error~!~ADO Opening database: Unspecified error
    4/30/2013 4:29:54 PM ~!~Error~!~Delete (Event1) Error: Operation is not allowed when the object is closed.
    4/30/2013 4:29:54 PM ~!~Error~!~Deleting event with ref 5280
    4/30/2013 4:30:00 PM ~!~Event~!~Event Trigger "HSTV Set Device Strings"
    4/30/2013 4:30:00 PM ~!~Event~!~Running script statement immediately: &hs.Plugin("HSTV").setDeviceStrings()
    4/30/2013 4:30:00 PM ~!~HSTV~!~runSelectQueryAccess: SELECT c.channelDevCode, count(*) FROM tvchannels c WHERE c.channelDevCode IS NOT NULL GROUP BY c.channelDevCode HAVING count(*) > 1
    4/30/2013 4:30:00 PM ~!~Debug~!~Unspecified error
    4/30/2013 4:30:00 PM ~!~HSTV~!~runSelectQueryAccess: SELECT c.channelID, c.channelName, c.channelNickName, c.channelNumber, l.starttime, l.endtime, l.title, l.episode, l.episodenum, l.category, l.programyear, l.videoaspect, l.videocolor, l.starrating, l.ratingsystem, l.rating, l.ratingadvisory, l.subtitles, l.description, l.audio, l.actors, l.director, l.hosts, l.guests, l.producers, l.scheduledEvent, l.repeatshowing , c.channelDevCode FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID AND c.viewHide = 0 AND ( (l.starttime < DateAdd('n',5,Now()) AND l.endtime > DateAdd('n',5,Now()) ) OR (l.starttime < DateAdd('n',35,Now()) AND l.endtime > DateAdd('n',35,Now()) ) ) AND Len(c.channelDevCode) > 0 ORDER BY c.channelDevCode, c.channelNickname, l.starttime
    4/30/2013 4:30:00 PM ~!~Debug~!~Unspecified error
    4/30/2013 4:30:00 PM ~!~HSTV~!~runSelectQueryAccess: SELECT channelID, channelDevCode FROM tvChannels WHERE Len(channelDevCode) > 0 ORDER BY channelDevCode
    4/30/2013 4:30:00 PM ~!~Debug~!~Unspecified error
    4/30/2013 4:30:00 PM ~!~HSTV~!~Finished setting HSTV devices
    4/30/2013 4:30:04 PM ~!~Error~!~ADO Opening database: Unspecified error
    4/30/2013 4:30:04 PM ~!~Error~!~Delete (Event1) Error: Operation is not allowed when the object is closed.
    4/30/2013 4:30:04 PM ~!~Error~!~Deleting event with ref 9265
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:30:04 PM ~!~Error~!~ADO Opening database: Unspecified error
    4/30/2013 4:30:04 PM ~!~Error~!~Delete (Event1) Error: Operation is not allowed when the object is closed.
    4/30/2013 4:30:04 PM ~!~Error~!~Deleting event with ref 9054
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:30:23 PM ~!~Error~!~Scripting runtime error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80004005): Unspecified error at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalL ateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCa ll(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at scriptcode2.scriptcode2.open_db() at scriptcode2.scriptcode2.init() at scriptcode2.scriptcode2.Main(Object Params) --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.
Working...
X