signal-message-exporter

signal-message-exporter copied to clipboard

current spec android signal client backup

2023-07-05 10:38:22 - INFO - Starting message export
Traceback (most recent call last):
  File "/root/signal-message-exporter.py", line 393, in <module>
    cursor.execute("""select message._id, message.date_sent, message.m_size, message.m_type, message.body, message.recipient_id, message.type, message.story_type,
sqlite3.OperationalError: no such column: message.recipient_id

It's possible that this SQL as modified worked: it changes the to_recipient_id to "AS recipient_id" but assumes that the correct field is the to_recipient_id not the from_recipient_id

cursor.execute("""select message._id, message.date_sent, message.m_size, message.m_type, message.body, message.to_recipient_id as recipient_id, message.type, message.story_type,
                  thread.recipient_id as receiver from message left join thread on message.thread_id = thread._id order by message.date_sent desc""")

I didn't submit a PR because there's not much point, if I have the wrong instance of a recipient_id

I've just installed the latest version of Signal - and I'm getting a different experience when I try to run the export - the signalbackup-tools application isn't having any luck dissecting my backup file - this is a freshly made backup file too - so I'll have to dig a bit.

What was the exact version of Signal that you're using?

As of today I am on 6.25.5 on Android.

If that is newer than the variant when I posted, the date I posted is the date I ran it. I have automatic update and generally it's fast.

It was a one time export btw. Achieved what I wanted with the 'as' mod to sqlite3 to name the column.

G

On Sat, 15 Jul 2023, 4:38 pm Alex Lance, @.***> wrote:

I've just installed the latest version of Signal - and I'm getting a different experience when I try to run the export - the signalbackup-tools application isn't having any luck dissecting my backup file - this is a freshly made backup file too - so I'll have to dig a bit.

What was the exact version of Signal that you're using?

— Reply to this email directly, view it on GitHub https://github.com/alexlance/signal-message-exporter/issues/24#issuecomment-1636688447, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABORQ7DX4GL5ADT7B2DXD2LXQI3ELANCNFSM6AAAAAAZ6Y4ANM . You are receiving this because you authored the thread.Message ID: @.***>

Thanks @geeohgeegeeoh - I've made an issue over here: https://github.com/bepaald/signalbackup-tools/issues/131 and once that's sorted I'll run a test using the fix you've made.