suurjaak
Skyperious doesn't load some profile images
All my contacts were synced from Online. For whatever reason, half of them have profile images, but the other half do not. There are no errors reported in the Skyperious log.
For the contacts with missing profile images, if I manually call db.live.skype.contacts.contact('<user id>').avatar in the python shell and then paste the returned URL in an incognito browser window, I am able to load the profile image.
Can you execute the following statement in the SQL window:
SELECT skypename, length(avatar_image), avatar_image FROM Contacts
What does it report as length for the contacts where avatar is missing?
When I run the query, some of the profiles with missing images return a length of ~5k-6k and then the profile image suddenly starts working when I switch back to the contacts view. For the rest, the query returns a null length.
When I run the query, some of the profiles with missing images return a length of ~5k-6k and then the profile image suddenly starts working when I switch back to the contacts view.
That is truly bizarre. These two functionalities are completely unrelated. Does this happen every time you run the program?
What is the result regarding avatars if you export all contacts as HTML?
Is loading avatars also affected by API rate limits?
I am not sure.
Does this happen every time you run the program?
No, it seems intermittent.
What is the result regarding avatars if you export all contacts as HTML?
The contacts with missing avatars (but valid avatar URLs) will just show the placeholder avatar image.
No, it seems intermittent.
Can you send me the database content of the avatar of one such contact? E.g. run this query in the SQL window and export the result as an SQL file:
SELECT avatar_image FROM Contacts WHERE skypename = '<user id>';
The contacts with missing avatars (but valid avatar URLs) will just show the placeholder avatar image.
What about those contacts where the avatar did not work in-program until you ran the query?
Sorry, I misunderstood one question earlier - downloading avatar images is affected by API rate limits.
This is the result exported as an sql file; I have removed personally identifying information such as usernames.
-- SQL query.
-- Source: /home/<me>/Documents/skype/from_export/<my skype>.main.db.
-- Exported with Skyperious on 03.05.2025 01:24.
-- SQL: SELECT avatar_image FROM Contacts WHERE skypename = '<user id>';
CREATE TABLE results (avatar_image)
INSERT INTO results (avatar_image) VALUES (NULL);
The export I had in mind was for such a contact:
some of the profiles with missing images return a length of ~5k-6k and then the profile image suddenly starts working when I switch back to the contacts view
The export I had in mind was for such a contact
Noted, attached. Note that I haven't been able to observe such behaviour for a while now, though other contacts with missing images are still present.
Very odd, there is nothing wrong with this image.
As for contacts missing avatars altogether - what happens if you re-sync from online?