Can the "quick" contacts table be reconstructed if its contents are lost
or damaged?
Background:
My wife recently noticed that all of the contacts that had been synced
with SOGo went missing from her iPhone. She added several before
mentioning the problem.
In the SOGo web UI, we now see 3 contacts.
So, I checked for her contact folder tables:
sogo=# select substring(c_location, '[^/]*$') ,
substring(c_quick_location,'[^/]*$') from sogo_folder_info where
c_path2='alena' and c_path3 = 'Contacts';
substring | substring
--+
sogoalena00173395dfe | sogoalena00173395dfe_quick
(1 row)
And, counted the rows in each:
sogo=# select count(*) from sogoalena00173395dfe;
count
---
167
(1 row)
sogo=# select count(*) from sogoalena00173395dfe_quick;
count
---
3
(1 row)
I think that all of her old contacts are still in the table referenced
in c_location, but something caused c_quick_location to be
lost/truncated. I updated to 5.4.0 on Jan 10, and it looks like the
data was lost sometime between Jan 15 03:00 Pacific and Jan 16 03:00
Pacific. I have the sogo.log from that date if it is useful, but the
loss of that table probably resulted from hardware resets on that date
(the hardware has been replaced).
--
users@sogo.nu
https://inverse.ca/sogo/lists