search

SenCodeMaker / whatsapp-database-merger

SQL scripts to merge two or more whatsapp database easily
GNU General Public License v3.0
5 stars 2 forks source link

Missing chats from the newest database #2

Open Rainy-Window opened 1 year ago

Rainy-Window commented 1 year ago

The (updates) script works fine, but whenever I try to execute the second script it gives an error on this line:

" -- add to set the value of unseen_message_reaction_count manually because sqlite was complaining about null constraint error that wasn't there"

I'm not sure how to set the value of this. however, when I press "skip" the script goes on with some more errors like:

[SQLITE_ERROR] SQL error or missing database (table chat has no column named display_message_sort_id)

[SQLITE_ERROR] SQL error or missing database (table message has 19 columns but 20 values were supplied)

And errors go on… Which resulting in the final database to have many missing chats from the newest database. (mostly the new chats that haven't been interacted with in the older database)

Any thoughts about how to solve this issue, please? appreciate your help a lot

Rainy-Window commented 1 year ago

@SenCodeMaker .. Can someone please help with this? I can modify the script, but I'm not familiar with coding so i don't understand what parts should be modified, deleted, or added. thanks a lot in advance

SenCodeMaker commented 1 year ago

simply try to remove all lines containing display_message_sort_id and execute the script

Rainy-Window commented 1 year ago

@SenCodeMaker
thank youu for your response

I've tried to remove every column name that beaver complained they don't exist when I executed the script. But the same problem still exist (some chats are missing)

However, I've noticed that ALL missing chats are actually completely new chats that I haven't interacted with in the older database backup.

Please let me explain..

old.db :

I've chat history with:

*Total message count: 60

new.db :

I've chat history with:

*Total message count: 20

When I execute the script: this is what happens in the output database. I named it merged.db

merged.db :

Total message count: 70 (60 from old.db + 10 from new.db) Supposed to be 80 Missing Messages count: 10 (5 for Ali + 5 for Marry)

See? The old chats that have been updated. However, newer Chats (that didn't exit in the old.db and exist in new.db) are missing; (Ali & Marry) in this case.

Any idea how to solve this, please? thanks again

SenCodeMaker commented 1 year ago

hello, have few solutions you can try

-try importing the old db into the new

-try to manually copy the missing conversation into the merged db

Le lun. 12 sept. 2022 à 11:37, ghostiy @.***> a écrit :

@SenCodeMaker https://github.com/SenCodeMaker thank youu for your response

I've tried to remove every column name that beaver complained they don't exist when I executed the script. But the same problem still exist (some chats are missing)

However, I've noticed that ALL missing chats are actually completely new chats that I haven't interacted with in the older database backup.

Please let me explain..

old.db :

I've chat history with:

  • David -- 20 messages
  • Sarah -- 20 messages
  • Jack -- 20 messages

*Total message count: 60

new.db :

I've chat history with:

  • David -- 5 messages
  • Sarah -- 5 messages
  • Ali -- 5 messages (NEW)
  • Marry -- 5 messages (NEW)

*Total message count: 20 (10 old + 10 new)

When I execute the script: this is what happens in the output database. I named it merged.db merged.db :

  • David -- 25 messages (+5)
  • Sarah -- 25 messages (+5)
  • Jack -- 20 messages

*Total message count: 70 (60 from old.db + 10 from new.db)

See? The old chats that have been updated. However, newer Chats (that didn't exit in the old.db and exist in new.db) are missing; (Ali & Marry) in this case.

Any idea how to solve this, please? thanks again

— Reply to this email directly, view it on GitHub https://github.com/SenCodeMaker/whatsapp-database-merger/issues/2#issuecomment-1243474239, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKJU2L6D2E5IKXSAIIJROZDV532WVANCNFSM55K4N6GA . You are receiving this because you were mentioned.Message ID: @.***>

Rainy-Window commented 1 year ago

-try importing the old db into the new

What do you mean? How to import the old into the new? I've tried to swap the old.db with the new.db in the script locations, but it didn't seem to work .. So many messages are overwritten.

-try to manually copy the missing conversation into the merged db - post here your database structure

I'm not quite sure how to copy them manually into merged, to be honest. I've very little experience. But i like to dig in the settings.. i've found an option in Beaver called compare. Is this what you mean?

Thanks for your fast response @SenCodeMaker