The aox check database performs a variety of expensive sanity checks on the database. It does not change anything.
There is one known old problem. Some old versions of Archiveopteryx would occasionally forget to insert date_fields rows. If your database has any messages affected by this problem, then you will get this error message:
aox: Unexpected rows in the database. Contact firstname.lastname@example.org. Query: select m.id from messages m left join date_fields df on (m.id=df.message) where df.message is null
The missing rows can usually be generated using this query:
insert into date_fields (message,value) select m.id, trim( both ' ,()abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ' from hf.value )::timestamptz from messages m join header_fields hf on (m.id=hf.message and hf.field=17) left join date_fields df on (m.id=df.message) where df.message is null;
The query may fail for messages using the Samoan time zone.
In case of questions, please write to email@example.com.
Last modified: 2010-11-19