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

--- Comment #4 from Bawolff <bawolff...@gmail.com> 2011-11-03 04:32:48 UTC ---
Based on toolserver db, looks to be caused by inconsistencies in the commons
db.

File:Fresco with Trompe l'oeuil - Andrea Pozzo -Jesuit Church Vienna.jpg

has page_namespace of 6 (NS_FILE) and a page_id of 2602773, but several of its
categorylinks have a cl_type of "page" instead of "file":

mysql> select cl_to, cl_type from categorylinks where cl_from=2602773;
+---------------------------------------+---------+
| cl_to                                 | cl_type |
+---------------------------------------+---------+
| Andrea_Pozzo                          | page    |
| CC-BY-2.5                             | page    |
| CC-BY-SA-3.0-migrated                 | page    |
| GFDL                                  | page    |
| Jesuit_Church,_Vienna                 | page    |
| License_migration_redundant           | page    |
| Media_with_locations                  | file    |
| Quality_images                        | page    |
| Quality_images_of_Austria             | page    |
| Quality_images_of_churches_in_Austria | file    |
| Self-published_work                   | page    |
| Trompe_l'oeil_in_Austria              | page    |
+---------------------------------------+---------+
12 rows in set (0.00 sec)


Thus, when mediawiki does the query, it gets this image as part of the query
for normal pages, but then sorts it in the image section since it uses
page_namespace for dividing between the same section. This results in image
section having more than 200 images. The is counts in category table consitant
code sees that number of images returned does not equal $wgCategoryPagingLimit
(The gist of the code seems to suggest < instead of != is the true condition
being looked for), but that there should be more images in total than the
paging limit, and no offset has been specified, so thinks that category counts
are wrong.

The code should possibly handle this situation better, but I'm not entirely
sure what the right way to handle it is.

-- 
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to