306806 - Need SQL query run prior to migration to MediaWiki 1.5

Status: RESOLVED WONTFIX

(developer.mozilla.org Graveyard :: General, defect)

Description

[Justin Wood (:Callek)]

Polvi, because we need to change the title-extension to <title-override>; rather
than causing us to have some problems after we do this, I'd like to have a list
of documents which will need "updating" once we migrate.

Can you please run the following query and post its results here.

SELECT cur_namespace, cur_title, to_title FROM $cur, $title_override WHERE
(cur_id = to_id);

where:
$cur = $dbr->tableName('cur');
$title_override = $dbr->tableName('title_override');

This may be a good idea to do for the localizations as well; though I won't do
the editing workload for them.

[I hope I did not mess up on the SQL here]

Comment 1

[Alex Polvi]

Shaver, since this is your extension -- I would like your OK before moving
along. I am not 100% clear on the implications.

-Alex

Comment 2

[Mike Shaver (:shaver emeritus)]

We don't need to do this ahead of time, IMO.  We can update the document text in
place with SQL, and then invalidate the cache to automatically rebuild the pages
on first use.  That will also avoid a pile of spurious entries in the Recent
Changes list.

Comment 3

[Justin Wood (:Callek)]

shaver, that sounds perfectly fine for me, assuming that the way history diff's
are generated won't be broken by this.  The Recent changes is the only thing I
was even partially worried about.  Feel free to morph this bug into your
suggestion. (I will not write the SQL/maintenance script for it; Don't feel
confident enough not to mess-up somewhere along the line).

Comment 4

[Alex Polvi]

Whats the status on this? Waiting on me?

Comment 5

[Justin Wood (:Callek)]

well since shaver has not run the query he thought he would (instead of this
one) it is likely waiting on you, though I believe the query I posted for pre
MW1.5 is not the correct query anymore;  

polvi, though you do have what you need in order to know what I am after, if you
would rather me figure out the correct query you may wait; otherwise I will
figure it out for you in the next few days.

Comment 6

[Alex Polvi]

 
> polvi, though you do have what you need in order to know what I am after, if you
> would rather me figure out the correct query you may wait; otherwise I will
> figure it out for you in the next few days.

Not really sure what you are after. Just whip up the query and let me know.

Comment 7

[Alex Polvi]

This seems to be a non-issue, since we have been updated for quite some time now.

Comment 8

[Nickolay_Ponomarev]

Many occurences of <title> were replaced to title-override manually, but it would still be nice to check which pages were not updated.

Comment 9

[Justin Wood (:Callek)]

well in the future we can probably extend breadcrumbs to deal with title-override anyway, so this may well be a non-issue now ;-)