Attempted to restore an MBOX from Google Takeout, got a Datatype Mismatch, PYI-43328:ERROR unhandled exception.

[mndudek]

Using this command-line:

gyb --email destination@email.address --action restore-mbox --local-folder "C:\Path\to\mbox\folder" --label-restored "eSolRestored"

It said "Restoring from 4.07gb file C:\Path\to\mbox\folder\All mail Including Spam and Trash.mbox..." but restored only one email item and then failed with this message below. What is the fix, what could be wrong? The MBOX file was created by the Google Takeout of a different Gmail account, and I'm trying to restore them to another, different Gmail account.

Traceback (most recent call last):
File "gyb.py", line 2914, in
File "gyb.py", line 2631, in main
File "gyb.py", line 813, in callGAPI
File "googleapiclient_helpers.py", line 130, in positional_wrapper
File "googleapiclient\http.py", line 1604, in execute
File "gyb.py", line 1772, in restored_message
sqlite3.IntegrityError: datatype mismatch
[PYI-43328:ERROR] Failed to execute script 'gyb' due to unhandled exception!

[voltron007]

@mndudek I'm having the same problem.

The author's Wiki states, "If you get this when trying to use gyb --email [address] --action restore-mbox --local-folder [folder] then try delete your local folder first." This advice makes ZERO sense to me as my understanding is that the "local folder," in this case, would be the location where the files to restore from reside. Deleting this folder would delete my mbox file and if I were to move my mbox file elsewhere to avoid deleting it, what then would be considered my "local folder" at that point?

Fearing I may be missing something, I checked to see if there was a special "delete" switch for use with the gyb command that would apply magic pixie dust to the situation, but that doesn't appear to be the case.

@jay0lee Could you explain what you meant regarding deleting the local folder first or possibly offer additional guidance?

[celogan13]

I had this same issue - turns out you just want to delete any SQLite file that's in the local-folder.