> 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? _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
