Xcode – 东风吹

Xcode中无法加载数据库：InvalidOperationException: No connection associated with this command

问题

在Xcode中成功打包后，进入游戏，点击开始加载游戏时，在Xcode中报如下错误，跟之前遇到的有些相似，也是跟这数据库有关的问题无法加载数据的问题。

InvalidOperationException: No connection associated with this command
  at Mono.Data.Sqlite.SqliteConnection.get_State () [0x00000] in &lt;filename unknown&gt;:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in &lt;filename unknown&gt;:0 
  at ConfigDBManager.ExecuteCMD (System.String strSql) [0x00000] in &lt;filename unknown&gt;:0 
  at DataBaseAdapter.SelectAll[T] (System.String tableName, System.String keyName, Boolean IsEncrypt) [0x00000] in &lt;filename unknown&gt;:0 
  at BaseMapList.InitDictionary () [0x00000] in &lt;filename unknown&gt;:0 
  at BaseMapList.GetAllItems () [0x00000] in &lt;filename unknown&gt;:0 
  at LevelManager.InitLevelList () [0x00000] in &lt;filename unknown&gt;:0 
  at LevelManager.get_Instance () [0x00000] in &lt;filename unknown&gt;:0 
  at PlayerManager.CreateInstance (Int32 playerId) [0x00000] in &lt;filename unknown&gt;:0 
  at PlayerManager.LoadPlayer () [0x00000] in &lt;filename unknown&gt;:0 
  at GameStage.InitGameLogic () [0x00000] in &lt;filename unknown&gt;:0 

(Filename: currently not available on il2cpp Line: -1)

InvalidOperationException: No connection associated with this command

at Mono.Data.Sqlite.SqliteConnection.get_State () [0x00000] in <filename unknown>:0

at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0

at ConfigDBManager.ExecuteCMD (System.String strSql) [0x00000] in <filename unknown>:0

at DataBaseAdapter.SelectAll[T] (System.String tableName, System.String keyName, Boolean IsEncrypt) [0x00000] in <filename unknown>:0

at BaseMapList.InitDictionary () [0x00000] in <filename unknown>:0

at BaseMapList.GetAllItems () [0x00000] in <filename unknown>:0

at LevelManager.InitLevelList () [0x00000] in <filename unknown>:0

at LevelManager.get_Instance () [0x00000] in <filename unknown>:0

at PlayerManager.CreateInstance (Int32 playerId) [0x00000] in <filename unknown>:0

at PlayerManager.LoadPlayer () [0x00000] in <filename unknown>:0

at GameStage.InitGameLogic () [0x00000] in <filename unknown>:0

(Filename: currently not available on il2cpp Line: -1)

解决问题

原来是在执行这一段（创建角色引用到配置表信息）之前，没有加载配置表文件的读取。添加如下加载的就可以了。

//连接sqlite配置数据库
        StartCoroutine(ConfigDBManager.Instance.LoadDataAysnc());

//连接sqlite配置数据库

StartCoroutine(ConfigDBManager.Instance.LoadDataAysnc());

Binary operator ‘*’ cannot be applied to operands of type ‘CGPoint’ and ‘CGFloat’

查看了CGPoint属性，也是使用的CGFloat，但就是会出错，如下图：
CGFloat

解决问题：
突然想到可以找QQ群问啊，于是找到了问题，是要在CGPoin中的X和Y轴各自计算就不会出错。

网友发来的帮助文档：CGPoint+Extensions.swift

Apple Mach-O Linker (ld) Error Group

在Mac使用的Xcode8.x版本，最后导出时报错：

Apple Mach-O Linker (ld) Error Group
clang: error: linker command failed with exit code 1 (use -v to see invocation)

Apple Mach-O Linker (ld) Error Group

clang: error: linker command failed with exit code 1 (use -v to see invocation)

“_OBJC_CLASS_$_P31”, referenced from:

Undefined symbols for architecture arm64:
  "_OBJC_CLASS_$_P31", referenced from:
      objc-class-ref in libStoreKit.a(StoreKitManager.o)
     (maybe you meant: _OBJC_CLASS_$_P31Unity)
  "_OBJC_CLASS_$_MFMailComposeViewController", referenced from:
      objc-class-ref in ISN_SocialGate.o
ld: symbol(s) not found for architecture arm64
clang: error: linker command failed with exit code 1 (use -v to see invocation)

Undefined symbols for architecture arm64:

"_OBJC_CLASS_$_P31", referenced from:

objc-class-ref in libStoreKit.a(StoreKitManager.o)

(maybe you meant: _OBJC_CLASS_$_P31Unity)

"_OBJC_CLASS_$_MFMailComposeViewController", referenced from:

objc-class-ref in ISN_SocialGate.o

ld: symbol(s) not found for architecture arm64

clang: error: linker command failed with exit code 1 (use -v to see invocation)

就是这个总是，总是解决不掉，郁闷死了

clang: error: linker command failed with exit code 1 (use -v to see invocation)

这个问题，好像之前遇到过，没记录下来，晕。

ld: library not found for -liPhone-lib
clang: error: linker command failed with exit code 1 (use -v to see invocation)

ld: library not found for -liPhone-lib

clang: error: linker command failed with exit code 1 (use -v to see invocation)

解决办法一：
在Build Settings /Library Search Paths中 Libraries 的一项修改为：$(PROJECT_DIR)/Libraries，其默认还有两个引号注意要去除。
解决办法二：
在左侧Libraries文件夹中的libiPhone-lib.a删除，然后在Finder中找到此项目的这个文件，再把它拖进相应的位置即可。

Undefined symbols for architecture armv7:

2017.05.08

上次打包还正常的，这次一打包居然出现这一堆总是来，郁闷。原本还准备打几个包测试没问题就发布个版本的，看来又得被耽搁了。报出的几个错误如下：

 Undefined symbols for architecture armv7:
  "__ISN_ResolveConflictingSavedGames", referenced from:
      _ISN_GameSaves__ISN_ResolveConflictingSavedGames_m1312 in Bulk_Assembly-CSharp_0.o
     (maybe you meant: _ISN_GameSaves__ISN_ResolveConflictingSavedGames_m1312)
  "__ISN_LoadSaveData", referenced from:
      _ISN_GameSaves__ISN_LoadSaveData_m1313 in Bulk_Assembly-CSharp_0.o
     (maybe you meant: _ISN_GameSaves__ISN_LoadSaveData_m1313)
  "__ISN_FetchSavedGames", referenced from:
      _ISN_GameSaves__ISN_FetchSavedGames_m1310 in Bulk_Assembly-CSharp_0.o
     (maybe you meant: _ISN_GameSaves__ISN_FetchSavedGames_m1310)
  "__ISN_SaveGame", referenced from:
      _ISN_GameSaves__ISN_SaveGame_m1309 in Bulk_Assembly-CSharp_0.o
     (maybe you meant: _ISN_GameSaves__ISN_SaveGame_m1309)
  "__ISN_DeleteSavedGame", referenced from:
      _ISN_GameSaves__ISN_DeleteSavedGame_m1311 in Bulk_Assembly-CSharp_0.o
     (maybe you meant: _ISN_GameSaves__ISN_DeleteSavedGame_m1311)
ld: symbol(s) not found for architecture armv7
clang: error: linker command failed with exit code 1 (use -v to see invocation)

Undefined symbols for architecture armv7:

"__ISN_ResolveConflictingSavedGames", referenced from:

_ISN_GameSaves__ISN_ResolveConflictingSavedGames_m1312 in Bulk_Assembly-CSharp_0.o

(maybe you meant: _ISN_GameSaves__ISN_ResolveConflictingSavedGames_m1312)

"__ISN_LoadSaveData", referenced from:

_ISN_GameSaves__ISN_LoadSaveData_m1313 in Bulk_Assembly-CSharp_0.o

(maybe you meant: _ISN_GameSaves__ISN_LoadSaveData_m1313)

"__ISN_FetchSavedGames", referenced from:

_ISN_GameSaves__ISN_FetchSavedGames_m1310 in Bulk_Assembly-CSharp_0.o

(maybe you meant: _ISN_GameSaves__ISN_FetchSavedGames_m1310)

"__ISN_SaveGame", referenced from:

_ISN_GameSaves__ISN_SaveGame_m1309 in Bulk_Assembly-CSharp_0.o

(maybe you meant: _ISN_GameSaves__ISN_SaveGame_m1309)

"__ISN_DeleteSavedGame", referenced from:

_ISN_GameSaves__ISN_DeleteSavedGame_m1311 in Bulk_Assembly-CSharp_0.o

(maybe you meant: _ISN_GameSaves__ISN_DeleteSavedGame_m1311)

ld: symbol(s) not found for architecture armv7

clang: error: linker command failed with exit code 1 (use -v to see invocation)

正在查找原因。。。
排查：
通过在代码中搜索"__ISN_ResolveConflictingSavedGames",等，发现在是IOSNative这个插件里的代码，由此再一回想，肯定是IOSNativeSettings中之前做过的修改有关系，那时没事把Game Center和Social Sharing的勾给去了。
经再次打包测试，真是的以上的问题，OK 解决问题了。
真是没事找抽型的，呼！！！
总结
还有一个很值得注意的就是寻找答案的方法，在遇到这个问题时，前思后想都觉得没道具，怎么好好的，也没改哪里却突然遇到这种问题，一下子无从下手，搜遍百度也没有找到一样的答案，这时应该在报错的提示中仔细阅读，如__ISN_DeleteSavedGame 这个关键词，还有后面in Bulk_Assembly-CSharp_0.o 这段提示，表示在CSharp中，所以这个问题就可以到CSharp中搜索上面的那个关键词，一查找，再看一下cs文件的路径，就全然明白了，也马上想起了之前做过的哪些改动。

游戏中加载时无法读取数据库：InvalidOperationException: No connection associated with this command

在Unity编辑器中倒还是一切正常，但是Xcode中打包成功安装后，真机上却在加载进度条卡住了，具体内容如下，可以大体看出是数据库表加载的问题。

InvalidOperationException: No connection associated with this command
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader () [0x00000] in &lt;filename unknown&gt;:0 
  at BaseMapList.InitDictionary () [0x00000] in &lt;filename unknown&gt;:0 
  at BaseMapList.GetAllItems () [0x00000] in &lt;filename unknown&gt;:0 
  at LevelManager.InitLevelList () [0x00000] in &lt;filename unknown&gt;:0 
  at LevelManager..ctor () [0x00000] in &lt;filename unknown&gt;:0 
  at LevelManager.get_Instance () [0x00000] in &lt;filename unknown&gt;:0 
  at BattleManager.Update () [0x00000] in &lt;filename unknown&gt;:0 

(Filename: currently not available on il2cpp Line: -1)

InvalidOperationException: No connection associated with this command

at Mono.Data.Sqlite.SqliteCommand.ExecuteReader () [0x00000] in <filename unknown>:0

at BaseMapList.InitDictionary () [0x00000] in <filename unknown>:0

at BaseMapList.GetAllItems () [0x00000] in <filename unknown>:0

at LevelManager.InitLevelList () [0x00000] in <filename unknown>:0

at LevelManager..ctor () [0x00000] in <filename unknown>:0

at LevelManager.get_Instance () [0x00000] in <filename unknown>:0

at BattleManager.Update () [0x00000] in <filename unknown>:0

(Filename: currently not available on il2cpp Line: -1)

问题的原因已找到：是因为在登陆界面引用了baseTable只读数据库的问题，去除读取这类数据库，改用其它方式实现功能，如此解决问题。至于为什么会读取这类数据库表会出错，可能是还没生成出数据库表就开始要读取了的原故吧。

Apple Mach-O Linker (Id) Error Linker command failed with exit code 1

在新MAC上打包出现问题如下：
Apple Mach-O Linker (Id) Error

Linker command failed with exit code 1

解决方法：

进入项目TARGETS/选择您的项目

General/Deployment Info/Deployment Target 在此选择了8.0版本

可能是使用的Xcode8.x的原因，5.1.1版本无法正常打包，显示最低版本为基础8.0

调试时报错(Filename: currently not available on il2cpp Line: 4294967295)

打包安装都正常，但进入游戏后读取数据库信息时吧，就停住无法继续进度条了。以下为Xcode中的日志。

InvalidOperationException: No connection associated with this command
  at Mono.Data.Sqlite.SqliteConnectionHandle.op_Implicit (IntPtr db) [0x00000] in <filename unknown>:0 
  at Mono.Data.Sqlite.SqliteCommand.InitializeForReader () [0x00000] in <filename unknown>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader () [0x00000] in <filename unknown>:0 
  at ConfigDBManager.ExecuteCMD (System.String strSql) [0x00000] in <filename unknown>:0 
  at DataBaseAdapter.SelectAll[T] (System.String tableName, System.String keyName, Boolean IsEncrypt) [0x00000] in <filename unknown>:0 
  at BaseMapList.InitDictionary () [0x00000] in <filename unknown>:0 
  at BaseMapList.GetAllItems () [0x00000] in <filename unknown>:0 
  at LevelManager.InitLevelList () [0x00000] in <filename unknown>:0 
  at LevelManager..ctor () [0x00000] in <filename unknown>:0 
  at LevelManager.get_Instance () [0x00000] in <filename unknown>:0 
  at PlayerManager.CreateInstance (Int32 playerId) [0x00000] in <filename unknown>:0 
  at PlayerManager.LoadPlayer (Int32 playerId) [0x00000] in <filename unknown>:0 
  at GameStage.InitGameLogic () [0x00000] in <filename unknown>:0 
  at GameStage.Do () [0x00000] in <filename unknown>:0 
  at GameStage.Enter () [0x00000] in <filename unknown>:0 
  at StageManager.ChangeStage (.BaseStage nextStage) [0x00000] in <filename unknown>:0 
  at UpdateStage.InitApp () [0x00000] in <filename unknown>:0 
  at UpdateStage.Update () [0x00000] in <filename unknown>:0 
 
(Filename: currently not available on il2cpp Line: 4294967295)

InvalidOperationException: No connection associated with this command

at Mono.Data.Sqlite.SqliteConnectionHandle.op_Implicit (IntPtr db) [0x00000] in <filename unknown>:0

at Mono.Data.Sqlite.SqliteCommand.InitializeForReader () [0x00000] in <filename unknown>:0

at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0

at Mono.Data.Sqlite.SqliteCommand.ExecuteReader () [0x00000] in <filename unknown>:0

at ConfigDBManager.ExecuteCMD (System.String strSql) [0x00000] in <filename unknown>:0

at DataBaseAdapter.SelectAll[T] (System.String tableName, System.String keyName, Boolean IsEncrypt) [0x00000] in <filename unknown>:0

at BaseMapList.InitDictionary () [0x00000] in <filename unknown>:0

at BaseMapList.GetAllItems () [0x00000] in <filename unknown>:0

at LevelManager.InitLevelList () [0x00000] in <filename unknown>:0

at LevelManager..ctor () [0x00000] in <filename unknown>:0

at LevelManager.get_Instance () [0x00000] in <filename unknown>:0

at PlayerManager.CreateInstance (Int32 playerId) [0x00000] in <filename unknown>:0

at PlayerManager.LoadPlayer (Int32 playerId) [0x00000] in <filename unknown>:0

at GameStage.InitGameLogic () [0x00000] in <filename unknown>:0

at GameStage.Do () [0x00000] in <filename unknown>:0

at GameStage.Enter () [0x00000] in <filename unknown>:0

at StageManager.ChangeStage (.BaseStage nextStage) [0x00000] in <filename unknown>:0

at UpdateStage.InitApp () [0x00000] in <filename unknown>:0

at UpdateStage.Update () [0x00000] in <filename unknown>:0

(Filename: currently not available on il2cpp Line: 4294967295)

收集的参考资料，暂时还不知原因所在：

IL2CPP INTERNALS – DEBUGGING TIPS FOR GENERATED CODE

Xcode iOS9.3 配置包更新

在Finder状态下前往文件夹，快捷键：shift+command+G，填写路径/Applications/Xcode.app/Contents/Developer/Platforms/iPhoneOS.platform/DeviceSupport

Xcode IOS9.3配置包下载链接：http://pan.baidu.com/s/1pL6AESz