Reply to thread

Message

<blockquote data-quote="gerikes" data-source="post: 264829" data-attributes="member: 74507">CANTOPEN changeHi all.Thanks for all the work Chreekar, been using your plugin for a few months now, runs well.I switched over to RC1 and I'm getting that same CANTOPEN problem. Here's what I did to fix it...[code]Index: myEmulators/DB.cs===================================================================--- myEmulators/DB.cs&nbsp; &nbsp; (revision 1775)+++ myEmulators/DB.cs&nbsp; &nbsp; (working copy)@@ -40,7 +40,7 @@&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; public static void launch()&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String path = Options.getMainFolder() + @&quot;\database\&quot; + dbName;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; +&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String path = Config.GetFile(Config.Dir.Database, dbName);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; sqlDB = new SQLiteClient(path);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; createDBs();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try[/code]Of course, the problem is that if someone is using an old database and switches to the new version, the path is changed and so their new database will not be found. Not sure how you want to go about this, maybe checking the old path for an existing database and copying it if found?UpdateMaybe even something like this?[CODE]Index: myEmulators/DB.cs===================================================================--- myEmulators/DB.cs&nbsp; &nbsp; (revision 1775)+++ myEmulators/DB.cs&nbsp; &nbsp; (working copy)@@ -21,7 +21,10 @@&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; private static String tableOptionsName = &quot;myEmulatorsOptions&quot;;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; private static SQLiteClient sqlDB;&nbsp;-&nbsp; &nbsp; &nbsp; &nbsp; public enum SaveInfo+&nbsp; &nbsp; &nbsp; &nbsp; private static String oldDatabaseFilename = Options.getMainFolder() + @&quot;\database\&quot; + dbName;+&nbsp; &nbsp; &nbsp; &nbsp; private static String newDatabaseFilename = Config.GetFile(Config.Dir.Database, dbName);++&nbsp; &nbsp; &nbsp; &nbsp; public enum SaveInfo&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ALL,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ONLY_VERSION_INFO,@@ -40,8 +43,9 @@&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; public static void launch()&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String path = Options.getMainFolder() + @&quot;\database\&quot; + dbName;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sqlDB = new SQLiteClient(path);+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CopyOldDatabaseIfFound();++&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sqlDB = new SQLiteClient(newDatabaseFilename);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; createDBs();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {@@ -146,6 +150,16 @@&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp;+&nbsp; &nbsp; &nbsp; &nbsp; // Copy a users database from the old place where databases were found.+&nbsp; &nbsp; &nbsp; &nbsp; private static void CopyOldDatabaseIfFound()+&nbsp; &nbsp; &nbsp; &nbsp; {+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (File.Exists(oldDatabaseFilename) &amp;&amp;+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; File.Exists(newDatabaseFilename) == false)+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; File.Copy(oldDatabaseFilename, newDatabaseFilename);+&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }+&nbsp; &nbsp; &nbsp; &nbsp; }+&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; private static void createDBs()&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; //DatabaseUtility.SetPragmas(sqlDB);[/CODE]</blockquote>

[QUOTE="gerikes, post: 264829, member: 74507"] [b]CANTOPEN change[/b] Hi all. Thanks for all the work Chreekar, been using your plugin for a few months now, runs well. I switched over to RC1 and I'm getting that same CANTOPEN problem. Here's what I did to fix it... [code]Index: myEmulators/DB.cs =================================================================== --- myEmulators/DB.cs (revision 1775) +++ myEmulators/DB.cs (working copy) @@ -40,7 +40,7 @@ public static void launch() { - String path = Options.getMainFolder() + @"\database\" + dbName; + String path = Config.GetFile(Config.Dir.Database, dbName); sqlDB = new SQLiteClient(path); createDBs(); try [/code] Of course, the problem is that if someone is using an old database and switches to the new version, the path is changed and so their new database will not be found. Not sure how you want to go about this, maybe checking the old path for an existing database and copying it if found? [b]Update[/b] Maybe even something like this? [CODE]Index: myEmulators/DB.cs =================================================================== --- myEmulators/DB.cs (revision 1775) +++ myEmulators/DB.cs (working copy) @@ -21,7 +21,10 @@ private static String tableOptionsName = "myEmulatorsOptions"; private static SQLiteClient sqlDB; - public enum SaveInfo + private static String oldDatabaseFilename = Options.getMainFolder() + @"\database\" + dbName; + private static String newDatabaseFilename = Config.GetFile(Config.Dir.Database, dbName); + + public enum SaveInfo { ALL, ONLY_VERSION_INFO, @@ -40,8 +43,9 @@ public static void launch() { - String path = Options.getMainFolder() + @"\database\" + dbName; - sqlDB = new SQLiteClient(path); + CopyOldDatabaseIfFound(); + + sqlDB = new SQLiteClient(newDatabaseFilename); createDBs(); try { @@ -146,6 +150,16 @@ } } + // Copy a users database from the old place where databases were found. + private static void CopyOldDatabaseIfFound() + { + if (File.Exists(oldDatabaseFilename) && + File.Exists(newDatabaseFilename) == false) + { + File.Copy(oldDatabaseFilename, newDatabaseFilename); + } + } + private static void createDBs() { //DatabaseUtility.SetPragmas(sqlDB); [/CODE] [/QUOTE]

Verification