Jump to content
The simFlight Network Forums

keep getting same issue


marlboro
 Share

Recommended Posts

hello simon.

Keep getting the below error when connecting to fsx. Im using UT2 and have all the updates installed.

Ive unistalled and reinstalled a few times... some help needed please

18/07/2012 14:04:29.174

System.Data.SQLite.SQLiteException: SQLite error

no such table: flights

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteReader()

at Ut2SqliteInterface.Ut2IdMapper.MakeMap() in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\UT2 Sqlite Interface\Ut2SqliteInterface\Ut2IdMapper.cs:line 41

at Ut2Interface.Ut2LocalDatabase.MakeDatabaseMap() in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\Traffic Board\Ut2LocalDatabase.cs:line 127

at Ut2Interface.Ut2Database.MakeIdMap() in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\Traffic Board\Ut2Database.cs:line 338

at Ut2Interface.Ut2LocalDatabase..ctor() in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\Traffic Board\Ut2LocalDatabase.cs:line 30

at Traffic_Board.TrafficBoard.OpenDataSources() in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\Traffic Board\TrafficBoard.cs:line 14198

at Traffic_Board.TrafficBoard.FSInterfaceOpened(String versionData) in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\Traffic Board\TrafficBoard.cs:line 14169

at STB.SimConnectWrapper.SimConnectWrapper10SP2.SimConnect_OnRecvOpen(SimConnect sender, SIMCONNECT_RECV_OPEN data) in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\SimConnect Wrapper 10 SP2\SimConnectWrapper10SP2.cs:line 1455

at Microsoft.FlightSimulator.SimConnect.SimConnect.raise_OnRecvOpen(SimConnect value0, SIMCONNECT_RECV_OPEN value1)

at Microsoft.FlightSimulator.SimConnect.SimConnect.OnReceiveMessage(SIMCONNECT_RECV pData, UInt32 cbData)

at Microsoft.FlightSimulator.SimConnect.CSignalProcDelegateMarshaler.CallSignalProc(SIMCONNECT_RECV* pData, UInt32 cbData, Void* pContext)

at SimConnect_CallDispatch(Void* , IntPtr , Void* )

at Microsoft.FlightSimulator.SimConnect.SimConnect.ReceiveDispatch(SignalProcDelegate pfcnSignal)

at Microsoft.FlightSimulator.SimConnect.SimConnect.ReceiveMessage()

at STB.SimConnectWrapper.SimConnectWrapper10SP2.DefWndProc(Message& m) in C:\Users\Simon Jones\Documents\FSX Projects\FSX Traffic Board\STB V3 SP3 Update 2\Client\SimConnect Wrapper 10 SP2\SimConnectWrapper10SP2.cs:line 114

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Link to comment
Share on other sites

I've a feeling I've seen this before, something to do with an empty database when user defined flights were added. I don't have UT2 installed at the moment as I had to recover my FSX from a backup following a severe dose of the stutters. Leave it with me a while and I'll see what I can find out.

Simon

Link to comment
Share on other sites

I've made a change to the code that should reveal the name of the database causing the error. Please do the following:

1) Locate your STB install folder

2) Rename the files Ut2SqliteInterface.dll and Ut2SqliteInterface.pdb to some other name

3) Unzip the files in the attachment to this post and put them in the STB install folder.

4) Try STB again and let me know what happens. If you recognise the database name could you send it to me please?

Thanks

Simon

ut2.zip

Link to comment
Share on other sites

Thanks. In case anyone else runs into this, the problem was a UT2 database that did not contain any flight information being present in the UT2 application folder\databases directory. The database in question belonged one level up.

PS. the error message is improved for the next version!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use. Guidelines Privacy Policy We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.