VB .NET Plugin: sqlite.dll Error

[samuel337]

Originally Posted by STSC

This doesn't work.
I already get an false return value of MediaPortal.TV.Database.TVDatabase.GetRecordings(r ecordings)
!
MessageBox.Show(MediaPortal.TV.Database.TVDatabase .GetRecordings(recordings))

If there's a false value, check out the log files - the exception text is recorded there. Post it here if it doesn't help.

Sam

[STSC]

I already did this:

15.12.2004 21:29:39 opening tvdatabase
15.12.2004 21:29:39 TVDatabase exception errie DLL (sqlite.dll) kann nicht geladen werden. stack: at SQLite.NET.SQLiteClient.sqlite_open(String filename, Int32 mode, String& errmsg)
at SQLite.NET.SQLiteClient..ctor(String dbName)
at MediaPortal.TV.Database.TVDatabase..cctor()
15.12.2004 21:29:39 tvdatabase opened

[STSC]

I know now what the error causes.
It's in the MP source code:

m_db = new SQLiteClient(@"database\TVDatabaseV9.db");

of method "static TVDatabase()"

    private TVDatabase()
    {
    }

    /// <summary>
    /// static constructor. Opens or creates the tv database from database\TVDatabaseV6.db
    /// </summary>
    static TVDatabase()
    {
      lock (typeof(TVDatabase))
      {
        try
        {
          // Open database
          Log.Write("opening tvdatabase");
          System.IO.Directory.CreateDirectory("database");
          //Upgrade();
          m_db = new SQLiteClient(@"database\TVDatabaseV9.db");
          CreateTables();

          if (m_db!=null)
          {
            m_db.Execute("PRAGMA cache_size=8192\n");
            m_db.Execute("PRAGMA synchronous='OFF'\n");
            m_db.Execute("PRAGMA count_changes='OFF'\n");
          }

        }
        catch (Exception ex)
        {
          Log.Write("TVDatabase exception err:{0} stack:{1}", ex.Message,ex.StackTrace);
        }
        Log.Write("tvdatabase opened");
      }
    }

But I have no idea why?

[STSC]

Okay, I know now the issue.
MP uses SQLite Wrapper 2.0.1.0 and Sceneo Tvcentral/Meedio uses SQLite Wrapper 1.0.1.0. The thing is that these are two completely different wrapper classes with the same name. :x :x :x
But I wanted to support both programs, so I have to remove one.