Last modified: 2005-12-12 02:59:15 UTC
Special pages bug, Wikimedia site specific or bug of MediaWiki 1.4.0 Watchlist says "120000 total pages edited since cutoff" not depending the real number of edits. Found on English Wikiquote and Japaense Wikipedia. Perhaps on other sites, too.
This is due to a developer error - the watchlist queries have been removed to save time, and instead been replaced with an estimate that says 40000*days edits. The bug is in SpecialWatchlist.php: // Excessively expensive query removed and replace with an estimate that's roughly the same on en.wikipedia.org // Query below was more expensive than the real watchlist queries /* $docutoff = "AND cur_timestamp > '$cutoff'"; $sql = "SELECT COUNT(*) AS n FROM $cur WHERE cur_timestamp>'$cutoff'"; $res = $dbr->query( $sql, $fname ); $s = $dbr->fetchObject( $res ); $npages = $s->n; */ $npages = 40000 * $days; To fix, remove $npages = 40000 * $days; and un-comment the code directly above.
I suggest that only the line: $docutoff = "AND cur_timestamp > '$cutoff'"; be uncommented. This will disable the count query but unbork the SQL.
on our wiki (display notices enabled in PHP) there is also a notice displayed: "undefined variable: docutoff in <strong>C:\WWW\wiki\includes\SpecialWatchlist.php</strong> on line <strong>173</strong>"
In 1.5 CVS the page count is calculated by a query again, therefore closing as FIXED.
The whole bit's rather crappy and needs cleanup and merging of fixes from live branch, reopening.
en:Wikiquote has just been updated to 1.5beta1, and not only does this problem still exist there, but Special:Watchlist user watchlist count now erroneously includes talk pages, even though it explicitly says "not counting talk pages".
This debug message got removed some while ago. Resolving FIXED.
