SQLException on Merge.java:71

[AshleyKwan]

Hi,

Thanks you you share this app for merge WhatsApp database. Here is very helpful for me to combine many message database.

But it throws SQL exception on Merge.java:71. There is the inserting contact into table chat_list while in run-time if the contact subject included single quote symbol.

`java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "s": s
yntax error)
at org.sqlite.core.DB.newSQLException(DB.java:890)
at org.sqlite.core.DB.newSQLException(DB.java:901)
at org.sqlite.core.DB.throwex(DB.java:868)
at org.sqlite.core.NativeDB.prepare(Native Method)
at org.sqlite.core.DB.prepare(DB.java:211)
at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:60)
at com.merjapp.SQLiteJDBC.executeUpdate(SQLiteJDBC.java:61)
at com.merjapp.Merge.executeUpdate(Merge.java:72)
at com.merjapp.Merge.mergeChatListTable(Merge.java:333)
at com.merjapp.Merge.doMerge(Merge.java:139)
at com.merjapp.Merge.main(Merge.java:428)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoa
der.java:58)

ERROR on query:
INSERT INTO chat_list (key_remote_jid, message_table_id, subject, creation, last
read_message_table_id, last_read_receipt_sent_message_table_id, archived, sort
timestamp) VALUES ('###########-##########@g.us', 120235, 'XXXXXXX's Group', 1494497486000, 0, 0, 0, 1527743657000)

Done!`