Manual talk:ReassignEdits.php

Jump to navigation Jump to search


This script is not updating the file history, that is, the fields img_user and img_user_text of the Image table (the related page history is updated correctly, though). The old user continues to be displayed as the uploader of the file. Capmo (talk) 01:05, 6 September 2012 (UTC)

Here's a temporary solution; run the following query after executing reassignEdits.php:
UPDATE image i, page p, revision r
SET i.img_user = r.rev_user,
i.img_user_text = r.rev_user_text
WHERE i.img_user != r.rev_user
AND p.page_title = i.img_name
AND p.page_namespace = 6
AND r.rev_page = p.page_id
AND r.rev_timestamp = i.img_timestamp;
Capmo (talk) 04:05, 6 September 2012 (UTC)