After completing the conversion I get the following error and Pilot2ATC will crash.

 

code = Error (1 ), message = System.Data.SQLite.SQLiteException
(0xB7AF001 F): SOL logic error
no such table: ATCControllers
at System.Data.SQILite.SQLite3.Prepare(SQLiteConnection cnn,
SQLiteCommand command, String strSql, SQLiteStat ement previous,
Ulnt32 timeoutMS, String& strRernain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand0
at System.Data.SQLite.SQLiteDataReader.NextResult0
at System.Data.SQLite.SQLiteDataReader .. ctor(SQLiteCommand cmd,
CommandBehavior behave}
at
Syst em.Data.SQLite.SQLiteCommand.lExecuteReader(Command Behavior
behavior)
at LinqToDB.Data.DataConnection.ExecuteRe·ader(CommandBeh avior
command Beh avior)
at
LinqToDB.Dat a.DataConnection. ExecuteDataReader(CommandBehavior
command Behavior)
at LinqToDB.Data.DataConnection.QueryRunner.ExecuteReaderQ
at LinqToDB.Linq.QueryRunner.< ExecuteQuery>d_ 11 ' 1.MoveN ext0
at System.Collections.Generi c.Lisf 1 .. c1:or(I Enumerable' 1 co ll ection)
at System.Linq.Enumerable.Tolistl[TSource](I Enumernble'1 source)
at P2ADatalinq.Data.DataMgr.LoadATCController s0
at P2ADatalinq.Data.DataMgr. I nit0

After you successfully do the conversion, shut down P2A and restart it.  That will then load the new data into the program.

Make sure that there are 2 database files in the Data Folder of V3.  P2ADynamicData.db and P2ABaseData.db and make sure neither of them is 0 bytes long.  That would indicate something went wrong in t he conversion.

Dave

 

I figured it out. When I was downloading the Nav data, I created a new data folder within the data folder, so I just had to move the downloaded data to the right data folder.