问题描述
本帖最后由 sun_ios 于 2015-5-9 16:30 编辑 打开聊天界面的时候 有一些历史聊天信息 出这种错误2015-05-09 16:10:51.502 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.578 liaotian Unknown error finalizing or resetting statement (19: column messageId is not unique)2015-05-09 16:10:51.581 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.597 liaotian Unknown error calling sqlite3_step (19: column messageId is not unique) eu2015-05-09 16:10:51.600 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.604 liaotian Unknown error finalizing or resetting statement (19: column messageId is not unique)2015-05-09 16:10:51.608 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.614 liaotian Unknown error calling sqlite3_step (19: column messageId is not unique) eu2015-05-09 16:10:51.616 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.618 liaotian Unknown error finalizing or resetting statement (19: column messageId is not unique)2015-05-09 16:10:51.620 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.629 liaotian Unknown error calling sqlite3_step (19: column messageId is not unique) eu2015-05-09 16:10:51.631 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:10:51.634 liaotian Unknown error finalizing or resetting statement (19: column messageId is not unique)2015-05-09 16:10:51.636 liaotian DB Query: INSERT INTO 'MessageV1' ('messageId','conversationChatter','mfrom','mto','isGroup','groupSenderName','requireBeforeSend','requireOnServer','deliveryState','messageBodies','ext','mtimestamp','isRead','isReadAcked','isDeliveredAcked','isAnonymous') VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)2015-05-09 16:13:38:745 liaotian XMPPStream::keepAlive -- did send blank ping.2015-05-09 16:13:38:746 liaotian XMPPStream: socket:didWriteDataWithTag:
解决方案
是我哪没整好么。。还是什么情况。
解决方案二：
你是做了什么操作么
解决方案三：
参考新版demo 搜updateMessageExtToDB 对应到你代码里的位置 替换成这个。猜测你是因为这个 可以试试
解决方案四：
谢谢 按你的方法解决了。