Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom

transfer_name column not present in Attachments table #54

Closed
themorgantown opened this issue Jan 11, 2023 · 5 comments · Fixed by #55
Closed

transfer_name column not present in Attachments table #54

themorgantown opened this issue Jan 11, 2023 · 5 comments · Fixed by #55
Assignees
@ReagentX
Labels
bug Something isn't working crate: database Related to the database crate table Related to table data

Comments

@themorgantown
Copy link

Thanks for making this. I wish I could give you a slice of 🍰

After running:

imessage-exporter -f html
Building cache...
[1/4] Caching chats...
[2/4] Caching chatrooms...
[3/4] Caching participants...
[4/4] Caching reactions...
Cache built!
Exporting to /Users/myusername/imessage_export as html...

I get this error:

Unable to launch: Failed to parse row: Invalid column type Null at index: 12, name: transfer_name

Any other debugging info I can share?
@ReagentX
Copy link
Owner

ReagentX commented Jan 11, 2023 •
edited
Loading

Seems like your iMessage database doesn't have the transfer_name column in the attachments table. That data is required currently:

imessage-exporter/imessage-database/src/tables/attachment.rs

Line 38 in 8bc5c9a

pub transfer_name: String,

imessage-exporter/imessage-database/src/tables/attachment.rs

Line 51 in 8bc5c9a

transfer_name: row.get("transfer_name")?,

To fix that, I need to either set a default for that column or make it optional.

How old is this database? All of mine going back to 2011 have this column.

@ReagentX ReagentX changed the title Error Message transfer_name column not present in Attachments table Jan 11, 2023
@ReagentX ReagentX added bug Something isn't working crate: database Related to the database crate table Related to table data labels Jan 11, 2023
@ReagentX ReagentX self-assigned this Jan 11, 2023
@themorgantown
Copy link
Author

How old is this database? All of mine going back to 2011 have this column.

I see messages going back to Sept 2015

@ReagentX
Copy link
Owner

Is this chat.db file from an iOS device or a macOS one?

@themorgantown
Copy link
Author

macOS

@ReagentX ReagentX mentioned this issue Jan 11, 2023
Merged
@themorgantown
Copy link
Author

confirmed fix! Thanks 🍰 🍰

# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees

@ReagentX ReagentX

Labels
bug Something isn't working crate: database Related to the database crate table Related to table data
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat/cs/optional transfer name ReagentX/imessage-exporter
2 participants
@themorgantown @ReagentX