Category talk:Pages using Information template with parsing errors
Status edit
What is the current status of this category? Till which date the files have been processed yet? --Arnd (talk) 12:47, 4 March 2015 (UTC)
- I think I reached the limits of what CatScan2 can do and my queries are timing out. It might be time to find someone to run a query on the database to find all the files that do not have a infobox and are not in Category:Media missing infobox template or subcategories. Something similar to User:Jarekt/SQL#No_license_Query. --Jarekt (talk) 14:22, 4 March 2015 (UTC)
- What hinders you to run this query? Or do you mean something else than using toollabs for this query? --Arnd (talk) 14:37, 4 March 2015 (UTC)
- I never spend time to figure out how to run stuff on toollabs. I tried once or twice and each time it took a lot of work to figure out how to do things and next time I needed it my account was expired. So in the past I usually used Query request service. --Jarekt (talk) 18:26, 4 March 2015 (UTC)
- So i can try to run the query when i find time. --Arnd (talk) 19:17, 4 March 2015 (UTC)
- Thanks. --Jarekt (talk) 19:29, 4 March 2015 (UTC)
- @Jarekt: Just trying to execute the SQL query. For help, could you please provide me the CatScan query you were usually using? --Arnd (talk) 19:53, 8 March 2015 (UTC)
- I usually just used the second query on the Category:Media missing infobox template page: this CatScan2 query but was replacing the 300 hours with a date bracket. --Jarekt (talk) 01:22, 9 March 2015 (UTC)
- @Jarekt: Just trying to execute the SQL query. For help, could you please provide me the CatScan query you were usually using? --Arnd (talk) 19:53, 8 March 2015 (UTC)
- Thanks. --Jarekt (talk) 19:29, 4 March 2015 (UTC)
- So i can try to run the query when i find time. --Arnd (talk) 19:17, 4 March 2015 (UTC)
- I never spend time to figure out how to run stuff on toollabs. I tried once or twice and each time it took a lot of work to figure out how to do things and next time I needed it my account was expired. So in the past I usually used Query request service. --Jarekt (talk) 18:26, 4 March 2015 (UTC)
- What hinders you to run this query? Or do you mean something else than using toollabs for this query? --Arnd (talk) 14:37, 4 March 2015 (UTC)
@Jarekt: Just started working on a query to find the all files for this category. I picked your linked Catscan query and converted and tested it: http://quarry.wmflabs.org/query/2549. However this seems not to be the right query for the parsing errors. I think it is more for the category of missing Information template. Any hint? How did u feed your JarektBot? --Arnd (talk) 12:37, 13 March 2015 (UTC)
- Category:Pages using Information template with parsing errors was populated by the same query as Category:Media missing infobox template. However while I was adding Category:Media missing infobox template if I detected "\{\{[Ii]nformation" in the page text than I added Category:Pages using Information template with parsing errors instead of Category:Media missing infobox template. Also latter when looking at files in Category:Media missing infobox template if I detected "|author=", "|source=" fields than I moved files to Category:Pages using Information template with parsing errors. About the query: you do not need to only include files with "License_template_tag". I used that in CatScan query only because CatScan can not deal with a queries in the format "all files that do not have..." but can deal with queries "All files that meet some criteria but do not have ...". --Jarekt (talk) 14:36, 13 March 2015 (UTC)
- Arnd thanks for showing me http://quarry.wmflabs.org/query I have never run into it before and last time I tied direct querying it was very complicated. I will see if I can get it to work. --Jarekt (talk) 16:03, 13 March 2015 (UTC)
- @Jarekt: U r welcome. I adapted the query a little bit. It successfully completed with 14461 results. Maybe you could feed it into your Bot? --Arnd (talk) 16:11, 13 March 2015 (UTC)
- Running again. There is one more improvement to doin the querry the cl_to line should be
cl_to IN ("Media_missing_infobox_template", "Artworks missing infobox template", "Items with OTRS permission missing infobox template", "Pages using Information template with parsing errors")or we need some other way to get subcategories of Media_missing_infobox_template. --Jarekt (talk) 16:31, 13 March 2015 (UTC)
- Running again. There is one more improvement to doin the querry the cl_to line should be
- @Jarekt: U r welcome. I adapted the query a little bit. It successfully completed with 14461 results. Maybe you could feed it into your Bot? --Arnd (talk) 16:11, 13 March 2015 (UTC)
- Arnd thanks for showing me http://quarry.wmflabs.org/query I have never run into it before and last time I tied direct querying it was very complicated. I will see if I can get it to work. --Jarekt (talk) 16:03, 13 March 2015 (UTC)
Further cleaning edit
Hi MaxxL, there are less than 300 remaining files to clean when executing the searches linked on the category page. Maybe you find some time to tackle them... --Arnd (talk) 16:42, 16 December 2015 (UTC)
Hey MaxxL, the category has been filled recently again by a bot. Maybe you are willing to perform an early-year-cleaning. --Arnd (talk) 06:29, 11 February 2016 (UTC)