problem with Repairing DBMAIL headervalues integrity
hello,
dbmail-util comes to this stage and stops.
I manually run the query:
SELECT hv.id FROM dbmail_headervalue hv LEFT JOIN dbmail_header h ON hv.id = h.headervalue_id WHERE h.headervalue_id IS NULL
and he returned more than 300,000 lines.
correctly that it is possible to delete all rows from dbmail_headervalue do not have relation to dbmail_header?
I think that one transaction it will be faster than the dbmail-util.
--
Ñ óâàæåíèåì,
Maxim mailto:max_conf@e-foto.ru
hello,
dbmail-util comes to this stage and stops.
I manually run the query:
SELECT hv.id FROM dbmail_headervalue hv LEFT JOIN dbmail_header h ON hv.id = h.headervalue_id WHERE h.headervalue_id IS NULL
and he returned more than 300,000 lines.
correctly that it is possible to delete all rows from dbmail_headervalue do not have relation to dbmail_header?
I think that one transaction it will be faster than the dbmail-util.
--
Ñ óâàæåíèåì,
Maxim mailto:max_conf@e-foto.ru