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

Church of emacs <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
                   |                            |m
            Version|1.14-svn                    |unspecified

--- Comment #6 from Church of emacs <[email protected]> 2010-08-15 
12:01:33 UTC ---
Does anyone have a clue what's causing this? The error seems to go in both
directions (sometimes there are too many articles in the category, sometimes
too few). Perhaps we don't put article saves and category updates in one
transaction and if one succeeds and the other fails we get wrong numbers?

Here's a simple query to see where there are wrong numbers in the database:

SELECT cat_title as title, cat_pages as storedcount, realcount FROM category,
(SELECT cl_to, count(cl_to) as realcount FROM categorylinks GROUP BY cl_to) as
rc
WHERE cl_to=cat_title AND rc.realcount!=cat_pages LIMIT 10;

(In reply to comment #5)
> See also bug 12188

That's not really the same bug.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- 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