Jorge Bastos wrote: >>> mysql> DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN >>> dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id) >> WHERE >>> dbmail_partlists.physmessage_id IS NULL; >> I'm pretty sure we don't use that kind of query. I wasn't even aware of >> this trick. > > It was something I used in 2.3.2. > > Thanks for your fix! > This fixes this problem, and also something I reported about having uncached > messages all the time when running "dbmail-util -by". > > Only one question, > In every run, the partlists part, always has 0 unconnected partlists's. Is > it normal? Example below.
yes. Those are flushed out by the foreign key constraint in partlists: CONSTRAINT `dbmail_partlists_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
