Announcement

Collapse
No announcement yet.

Errors....

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

    Errors....

    Can't seem to find a way to get these to stop. Any ideas on how to fix this? I have reinstalled on top of the old code, but that doesn't work. I would like to preserve my old database if possible...



    4/23/2012 12:52:49 pm blnetcallerid info phone line 1 cid data -- ##date04231252...nmbr17134892964...name -private name- +++

    4/23/2012 12:52:49 pm hsphone searching for a match on cid. cid num is: 17134892964

    4/23/2012 12:52:49 pm hsphone so far, no match, call has cid, but is not private or out-of-area, using default handling

    4/23/2012 12:52:49 pm hsphone hsp is not set to announce unknown callers

    4/23/2012 12:52:50 pm hsphone adding caller: 17134892964 to address book

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabaseupdate(): an error has occurred during database update statement: operation is not allowed when the object is closed.

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabaseupdate(): databasepathandname: c:program fileshomeseer 2datablnetcalleridblnetcallerid.mdb

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabaseupdate(): sqlupdatestring: insert into tblcalllog (txtdatetime,txtphoneline,txtcallernumber,txtcallername,txtlocation,txtfoundinphonebook,txtaddedtophonebook,txtdateaddedtophonebook) values('4/23/2012 12:52:49 pm','1','17134892964','-private name-','unknown','no','yes','4/23/2012 12:52:54 pm')

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabasemultiselect(): an error has occurred during database select query: the connection cannot be used to perform this operation. it is either closed or invalid in this context.

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabasemultiselect(): databasepathandname: c:program fileshomeseer 2datablnetcalleridblnetcallerid.mdb

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabasemultiselect(): connstring: dsn=blnetcallerid

    4/23/2012 12:52:54 pm blnetcallerid error databasefunctionssingleton.performdatabasemultiselect(): selectquerystring: select top 100 txtdatetime, txtcallernumber, txtcallername from tblcalllog order by txtdatetime desc


    .

    #2
    Here is a better shot of the errors

    4/23/2012 12:52:49 PM - BLNetCallerId Info - Phone Line 1 CID Data --> ###DATE04231252...NMBR17134892964...NAME -PRIVATE NAME- +++
    4/23/2012 12:52:49 PM - HSPhone - Searching for a match on CID. CID Num is: 17134892964
    4/23/2012 12:52:49 PM - HSPhone - So far, no match, call has CID, but is not private or out-of-area, using default handling
    4/23/2012 12:52:49 PM - HSPhone - HSP is not set to announce unknown callers
    4/23/2012 12:52:50 PM - HSPhone - Adding caller: 17134892964 to address book
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblCallLog (txtDateTime,txtPhoneLine,txtCallerNumber,txtCallerName,txtL ocation,txtFoundInPhonebook,txtAddedToPhonebook,txtDateAdded ToPhonebook) VALUES('4/23/2012 12:52:49 PM','1','17134892964','-PRIVATE NAME-','Unknown','No','Yes','4/23/2012 12:52:54 PM')
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLNetCallerId
    4/23/2012 12:52:54 PM - BLNetCallerId Erro - DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT TOP 100 txtDateTime, txtCallerNumber, txtCallerName FROM tblCallLog ORDER BY txtDateTime DESC
    4/23/2012 12:53:32 PM - BLNetCallerId Info - Phone Line 1 CID Data --> ###DATE...NMBR...NAME MESSAGE WAITING+++
    .

    Comment


      #3
      Haven't had any luck with even long term backup copies of the DB. I was hoping I could salvage the list of callers and messages we collected over the last 5 years....
      .

      Comment


        #4
        Have you tried a compact and repair in Microsoft Access?
        Cheers,
        Bob
        Web site | Help Desk | Feature Requests | Message Board

        Comment


          #5
          Originally posted by Blade View Post
          Have you tried a compact and repair in Microsoft Access?
          I hadn't but have now. No luck. Get a little bit different errors now though...

          PHP Code:
          6/3/2012 12:41:08 PM  BLNetCallerId Erro DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement:  Operation is not allowed when the object is closed.
          6/3/2012 12:41:08 PM  BLNetCallerId Erro DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName:  C:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb
          6
          /3/2012 12:41:08 PM  BLNetCallerId Erro DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString:  DELETE from tblCallLog WHERE txtDateTime #6/4/2011 12:41:8#
          6/3/2012 12:41:08 PM  BLNetCallerId Erro BLNetCallerId Auto Database Purge FAILED
          It looks better though.....

          I am resigned to the fact that I probably will just have to start from scratch, but if you can think of something else, I would happily try it and greatly appreciate it!

          Rob
          .

          Comment


            #6
            Do you have database logging enabled in the plugin options page?
            It is saying that the database is closed that is why I ask
            Cheers,
            Bob
            Web site | Help Desk | Feature Requests | Message Board

            Comment


              #7
              Had to do a restart after an update. Here are the current errors.

              PHP Code:
              6/3/2012 3:15:06 PM BLNetCallerId start Register Callback completed
              6
              /3/2012 3:15:06 PM BLNetCallerId start BLNetCallerId version is1.1.23.0
              6
              /3/2012 3:15:06 PM Plug-In Initializing Plug-inBLNetCallerId
              6
              /3/2012 3:15:07 PM BLNetCallerId start Initializing BLNetCallerId...
              6/3/2012 3:15:07 PM BLNetCallerId start Loaded configuration successfully
              6
              /3/2012 3:15:07 PM BLNetCallerId start Phone Line 1 (COM7is Open!
              6/3/2012 3:15:07 PM BLNetCallerId start Phone Line 2 (COM8is Open!
              6/3/2012 3:15:07 PM BLNetCallerId Error DatabaseFunctionsSingleton.GetADODBConnection(): Caught exception opening database connectionUnrecognized database format 'C:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb'.
              6/3/2012 3:15:07 PM BLNetCallerId Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statementOperation is not allowed when the object is closed.
              6/3/2012 3:15:07 PM BLNetCallerId Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndNameC:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb
              6
              /3/2012 3:15:07 PM BLNetCallerId Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateStringDELETE from tblCallLog WHERE txtDateTime 
              6
              /3/2012 3:15:08 PM BLNetCallerId start BLNetCallerId plugin has been initialized
              6
              /3/2012 3:15:08 PM Plug-In Finished initializing plug-in BLNetCallerId
              6
              /3/2012 3:15:08 PM BLNetCallerId Error DatabaseFunctionsSingleton.CompactDatabase(): An error has occurred during compacting of the databaseUnrecognized database format 'C:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb'.
              6/3/2012 3:15:08 PM BLNetCallerId Error DatabaseFunctionsSingleton.CompactDatabase(): DatabasePathAndNameC:\Program Files\HomeSeer 2\Data\BLNetCallerId\BLNetCallerId.mdb 
              .

              Comment


                #8
                Originally posted by Blade View Post
                Do you have database logging enabled in the plugin options page?
                It is saying that the database is closed that is why I ask
                Sorry. Didn't refresh the page and missed your message. I do have database logging enabled.
                Attached Files
                .

                Comment


                  #9
                  Ok that is strange.
                  Let me have a look at the code and see if I can see anything obvious. I am not seeing that error with my BLNetCallerId.

                  I wonder if your database is corrupt. Have you tried shutting down HS and starting Microsoft Access and compact and repair the database?
                  Cheers,
                  Bob
                  Web site | Help Desk | Feature Requests | Message Board

                  Comment


                    #10
                    Originally posted by Blade View Post
                    Ok that is strange.
                    Let me have a look at the code and see if I can see anything obvious. I am not seeing that error with my BLNetCallerId.

                    I wonder if your database is corrupt. Have you tried shutting down HS and starting Microsoft Access and compact and repair the database?
                    I have. It changed up the error messages a bit, but did not fix it. See above.

                    I think I am just going to have to suck it up and start over. Even many month old copies of the db error out with the same errors.
                    .

                    Comment


                      #11
                      The database must be corrupt beyond the compact and repair fix in Access
                      Cheers,
                      Bob
                      Web site | Help Desk | Feature Requests | Message Board

                      Comment

                      Working...
                      X