Question:
Is it healthy that table hubloc has identical rows, where only two fields differ: 1. hubloc_id (of course) and 2. hubloc_guid_sig and the 2nd only by the prefix sha256 (and remainder equals).
select hubloc_addr,COUNT(hubloc_hash) as n from hubloc where hubloc_deleted=0 group by hubloc_hash,hubloc_network having n > 1 order by hubloc_addr;
From the result, one can take some hublog_id values to examine, ie
select * from hubloc where hubloc_id in(4101,4133)\G;
Like Us
Support Hubzilla
