[Bug 59373] DBQ-120 Files in "Category:Creator template home categories" without "template:Creator"
https://bugzilla.wikimedia.org/show_bug.cgi?id=59373 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man Date: Fri, 21 Jan 2011 23:27:56 --- This is an issue caused by your browser which doesn't recognize the encoding correctly. If you are using Firefox, do the following: Go to View > Character Encodings > then select UTF-8 ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif -- You are receiving this mail because: 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
[Bug 59373] DBQ-120 Files in "Category:Creator template home categories" without "template:Creator"
https://bugzilla.wikimedia.org/show_bug.cgi?id=59373 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: Jarek Tuszynski Date: Sun, 23 Jan 2011 21:14:44 --- Thanks that worked. -- You are receiving this mail because: 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
[Bug 59373] DBQ-120 Files in "Category:Creator template home categories" without "template:Creator"
https://bugzilla.wikimedia.org/show_bug.cgi?id=59373 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: Jarek Tuszynski Date: Fri, 21 Jan 2011 19:56:57 --- Thanks a lot - it is very useful. I just have one more question: Many filenames had foreign characters which did not come out correctly. See for example http://commons.wikimedia.org/wiki/User:Jarekt/c where I pasted links to the last 400 files. Only about 20 are correct. Is there a way to correct that? -- You are receiving this mail because: 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
[Bug 59373] DBQ-120 Files in "Category:Creator template home categories" without "template:Creator"
https://bugzilla.wikimedia.org/show_bug.cgi?id=59373 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #5 from Bugzilla Bug Importer (valhallasw) --- This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: h...@online.de CC list: h...@online.de, jaroslaw.w.tuszyn...@leidos.com -- You are receiving this mail because: 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
[Bug 59373] DBQ-120 Files in "Category:Creator template home categories" without "template:Creator"
https://bugzilla.wikimedia.org/show_bug.cgi?id=59373 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man Date: Fri, 21 Jan 2011 13:26:04 --- SQL: SELECT /* SLOW_OK */ page.page_title as file FROM page INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from INNER JOIN templatelinks ON templatelinks.tl_from = page.page_id LEFT JOIN (SELECT COUNT(*) as bool, tl_from FROM templatelinks WHERE templatelinks.tl_title = 'Creator' GROUP BY tl_from) as tlinks ON tlinks.tl_from = page.page_id WHERE page.page_namespace = 6 AND categorylinks.cl_to IN (SELECT page.page_title FROM page INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to = 'Creator_template_home_categories' AND page.page_namespace=14) AND templatelinks.tl_title = 'PD-Layout' AND isnull(tlinks.bool); Result: http://toolserver.org/~hoo/dbq/dbq-120.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-120_wiki.txt (wiki table) -- You are receiving this mail because: 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