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

--- Comment #4 from Aaron Halfaker <[email protected]> ---
I agree.  It seemed strange to me too.  I just realized that the logging table
could be storing the page ID of the redirect that was created.  I'll try to
demo the issue.

# Get the last page move in the logging table on enwiki:
> SELECT log_namespace, log_title, log_page, log_params FROM logging WHERE 
> log_action = "move" and log_type = "move" AND log_namespace = 0 ORDER BY 
> log_id DESC LIMIT 1;
+---------------+-----------+----------+------------------------------------------------------------------------+
| log_namespace | log_title | log_page | log_params                            
                                |
+---------------+-----------+----------+------------------------------------------------------------------------+
|             0 | Chappo    | 41083072 | a:2:{s:9:"4::target";s:14:"Chappo
(album)";s:10:"5::noredir";s:1:"0";} |
+---------------+-----------+----------+------------------------------------------------------------------------+
1 row in set (0.29 sec)


That means "Chappo" was moved to "Chappo (album)".  But the recorded page_id
points to a new page that has become a redirect:

> select page_title, page_namespace from page where page_id = 41083072;
+------------+----------------+
| page_title | page_namespace |
+------------+----------------+
| Chappo     |              0 |
+------------+----------------+
1 row in set (0.04 sec)


If you view the content of the article at that page ID, you should see:
---------------------------------
#REDIRECT [[Chappo (album)]]
{{R from move}}
---------------------------------

My proposed solution is to store the page_id of the *moved page* in log_page
and optionally store the page_id of the created redirect in the hashed array in
log_params.  

This solution is slightly problematic since old code could be relying on the
page_id of the redirect page appearing in log_page.  Though, I can't imagine
why anyone would be looking for that there.

-- 
You are receiving this mail because:
You are the assignee for the bug.
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