On 9/11/07, werdna@svn.wikimedia.org werdna@svn.wikimedia.org wrote:
Revision: 25771 Author: werdna Date: 2007-09-11 09:22:54 +0000 (Tue, 11 Sep 2007)
Log Message:
- Update scripts (stand-alone PHP and mysql) for updating old wikis with the new blank rows for pages with no page or category links.
These need to be run by update.php, don't they?
On 9/12/07, Simetrical Simetrical+wikilist@gmail.com wrote:
On 9/11/07, werdna@svn.wikimedia.org werdna@svn.wikimedia.org wrote:
- Update scripts (stand-alone PHP and mysql) for updating old wikis with the new blank rows for pages with no page or category links.
These need to be run by update.php, don't they?
Hmm.. They don't really lend themselves well to checking whether they've already been run, and it's a fairly slow query that's being run (including a LEFT JOIN)...
On 9/11/07, Andrew Garrett andrew@epstone.net wrote:
Hmm.. They don't really lend themselves well to checking whether they've already been run, and it's a fairly slow query that's being run (including a LEFT JOIN)...
How about SELECT 1 FROM page_links WHERE pl_namespace=0 AND pl_title='' LIMIT 1? A heuristic, technically, but a sufficiently accurate one to avoid most problems, I hope. Completely breaking two special pages is not, I think, a valid alternative.
wikitech-l@lists.wikimedia.org