Colin Delacroix wrote:
- it might be that the revision has changed between
the dumps of those 2
tables (page has been edited)
They're dumped at different times, yes. A copy of the 'page' table is for
reference only, and is not guaranteed to be consistent with the XML data dumps.
If you're using an XML data dump you don't need a separate download of the
'page' table, just use the one created by the import.
- it ends in empty pages (i.e. with the usual stub
text), for ~ 5% of
the pages (that seems huge, but I don't see where the problem lies)
I don't know what this means. What "ends" in empty pages, and in what way?
- is there a simple way to fix it ? (if no better idea
emerges, I will
try to fix the page_latest column in the page table by doing a lookup on
rev_page in the revision table - is it right ?)
Just use the page table generated from the import; it's guaranteed to be consistent.
-- brion vibber (brion @ pobox.com