IOS开发者 – 东风吹

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());

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文件的路径，就全然明白了，也马上想起了之前做过的哪些改动。

IOS审核发邮件说要来电话讨论应用程序

昨天半夜打来一个美国的电话，没认真看，以为又是骚扰电话就没接，第二天才看到原来是要打电话来沟通APP应用的问题，晕，又错过了一天时间。

原文如下：

继续阅读“IOS审核发邮件说要来电话讨论应用程序”

苹果开发者中沙盒测试帐号的问题

最好不要把自己常用的apple id添加进去，其实沙盒测试帐号只需随便写个帐就行，可以包括不存在的邮箱帐号。如果用真实的Apple ID的话，容易混乱，我就是已经用了两个使用的帐号，测试完后删除掉，就再加添加不回来了。

建议还是随便填写一个不存在的帐号吧，进入游戏中测试内购买时使用就好了。

2016.04015

加速审核也确实够速度

元数据被拒绝后，把问题解决后，重新上传，申请了一个加速审核，下午上传并提交的，晚上12点多就进入审核了，次日早上已经审核通过，这真的是意料之外，当然这是例外，不可能每次都有这样的情况，网上有说是一年可以有几次这样的例外吧。

加速审核

第二天就把它《火星保卫战》上线了。

2016.04.13

IOS恢复购买的问题

第二次审核，还是遇到相同的有关内购买中“恢复购买”的问题。暂时的解决办法是先去掉NoAds这个功能。

Missing restore mechanism

We found that your app offers In-App Purchase(s) that can be restored but does not include a “Restore Purchases” feature to allow users to restore the previously purchased In-App Purchase(s), as specified in the “Restoring Purchase Products” section of the In-App Purchase Programming Guide

“Users restore transactions to maintain access to content they’ve already purchased. For example, when they upgrade to a new phone, they don’t lose all of the items they purchased on the old phone. Include some mechanism in your app to let the user restore their purchases, such as a Restore Purchases button.”

To restore previously purchased In-App Purchase products, it would be appropriate to provide a “Restore” button and initiate the restore process when the “Restore” button is tapped by the user.

以及提到的一个细节，不支持更多设备分辨率的问题，可能是两边我用了黑边，在Ipad中看到的是黑边，以为不支持多设备的原因。

– Your app was not optimized to support the device screen size or resolution.

Specifically, your app is displayed the black bars on the sides of the screen when run on the iPad.

2016.04.12

继续阅读“IOS恢复购买的问题”

AdmobUnityPlugin打包时出错注意的问题

正在寻找答案中，都是按照说明做的，DEMO打包出IOS时会出错，不知为何。

网上查找了一下原因，说是Unity版本的问题，于是特意在MAC中安装Unity5.3试了一下打包到Xcode，居然真的可以了。因为是用另一台苹果机上打的包，在Xcode中又卡壳了，可能跟机器有关。

搞了快一整了，终于搞定了。现在总结一下遇到的问题：

1、Unity版本要5.x以上，我测试时是5.3版本。

2、把Admob中的Banner和插屏广告ID添加进入脚本中。

2、Xcode中打包前要添加上以下Framework内容。

AdSupport
AudioToolbox
AVFoundation
CoreGraphics
CoreMedia
CoreTelephony
EventKit
EventKitUI
MessageUI
StoreKit
SystemConfiguration

然后打包Demo就可以了。

参考文章：

插件下载：https://github.com/unity-plugins/Unity-Admob#downloads-admob-unity-plugin

http://bbs.51cto.com/thread-1317983-1.html

【Unity】Unity-Admob谷歌广告插件

安装包以及使用说明的下载链接：https://github.com/unity-plugins/Unity-Admob

https://github.com/unity-plugins/Unity-Admob/wiki

IOS证书过期的问题

Xcode打包保存到本地时出现一个对话框，搜索了一下说都是说证书过期的问题，于是先更新证书。

IOS证书过期的问题1

一开始一直是在删除自己的证书，然后下载本地再更新上去，发现不行，原来是要删除系统的证书。

删除后，再看一下自己的证书，已经变成绿色了，呵呵。

终于可以导出IPA格式的安装文件了，记得要升级MAC系统。就O了!

搜索的参考网址：iOS开发证书”此证书的签发者无效”解决方法

从2月14号开始，上传AppStore会碰到：Failed to locate or generate matching signing assets

【Unity】解决NGUI的TweenPosition运行游戏时行动播放的问题

这个问题困扰了我好久，IOS上传了两个游戏都还存在这个问题，在搜索时看到别人的代码有这样，自己试了一下，原来答案就这么简单：就是在开始中把这个开关关闭即可。看下面的代码。

	public TweenPosition jieSuanUI;

	void Start () {
		jieSuanUI.enabled=false;//在开始中添加这个行代码，游戏运行时不自动播放
	}
	public void Pause()
	{
		jieSuanUI.enabled=true;//有需要播放时，打开这个开关即可。
		jieSuanUI.PlayForward();
	}

	public void CloseJieSuanUI()
	{
		jieSuanUI.PlayReverse();
	}

public TweenPosition jieSuanUI;

void Start () {

jieSuanUI.enabled=false;//在开始中添加这个行代码，游戏运行时不自动播放

}

public void Pause()

{

jieSuanUI.enabled=true;//有需要播放时，打开这个开关即可。

jieSuanUI.PlayForward();

}

public void CloseJieSuanUI()

{

jieSuanUI.PlayReverse();

}