[SailfishDevel] Contacts db issue

Tone Kastlunger users.giulietta at gmail.com
Mon Oct 26 19:47:54 UTC 2015


Hey;
looking through the logs (for something else) on my Jolla I happened to
find the
following error; it appears to be realated to the contacts db. Any way to
fix it?


 "Failed to prepare query for joined details:
                              database disk image is malformed Unable to
fetch row
                              Query:
                              SELECT
Details.detailId,Details.contactId,Details.detail,Details.detailUri,Details.linkedDetailUris,Details.contexts,Details.accessConstraints,Details.provenance,COALESCE(Details.modifiable,
0),COALESCE(Details.nonexportable,
0),Addresses.*,Anniversaries.*,Avatars.*,Birthdays.*,EmailAddresses.*,Families.*,GeoLocations.*,Guids.*,Hobbies.*,Nicknames.*,Notes.*,OnlineAccounts.*,Organizations.*,PhoneNumbers.*,Presences.*,Ringtones.*,Tags.*,Urls.*,OriginMetadata.*,GlobalPresences.*,ExtendedDetails.*
FROM temp.RegenerateAggregate CROSS JOIN Details ON Details.contactId =
temp.RegenerateAggregate.contactId LEFT JOIN Addresses ON
Addresses.detailId = Details.detailId LEFT JOIN Anniversaries ON
Anniversaries.detailId = Details.detailId LEFT JOIN Avatars ON
Avatars.detailId = Details.detailId LEFT JOIN Birthdays ON
Birthdays.detailId = Details.detailId LEFT JOIN EmailAddresses ON
EmailAddresses.detailId = Details.detailId LEFT JOIN Families ON
Families.detailId = Details.detailId LEFT JOIN GeoLocations ON
GeoLocations.detailId = Details.detailId LEFT JOIN Guids ON Guids.detailId
= Details.detailId LEFT JOIN Hobbies ON Hobbies.detailId = Details.detailId
LEFT JOIN Nicknames ON Nicknames.detailId = Details.detailId LEFT JOIN
Notes ON Notes.detailId = Details.detailId LEFT JOIN OnlineAccounts ON
OnlineAccounts.detailId = Details.detailId LEFT JOIN Organizations ON
Organizations.detailId = Details.detailId LEFT JOIN PhoneNumbers ON
PhoneNumbers.detailId = Details.detailId LEFT JOIN Presences ON
Presences.detailId = Details.detailId LEFT JOIN Ringtones ON
Ringtones.detailId = Details.detailId LEFT JOIN Tags ON Tags.detailId =
Details.detailId LEFT JOIN Urls ON Urls.detailId = Details.detailId LEFT
JOIN OriginMetadata ON OriginMetadata.detailId = Details.detailId LEFT JOIN
GlobalPresences ON GlobalPresences.detailId = Details.detailId LEFT JOIN
ExtendedDetails ON ExtendedDetails.detailI
Oct 26 21:38:30 Jolla [1156]: [W] ContactWriter::regenerateAggregates:3652
- "Failed to read constituent contacts for aggregate 8487 during regenerate"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.sailfishos.org/pipermail/devel/attachments/20151026/4769a415/attachment.html>


More information about the Devel mailing list