Re: Rebuilding headercache

> Hi,
> 
> Sorry to pressure,
> 
> Any idea on this, on how to make the full sql query go to the log?

Hi Paul,

On this, I discovered that, on the rebuild after the query returns some
values

SELECT p.id FROM dbmail_physmessage p LEFT JOIN dbmail_header h ON p.id =
h.physmessage_id WHERE h.physmessage_id IS NULL

The query on the loop for the results, returns nothing:

mysql> SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date,
GET_FORMAT(DATETIME,'ISO')) FROM dbmail_messageblks b JOIN
dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id =
12953193 ORDER BY b.messageblk_idnr;
Empty set (0.00 sec)

mysql> SELECT
l.part_key,l.part_depth,l.part_order,l.is_header,DATE_FORMAT(ph.internal_dat
e, GET_FORMAT(DATETIME,'ISO')),data FROM dbmail_mimeparts p JOIN
dbmail_partlists l ON p.id = l.part_id JOIN dbmail_physmessage ph ON ph.id =
l.physmessage_id WHERE l.physmessage_id = 12953193 ORDER BY
l.part_key,l.part_order ASC;
Empty set (0.01 sec)


Any idea?