WAMA 1.17b04 - SQL error destination finder

[Woozie 732]

I'm getting a SQL error when hitting the scan library button in destination finder. It doesnt open the select/deselect dialog as depicted in the manual and errors out right away. Using latest P3D v4.5 with WAMA 1.17b04 (installed WhereAreMyAircraft_Install_P3D_V44.exe and running app as admin)

 

here's the error-log:

 

Quote

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
near "s": syntax error
   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.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at WhereAreMyAircraft.Database.GateInformationDbHandler.AddSceneryArea(String title)
   at WhereAreMyAircraft.SceneryScanner..ctor()
   at WhereAreMyAircraft.DestinationFinder.ibScanScenery_Click(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 

Edited July 21, 2019 by Lorby_SI

[Lorby_SI 2,036]

HI,

this is odd. That would imply that you have file- or scenery names on your computer that break the SQL statements. Technically this is impossible, but who knows.

Could you please send me an email to the address on the last page of the manual? I will require more information about your simulator setup. Are you using the P4AO by any chance? Then you could create a backup ZIP file using this tool and send that to me...

Best regards

[Lorby_SI 2,036]

Hello again,

I may have found the problem.

Please write me an email with your proof of purchase (order number and shop) and I will provide a bugfixed version.

Best regards

Edited July 21, 2019 by Lorby_SI

[Woozie 732]

Excellent support, thank you Oliver! I pm'd you the proof of purchase