none
Sqlite Exception: No such table: user_property RRS feed

  • 问题

  • 我们有一个基于Unity的UWP项目在引用Sqlite库的时候报错说无法找到相关的Table.
    但我们在unity引擎里是可以访问没有问题的,导出UWP工程的时候也安装了Sqlite引用,但就是在调式UWP工程的时候有这个问题。

    具体报错如下:

    'RunestoneKeeper.exe' (CoreCLR: CoreCLR_UWP_Domain): Loaded 'F:\fsyworkspace\uwp_2018_2_23_5\RunestoneKeeper\bin\x64\Debug\AppX\System.Reflection.TypeExtensions.dll'. Cannot find or open the PDB file.
    Exception thrown: 'Mono.Data.Sqlite.SqliteException' in Mono.Data.Sqlite.dll
    Exception thrown: 'Mono.Data.Sqlite.SqliteException' in Mono.Data.Sqlite.dll
    SqliteException: SQLite error
    no such table: user_property
       at Mono.Data.Sqlite.SQLite3.Prepare(SqliteConnection cnn, String strSql, SqliteStatement previous, UInt32 timeout, String& strRemain)
       at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand()
       at Mono.Data.Sqlite.SqliteDataReader.NextResult()
       at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
       at DbManagerEx.ExecuteQuery(String sqlQuery)
       at DbObjectBase`1.UpdateDataToDbEx(Object inst, List`1 updateList, List`1 queryList)
       at UserPropertyAttribute.UpdateUserProrperty(Int32 tokenCoins, Int32 goldCoins)
       at DbManagerEx.RestDatabase()
       at UWPWork.ApplyLoad()
       at CommonTooltipLoading.<DelayMethod>d__10.MoveNext()
       at UnityEngine.SetupCoroutine.InvokeMoveNext(IEnumerator enumerator, IntPtr returnValueAddress)
       at UnityEngine.SetupCoroutine.$Invoke1InvokeMoveNext(Int64 instance, Int64* args)
       at UnityEngine.Internal.$MethodUtility.InvokeMethod(Int64 instance, Int64* args, IntPtr method) 
    (Filename: <Unknown> Line: 0)


    Trimming D3D resources.

    The thread 0x59d0 has exited with code 0 (0x0).
    The thread 0x57c8 has exited with code 0 (0x0).
    The program '[25040] RunestoneKeeper.exe' has exited with code 1 (0x1).

    2018年2月24日 3:56

全部回复

  • no such table: user_property

    提示是缺少表,把sqllite 数据库文件复制到电脑中,打开看下它的表结构。


    专注于.NET ERP/CRM开发框架,C/S架构,SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms

    2018年2月26日 1:01
  • 我们在数据库文件里找到了表结构,表结构看上去没啥问题。里面含有user_property, 另外就是我们PC的版本是正常的读取的,但就是UWP工程读取时出现了上述异常。
    2018年2月26日 7:58