waicool20/mr2tachiyomi

Import your Mangarock favorites to Tachiyomi

MR2Tachiyomi

A simple tool that takes MangaRocks database and outputs a file that you can import using the backup restore tool in Tachiyomi.

Only supports Android version of MangaRock.

Currently only supports the sources MangaRock, MangaEden, MangaReader.

Usage

Currently the steps are very technical and might be complicated for the typical user, be aware!

Pre-requisites:

• Java 8
• MR2Tachiyomi Application Jar
• Tachiyomi and extensions (Download in-app)

Method 1: Using mangarock.db (Rooted devices only)

1. Find and copy the mangarock.db file on your android device to your PC

   • File is located in the directory root:/data/data/com.notabasement.mangarock.android.lotus/databases

2. Run MR2Tachiyomi Application Jar (Double click the jar) and open the copied mangarock.db file.
   Click Run and choose a save location for the output file (Read below for more details).

Optionally for those wanting to use the command line instead of GUI:

java -jar mr2tachiyomi.jar -i /path/to/mangarock.db -o /path/to/output.json

3. After running there will be a new file created which can be imported into Tachiyomi using the backup restore feature in the settings menu. Note: MangaRock or other relevant Tachiyomi source extensions must be installed, or else the import will fail.

Method 2: Using Helium Backup (Both Non-Rooted or Rooted devices)

1. Backup MangaRock using Helium Backup

2. Copy the file
   sdcard:/carbon/com.notabasement.mangarock.android.lotus/com.notabasement.mangarock.android.lotus.ab
   to your pc

3. Run MR2Tachiyomi Application Jar (Double click the jar) and open the copied com.notabasement.mangarock.android.lotus.ab file.
   Click Run and choose a save location for the output file (Read below for more details).

Optionally for those wanting to use the command line instead of GUI:

java -jar mr2tachiyomi.jar -i /path/to/androidbackup.ab -o /path/to/output.json

4. After running there will be a new file created which can be imported into Tachiyomi using the backup restore feature in the settings menu. Note: MangaRock or other relevant Tachiyomi source extensions must be installed, or else the import will fail.

File output

Change the output file name to get the desired format:

• Tachiyomi Backup Json -> output.json
• CSV List File -> output.csv or output.txt

Troubleshooting

Having problems with Helium on PC?

Try using the Chromium extension instead

I'm getting some kind of SQLite error!

The tool decodes a mangarock.db file out of the backup ab file, if it's 0kb in size then you have a bad backup.

Credits

• Original C reference implementation for Android Backup to Tar algorithm: https://github.com/floe/helium_ab2tar

mr2tachiyomi's Issues

Part 1 Between Step 5 and 6

Hi, I am currently using a Android device and just can't seem to connect the mobile and Pc version of helium no matter how much i try. It just say "Waiting for Device" and does not connect. Already tried to follow the link below. Can u help me with it??

I cannot find the "mangarock.db" file in the directory

Hello,
I want to copy the mangarock.db file from the com.mangarock.mangarock.mangarock.mangarock.android.lotus/ directory, but I don't see any file or folder that resembles it.
Do you have any ideas?

A screenshot of my folder :

Restore has 375 errors out of around 380 mangas - "Value Unknown Query Version"

The conversion went swimmingly up until I attempted to restore the .json file. At that point, out of the ~387 manga, roughly 375 of them returned errors. Most of them were the following:

Value Unknown Query Version at data of type java.lang.String cannot be converted to JSONObject

I've attached my conversion log, my json (named as a txt file in order to upload), and my restore log
mr2tachiyomi.log
MRBackupJSON.txt
tachiyomi_restore.log.txt

mr2tachiyomi.jar not responding

When running the com.notabasement.mangarock.android.lotus.ab file with the mr2tachiyomi.jar file the program stops responding. It happens right after choosing where to save the .json file. I have restarted and tried to rerun with the same outcome. Not sure what else I should do to make it work. Let me know if I should include any more information

Processed 0 Manga

I'm using MacOs with Java 8 installed. I also used Helium to retrieved my Mangarock.db but it doesn't process anything.
mr2tachiyomi.log

Conversion Failed

Error: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or
missing database (dulicate column name: _id)
See logs for more information
This is what i get when i click run. I can't find any logs and i don't get a .JSON file. This is all the information i can find.

iam double clicking but it is not opening am i doing something wrong ?

iam double clicking the jar file but it aint opening only a text file generated in the same folder

Could not convert database file to json due to unknown exception

Error trying to convert Helium Backup

java.lang.NumberFormatException: For input string: "??,O?'_?h??"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at com.waicool20.mr2tachiyomi.util.ABUtils.correctHeaders(ABUtils.kt:131)
at com.waicool20.mr2tachiyomi.util.ABUtils.processFile(ABUtils.kt:87)
at com.waicool20.mr2tachiyomi.util.ABUtils.ab2tar(ABUtils.kt:40)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.extractDbFromAb(MR2Tachiyomi.kt:106)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:87)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)

Failed Conversion database

my conversion fail because of this error: Unsupported source: 2
here the log

mr2tachiyomi.log

Conversion Failed

[MR2Tachiyomi] [2020-02-22 16:09:51] [c.w.m.MR2Tachiyomi] ERROR - Could not convert database file to json due to unknown exception
java.lang.NumberFormatException: For input string: "?�?>??�????"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at com.waicool20.mr2tachiyomi.util.ABUtils.correctHeaders(ABUtils.kt:131)
at com.waicool20.mr2tachiyomi.util.ABUtils.processFile(ABUtils.kt:87)
at com.waicool20.mr2tachiyomi.util.ABUtils.ab2tar(ABUtils.kt:40)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.extractDbFromAb(MR2Tachiyomi.kt:106)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:87)
at com.waicool20.mr2tachiyomi.MainView$onDock$2.handle(UserInterface.kt:72)
at com.waicool20.mr2tachiyomi.MainView$onDock$2.handle(UserInterface.kt:32)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Node.fireEvent(Node.java:8411)
at javafx.scene.control.Button.fire(Button.java:185)
at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:394)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:432)
at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:410)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:431)
at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
at com.sun.glass.ui.View.notifyMouse(View.java:937)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.lambda$null$3(WinApplication.java:177)
at java.lang.Thread.run(Unknown Source)

mr2tachiyomi not doing anything

I have Java, and clicking your jar file does nothing. Command line doesn't work either. The link you provided to Java 8 is dead so I don't know if that's the problem since I have a different version of Java.

Issue with creating the json file

Hi,

I'm getting the following error when trying to convert the file into json:
[MR2Tachiyomi] [2020-04-22 17:21:49] [Exposed] WARN - Transaction attempt #0 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted
[MR2Tachiyomi] [2020-04-22 17:21:49] [Exposed] WARN - Transaction attempt #1 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted
[MR2Tachiyomi] [2020-04-22 17:21:49] [Exposed] WARN - Transaction attempt #2 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted

MR2Tachiyomi Failing to open

When I try to run the programm nothing happens, besides an empty log file being created. I tried both double clicking and command line, but in both cases it didnt open.
Tried MR2Tachiyomi 1.4.0 and 1.2.0.
WIn10, Java8 Update 221 (build 1.8.0_221-b11)

Step 8 : conversion failed

When I do step 8, after running the .ab file, I can't get the .json file because of a "sql lite error or missiing database"

When I run though, I do get a .tar archive file and a .db file ^^'

Issue while creating Json file

I'm getting error as per screenshot attached, when trying to run through Command prompt. When trying through run through opening the .jar file, I get similar error as below:

[MR2Tachiyomi] [2020-03-10 21:01:35] [c.w.m.MR2Tachiyomi] ERROR - Could not convert database file to json due to unknown exception
java.lang.NumberFormatException: For input string: "8wWv ?m�?"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at com.waicool20.mr2tachiyomi.util.ABUtils.correctHeaders(ABUtils.kt:131)
at com.waicool20.mr2tachiyomi.util.ABUtils.processFile(ABUtils.kt:87)
at com.waicool20.mr2tachiyomi.util.ABUtils.ab2tar(ABUtils.kt:40)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.extractDbFromAb(MR2Tachiyomi.kt:106)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:87)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)

Please advise.

Helium doesn't backup

Every time I press the backup button it says backup failed

Stuck on step 3

Hi, I'm stuck at step 3 for non-rooted device. How do I open MR2tachiyomi application jar? sorry I'm new to this

License error while trying to restore backup json

I am getting the following error when I am restoring the backup json created by this tool in Tachiyomi.
[Date Time] <manganame> - Value Manga is licensed at data of type java.lang.String cannot be converted to JSONObject
While restoring, I got 43 errors and the error log is showing the above error statement for 43 of my favourited mangas. It seems like MR has removed some mangas from the website due to copyright strike. Is there a possible workaround for this.
tachiyomi_restore.log.pdf

.Jar File Issue. Won't Open Correctly?

When running the .jar file, all that opens is an empty text file. How can I fix this?

Log file

After converting it said that 2 manga were not able to be converted and to check the log file. Where is this file located because figuring out which 2 of the 800ish manga I have favorited will be a royal pain.

Conversion failed Error Null v1.3.0

Multiple attempts, same error. Unrooted. AppDataOnly is unchecked. No encryption enabled.
Log:
[MR2Tachiyomi] [2020-01-07 10:43:49] [c.w.m.MR2Tachiyomi] ERROR - Could not convert database file to json due to unknown exception
kotlin.KotlinNullPointerException: null
at org.jetbrains.exposed.dao.Entity.lookup(Entity.kt:282)
at org.jetbrains.exposed.dao.Entity.getValue(Entity.kt:268)
at com.waicool20.mr2tachiyomi.models.database.Favorite.getMangaOid(Favorites.kt)
at com.waicool20.mr2tachiyomi.models.database.Favorite.toString(Favorites.kt:58)
at java.lang.String.valueOf(Unknown Source)
at java.lang.StringBuilder.append(Unknown Source)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:51)
at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MainView$onDock$2.handle(UserInterface.kt:72)
at com.waicool20.mr2tachiyomi.MainView$onDock$2.handle(UserInterface.kt:32)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Node.fireEvent(Node.java:8413)
at javafx.scene.control.Button.fire(Button.java:185)
at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:381)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$354(GlassViewEventHandler.java:417)
at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:416)
at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
at com.sun.glass.ui.View.notifyMouse(View.java:937)
at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
at com.sun.glass.ui.win.WinApplication.lambda$null$148(WinApplication.java:191)
at java.lang.Thread.run(Unknown Source)

Issue with file

I am not sure if I am using the file correctly but this is what happened. When I downloaded the file and opened it with Java 8, I tried to press run but it wanted me to open something first so I opened the .ab file thinking this was what it wanted, but then when I pressed run it asked for anothher file but none came up for me to run. I figured I needed it to open something else so I could run the .ab file instead but I could't figure out what that thing was.

mangarock can't show chapter

https://api.mangarockhd.com/query/web401/pages?oid=mrs-chapter-200260585

Today, when I use the api, I get this error : "{"code":0,"data":[]}"

Do you know how to fix it?

Add cli options

As preparation for the CSV export option command line arguments should be parsed. The addition of options to specify input and output files would also make mr2tachiyomi somewhat more user frendly.

Conversion error due to empty Author field

mangarock.db.zip
hello i got an issue and it is that my favorites are all from mangarock
but the program says unsupported source

mr2tachiyomi.log

Add CSV export

The format of the CSV would need to be chosen. The same format as the json would be the easiest but, depending on the intended use of the CSV, that might not suffice.

Is the same format as the json fine or did you have another format in mind?

databases folder in the directory

I can't find it in my android device, there is only cache and files folder

Conversion failed

Hi Dev! I tried converting the file, but I got a conversion fail - here are the log details, please help! ><

mr2tachiyomi.log

SQL Error when trying to import ab file.

[MR2Tachiyomi] [2019-12-09 20:32:22] [Exposed] WARN - Transaction attempt #0 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:37)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:31)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.CsvConverter.convert(CsvConverter.kt:36)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted
[MR2Tachiyomi] [2019-12-09 20:32:22] [Exposed] WARN - Transaction attempt #1 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:37)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:31)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.CsvConverter.convert(CsvConverter.kt:36)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted
[MR2Tachiyomi] [2019-12-09 20:32:22] [Exposed] WARN - Transaction attempt #2 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:37)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:31)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.CsvConverter.convert(CsvConverter.kt:36)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted
[MR2Tachiyomi] [2019-12-09 20:32:22] [c.w.m.MR2Tachiyomi] ERROR - Could not convert database file to csv due to unknown exception
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:37)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:31)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.CsvConverter.convert(CsvConverter.kt:36)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 common frames omitted
org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
SQL: [CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)]
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:37)
at com.waicool20.mr2tachiyomi.converters.CsvConverter$convert$1.invoke(CsvConverter.kt:31)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
at com.waicool20.mr2tachiyomi.converters.CsvConverter.convert(CsvConverter.kt:36)
at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
at org.sqlite.core.DB.newSQLException(DB.java:941)
at org.sqlite.core.DB.newSQLException(DB.java:953)
at org.sqlite.core.DB.throwex(DB.java:918)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:47)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:19)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
... 19 more

Invalid backup file

Getting this error when trying to restore the backup
Invalid backup file java.ioEOFException: End of input at line 61138 column 11 path $.mangas[328].chapters[15].r

mangarockbackups.zip

Helium backup issue

Hi, I cant backup MR on helium as there is always an error while performing the backup. I have cleared cache and deleted downloaded manga already as well.

Cmd says jar file was unable to be accessed

I tried double clicking the file and it just immediately closes. I then ran the prompt and it says that the .jar file was unable to be accessed. I have java 8 from oracle so im not sure what to do.

Tar file

When I name the output file as output.json, the file always comes out as com.notabasement.mangarock.android.lotus.tar, not as output.json. Renaming doesn't work and I don't know how to change the file to json, any ideas?