search

suurjaak / Skyperious

Skype chat history tool
Other
350 stars 36 forks source link

Error Syncing with Skype #106

Closed clienthax closed 2 years ago

clienthax commented 2 years ago

V4.8.1

Syncing a DB made of a few merged ones for the same account

Synchronizing messages..

Error syncing from Skype online service:

Traceback (most recent call last):
  File "workers.py", line 839, in run
  File "live.py", line 715, in populate
  File "live.py", line 794, in populate_history
  File "live.py", line 193, in build_msg_cache
  File "skypedata.py", line 362, in execute
OperationalError: no such column: timestamp__ms
suurjaak commented 2 years ago

Looks like the original database you merged to, was of an older format, without some fields that were added in later Skype versions.

A work-around: open the database in Skyperious, and in the SQL window, execute queries:

ALTER TABLE messages ADD COLUMN timestamp__ms INTEGER;
UPDATE messages SET timestamp__ms = timestamp * 1000;

That should make the database compatible for live syncing.

I think I will add functionality for Skyperious to do this automatically.

clienthax commented 2 years ago
image

Am I doing something wrong here?

clienthax commented 2 years ago

Aha looks like the : should have been a ; on the end of the first line, seems to be running the sync now

suurjaak commented 2 years ago

Yep, sorry, the instruction I gave had a typo.

suurjaak commented 2 years ago

With the newly released version 5.0, Skyperious will now also auto-update the schema of an older format database on live sync.