On 9/18/23 11:19 AM, bryan.kartzman@yu.edu wrote:
And they do have the same thread_id as well:
select a.id, b.starting_email_id, a.message_id_hash, b.thread_id from hyperkitty_email a,hyperkitty_thread b where a.message_id_hash = b.thread_id and a.id = b.starting_email_id and a.id in (1365,1366) ;
id | starting_email_id | message_id_hash | thread_id ------+-------------------+----------------------------------+---------------------------------- 1365 | 1365 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7 1366 | 1366 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7 (2 rows)
This is interesting. There are two entries in the hyperkitty_email table
for the same message. Are the other fields, particularly content, for
these ids in the hyperkitty_email table the same?
If so, I'd be inclined to
delete from hyperkitty_email where id = 1366;
delete from hyperkitty_thread where starting_email_id = 1366;
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan