https://bugzilla.wikimedia.org/show_bug.cgi?id=57084

--- Comment #22 from Nathan Larson <[email protected]> ---
How would we handle existing log items? Per what was written in comment #13
above, I was thinking we could write a script that would look for rows lacking
the redirpageid log parameter. Those would be the ones before the change was
made.

Then it would look at the log_page and see where that redirect points to. It
would need to look in the revision history, or maybe even the archive table (if
the redirect page was later deleted), to find the revision that was created
with the same rev_timestamp or ar_timestamp as the log_timestamp.

Then it could look up the page title from that redirect revision in the page
table to get the page_id to put in log_page.

That page could have been meanwhile moved to a different page title, or deleted
and undeleted, either of which would make the page title have a different page
ID than what it was when the page move occurred. So it might be necessary for
the script to follow the trail in the logging table till it gets to the correct
page ID. That will be an interesting engineering challenge.

Alternatively, we can take the easy way out and simply fix bug 68930. Then we
wouldn't be making any breaking changes.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to