【技术问题】 – 东风吹

Max怪物导出FBX后骨骼朝向问题

怪物的动作中包含待机、攻击、受击、死亡和跑以及蒙皮模型。
怎么调整都是怪物朝上（如下图）

主要修改蒙皮的模型即可，一开始怎么导出，以及在FBX导出设置中也是没有效果。

后来才发现，原来有处理好的蒙皮文件，不同之处只是文件中多了个“点辅助对象”，半信半疑加了个点辅助上去，导出一试，原来真的就这么简单，吐血。

一切就正常了（如下图）

游戏中NGUI图集会闪的问题

近期的出的战斗界面图集会闪的问题，已经出现2个多月了，一直没解决，头疼又一时无从下手，有考虑过是不是图集太大，影响内存？还是动态加载图集时有异样？

今天在导出设置的Other Settings/Configuration中的Graphics API选项修改为Open GL ES2.0，然后导出Xcode包测试，嘿，居然就没再出现闪的问题了，起码已经测试N遍了。

Navicat Premium中表出现sqlite_sequence无法删除的原因

1-table sqlite_sequence may not be dropped

table sqlite_sequence may not be dropped

删除不需要的表时，出现如上图的弹出提示信息，一直以来让人头疼啊。
sqlite_sequence无法删除表的问题
就是上面这个表，之前遇到过，哪怕是重新创建一个db3文件，再把另一个表中的其它内容表复制过来后，也还是会出现，后来我是一个一个表进行复制，发现有些表复制过来是不会出现这种情况，而单独table_message复制过来时，就自动添加了这么个不需要的表，打开表结构一看，跟其它表唯一不一样的就是自动递增被勾选上了，那问题肯定就出在这里了，果然，把勾选去掉，再复制过来，一切OK，原来如此。
sqlite_sequence无法删除表的问题1

SqliteException: SQLite error near “,”: syntax error无法读取数据库

使用Unity5.3.3的，以前有使用过能正常使用，但现在又无语了，居然读取数据库时，出现这个问题，一下子无从下手啊！
SqliteException: SQLite error near ",": syntax error Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, UInt32 timeoutMS, System.String& strRemain) Mono.Data.Sqlite.SqliteCommand.BuildNextCommand ()

解决问题

在朋友的帮助一下，从出现这个问题的地方一步步查找，整了半天时间，终于知道问题所在了，并非是通过生成脚本的工具有问题，也不是sqlite的插件问题，而是出自预置的Sql的其中一个表有问题，即下图，没把加密的md5放在最后一列，因为他创建和连接数据库表时，是在md5后面加上)号作为结尾，现在却因为其它放在最后，结果就出现SQLite error near ","这个错误了，排查出后问题就解决。

在这一过程中，一个方式方法的问题需要总结，因为自己遇到问题，总是各种情况猜想然后去试图查找答案，结果往往是盲打莽撞，事倍功半，应该纠正过来，从出现问题的地方一步步查找，这才是科学的方式。

sql文件转换二进制的问题

之前尝试了好久，没成功，可能就是因为没有关闭连接数据库的问题，今天是先试了一下txt文本，可以正常转换，然后转换sql文件就不行，原来重启Unity软件，还没使用当前sql时，还是可以转换的，贴上以下代码。

void OnGUI()
    {
        if (GUI.Button(new Rect(10, 10, 150, 30), "转换成Byte"))
        {
            OnToByte();
        }

    }

    private byte[] byobj;
    public void OnToByte()
    {
        string url2 = Application.persistentDataPath + "/StreamingAssets/GameData/sygame.db3";
        string closeurl = Application.dataPath + "/StreamingAssets" + GameDBManager.databaseRelUrl;
        //GameDBManager.Instance.CloseConn(closeurl);
        GameDBManager.Instance.Disconnect();
        byobj = File2Bytes(url2);
        Logger.Log("///转换二进制" + byobj.Length);

        Bytes2File(byobj, Application.persistentDataPath + "/StreamingAssets/GameData/out11.db3");
        Logger.Log("///转换成文件成功");
        GameDBManager.Instance.InitConn(closeurl);
    }
    public static byte[] File2Bytes(string path)
    {
        if (!File.Exists(path))
        {
            return new byte[0];
        }

        FileInfo fi = new FileInfo(path);
        byte[] buff = new byte[fi.Length];

        FileStream fs = fi.OpenRead();
        fs.Read(buff, 0, Convert.ToInt32(fs.Length));
        fs.Close();

        return buff;
    }
    public static void Bytes2File(byte[] buff, string savepath)
    {
        if (File.Exists(savepath))
        {
            File.Delete(savepath);
        }

        FileStream fs = new FileStream(savepath, FileMode.CreateNew);
        BinaryWriter bw = new BinaryWriter(fs);
        bw.Write(buff, 0, buff.Length);
        bw.Close();
        fs.Close();
    }

void OnGUI()

{

if (GUI.Button(new Rect(10, 10, 150, 30), "转换成Byte"))

{

OnToByte();

}

private byte[] byobj;

public void OnToByte()

{

string url2 = Application.persistentDataPath + "/StreamingAssets/GameData/sygame.db3";

string closeurl = Application.dataPath + "/StreamingAssets" + GameDBManager.databaseRelUrl;

//GameDBManager.Instance.CloseConn(closeurl);

GameDBManager.Instance.Disconnect();

byobj = File2Bytes(url2);

Logger.Log("///转换二进制" + byobj.Length);

Bytes2File(byobj, Application.persistentDataPath + "/StreamingAssets/GameData/out11.db3");

Logger.Log("///转换成文件成功");

GameDBManager.Instance.InitConn(closeurl);

}

public static byte[] File2Bytes(string path)

{

if (!File.Exists(path))

{

return new byte[0];

}

FileInfo fi = new FileInfo(path);

byte[] buff = new byte[fi.Length];

FileStream fs = fi.OpenRead();

fs.Read(buff, 0, Convert.ToInt32(fs.Length));

fs.Close();

return buff;

}

public static void Bytes2File(byte[] buff, string savepath)

{

if (File.Exists(savepath))

{

File.Delete(savepath);

}

FileStream fs = new FileStream(savepath, FileMode.CreateNew);

BinaryWriter bw = new BinaryWriter(fs);

bw.Write(buff, 0, buff.Length);

bw.Close();

fs.Close();

}

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)

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

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