I have to ask again, because the number of physmessages and messages differs greatly on our server:
On Mittwoch, 20. Juni 2007 Michael Monnerie wrote: > > No. It's a known bug there are some checks missing from the > > maintenance code. > > OK, should I > select * from dbmail_physmessage p left join dbmail_messages m on > (p.id=m.physmessage_id) where m.message_idnr IS NULL; > to find out phymessages that have no message id? > > Then I could delete them using > delete from dbmail_physmessage p left join dbmail_messages m on > (p.id=m.physmessage_id) where m.message_idnr IS NULL; > Is this correct? -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
