User talk:Duesentrieb/CommonSense

This page is for discussion about CommonSense [1], a tool written by User:Duesentrieb. If I do not respond, please leave a quick note on my talk page at the german wikipedia.

---

no title

Hi -- each time I try to find a category for my uploaded photo -- I get the following message:

<Image not found on commons.wikimedia.org!>

Yet, the photo shows up on recently uploaded photos. Any suggestions?

Thanks, gaynewyorker

CommonSense reloaded? :)

moved here from commons:User talk:Duesentrieb -- Duesentrieb 15:32, 9 January 2006 (UTC)

Hi! I leave you a message at Village Pump some days ago. Will you plan to recode CommSense tool? I find it very useful. Specially the posibility of search categories from text on the page or just putting the text into a form page.

Of course, I know you are very busy. It's just a question. Regards, --Colegota 18:16, 11 December 2005 (UTC)

not sure what you mean by "recode", but it's back online since yesterday, see commons:COM:VP#Think of the Orphans! (or: CommonSense reloaded). Have fun! -- Duesentrieb^(?!) 20:02, 11 December 2005 (UTC)

I believed that you lost original code... Well, thank you again. I got an error trying commons::Image:Turpan-jiaohe-ruinas-d16.jpg and others when I select "All wikis". Regards, --Colegota 21:41, 11 December 2005 (UTC)

A database error has occurred
Query: SELECT *
FROM wikimaniawiki.image
WHERE img_name = 'Turpan-jiaohe-ruinas-d16.jpg'
Function:
Error: 1142 SELECT command denied to user 'daniel_www'@'localhost' for table 'image' (localhost)

Backtrace:

    * GlobalFunctions.php line 501 calls wfbacktrace()
    * Database.php line 474 calls wfdebugdiebacktrace()
    * Database.php line 424 calls databasemysql::reportqueryerror()
    * CommonSense.php line 724 calls databasemysql::query()
    * CommonSense.php line 407 calls commonsensepage::loadimageinfo()
    * CommonSense.php line 275 calls commonsensepage::findimageuses()
    * CommonSense.php line 995 calls commonsensepage::findcategories()
    * CommonSense.php line 1417 calls commonsensepage::generatehtmloutput()


Notice: Undefined offset: 1 in /u01/u/daniel/MediaWiki/phase3/includes/GlobalFunctions.php on line 523

Yes, i know. Database permissions for wikimaniawiki are missing. But "all wikis" is not very useful anyway - only wikipedias have a helpful structure. So, i've disabled the "all wikis" option for now.

Thanks for the feedback! -- Duesentrieb^(?!) 23:01, 11 December 2005 (UTC)

Ok. It's possible to have a tool like "Use keywords from the description text" without having any image uploaded yet? It will be useful to me because I must to do an investigation work before start upload any new bunch of images (usually places). I know the "description text" taken by wiki pages or my own sources and I can fill it. But now, with current tool, I must upload first an image and it passes some time before that image is found in search. Or try to find similar pages looking for related categories.

Regards, --Colegota 07:38, 12 December 2005 (UTC)

For images not yet on the commons, use the "Move" option and give a wiki (language) to search in. If the image is on that wiki, enter the name of the image at the top and click "find categories". If necessary, click "keywords from description" after that. If the image is not on the wiki either, simply enter keywords - CommonSense will then look for articles on the wiki you specified, that match the keywords.

Maybe I should add some text to explain this - but I didn't want to make the interface so crowded... Try it out and tell me if it works for you. -- Duesentrieb^(?!) 13:52, 12 December 2005 (UTC)

Hum... It's not the same. Try this.

• Take a look to the commons:Jiaohe ruins gallery. Or commons::Image:Turpan-jiaohe-ruinas-d16.jpg page.
• Copy the text description (I have it previous to upload) into the keywords field. First problem is that you can't paste multilineal text in a single line input. So just, take the english text. There is no match.
• Now put "Image:Turpan-jiaohe-ruinas-d16.jpg" on image field (with or without keywords). There is no match again.
• Now press on "Use keywords from description" and check the results. That's I'd like from begining. :) The pages that matches keywords is very useful for me. And of course, the suggested categories.

I think there is not the same search just from keywords field. I hope that helps. Regards, --Colegota 14:42, 12 December 2005 (UTC) PD I can translate it to Spanish when you consider it "stable".

More feedback... In last example maybe the engine must be find commons::Category:Turpan instead of commons::Category:Xinjiang (first one is under second one) and find also commons::Category:Ruins even commons::Category:Jiaohe ruins. It's correct? It's possible? I think the problem is to avoid the search from Commons. In last versions we can look both in wikipedias and other projects, and the search in Commons is very important too. --Colegota 14:57, 12 December 2005 (UTC)

Some interface feedback

Basically there is a need to specify two wikis. One is the source wiki, if an image is supplied (at the moment, by default, commons), and the other is the wiki you want to find categories in.

Also, what does custom wikis mean? Does it mean "the ones I listed under 'Additional' only"? (I think it must.) If you want to explain things like that without putting heaps of extra text, you could just use a link to "Explanation" page, or have "hover over" pop-ups (but I don't know how complex that is).

Anyway, I made this fake picture of what I think a clear interface would look like. What do you think? Is it correct in terms of how CommonSense works?

I also added lines specifically for en:, as well as commons, as I believe those would be the most commonly used. I just thought of something interesting - you could have it specify commons, the language-specific one, and then write in for the rest (eg "English" interface lists en, "German" interface lists de:, etc). I don't know if that would be a lot of extra work or not though.

I figured out one time when it doesn't give any results - when you fill out all the details on the top and then click "Find Categories" at the bottom. That's not very smart, but then, user's aren't. :) As you can see the one I made only has one "find categories" button, so they can't get it wrong (I hope).

When I tried to enter "zh" (Chinese) in the "additional" wikis, it said "unknown project: zh". [2]

I just noticed you had your own category-tree thing! Did you know this had been developed? Whatever, I love them both.

OK last thing. Did you know that when it has links to pages an image has been used in, the links are kind of weird? The links are like http://de.wikipedia.org/w/index.php?title=Lushan but maybe that's exactly the same as http://de.wikipedia.org/wiki/Lushan anyway? I don't know.

Anyway please let me know what you think - maybe I have completely misunderstood how it works. :)

Thanks again, pfctdayelise 15:27, 12 December 2005 (UTC)

Hi! I'm not sure. I think this feedback were for Duesentrieb, but I like to add some point of view.

I'm uploading photos of my travels so I have some information about places. Usually from travel guidebooks, Internet searches and my own experience. This is not enought frequently and of course I must to "syncronize" that information with the existing in Wikipedias and Commons.

So, first, I need to collect as much information as possible about this places. Then, It's useful to know every place in any Wikipedia where talks about the location.

Second. I need to categorize it in Commons. So, I need to know existing related categories in Commons. If there is some/s branch/es of some/s tree/s in Commons that match I use it. If not I look in en:, the rest of the Wikis or I create it.

That's my method so my dreamed features are:

* Not to have an Image uploaded previously to search (I upload by bunchs using perl upload tool where I must to fill descriptions and categories better before upload). But getting the same results as in the example described above.

* Include in search all the wikipedias (you never knows where someone writes about) and Commons (maybe there is previous information, categories and/or images).

I know that's not the aim to create CommonSense, but it can be very useful for me, and I suppose that many users too. Regards, --Colegota 18:26, 12 December 2005 (UTC)

I'm sorry to say, but I basically found CommonSense pretty useless. It just has a bunch of boxes and controls but no explanation of what a user is supposed to do to run it, and certainly no explanation of what you do with the results. A few sentences giving an overview of the process, what the results mean, and what to do with them, would be appreciated. Otherwise, it's like most of Wiki, just more useless code that some programmer thought really cool, but in reality annoys and confuses users. --NateOceanside 02:49, 24 October 2010 (UTC)

New Version

I have just put a new version online. Thanks to you, I fixed quite a few bugs and tweaked a few things. It should now give much better results, even. Here are a few things is did:

• look for keywords directly on the commons first.
• fixed loading of page text from wikis
• split keyords also on whitespace; for multi-word keywords, use '_' instead of space.
• fixed lookup to wiki-list to handle zh correctly (was blocked by the obsolete zh-tw wiki, which used the same language code)
• added more explanation text

@Pfctdayelise:

• I have not yet changed much about the interface. It's the third time I reworked it, and it still needs more thought. It's not as simple as you think, because there are two desting use cases. The two "find categories" buttons do the same, btw, but the lower one also forces "move" mode. I guess i'll have to move stuff around some more...
• A message for "you left field xy blank" should be added, yes. Maybe later.
• Using the interface language to define the default wiki to look in is a good idea... i'll try it out some time.
• Yes, I know about the other category tool. I wrote mine about two weeks before Kolossos, and then the toolserver crashed;) It's funny how much they look alike, he's even using much the same technology as I have. I have send him my code, my JS stuff is better ;)
• /w/index.php?title=Lushan is the "canonical" form of the URL, which will also work for all actions. Everything else is just "prettification".

@Colegota: As far as I understood you, CommonSense should now do pretty much exactly what you want.

Yes! :) It's what I wanted. I will test in different ways and tell you more feedback about thinks I'm finding on a separate section. Thank you a lot. --Colegota 12:57, 13 December 2005 (UTC)

So... try it out once more, have fun! -- Duesentrieb^(?!) 19:02, 12 December 2005 (UTC)

It's much better now. The explanations are clearer, I think. But still, I find it funny the section is called "move". If I have a picture not yet uploaded (ie only keywords), why should I use the "move" section? It still gives categories in commons, and using the "cleanup" section gives the same or similar results.

The results are always categories on commons, yes? So actually, from my picture, we can delete the whole section on the right. ;) pfctdayelise 22:42, 12 December 2005 (UTC)

Yes, the results are always categories and galleries on the commons. "Move" is primarily intended for moving an image from a wikipedia to commons, but it will also work for keyword-only-searches, i.e. if the image has not been uploaded at all. And yes, the two modes are very similar, but there are some differences: for instance, where the actual image data i loaded from. For a keyword search, both work, but "Move" makes more sense, because you usually know in which language your keywords are. -- Duesentrieb^(?!) 22:56, 12 December 2005 (UTC)

Hi. There is no default value selected at Search radio buttons group and if not selected by user appears an error. --Colegota 16:09, 13 December 2005 (UTC)

Uh, tehre is a default value (20), it's marked as checked="checked" in HTML... what browser are you using? Even if the browser would not send a value for the radio buttons, 20 would still be used. Can you give me the URL for the error? -- Duesentrieb^(?!) 16:14, 13 December 2005 (UTC)

Sorry! It happened just one time. Later the 20 value is always selected. The error message talks about "wrong value -20 (minus sign)". But probably some cache problem. At this moment I'm using an Internet Explorer 6.0 under Win2000 and proxys, firewalls and more "filtering products". Now I'm returning to home page for every new test and forcing ctrl+F5 to ensure the latest version. --Colegota 16:49, 13 December 2005 (UTC)

Can be CommonSense smarter?

moved here from commons:User talk:Duesentrieb -- Duesentrieb 15:32, 9 January 2006 (UTC)

Hi! Now Commonsense is working as I asked for. But using it I found some features that maybe can be improved. I don't know if it's possible or interesting. I'm a programmer and I used for example to sql, but I don't know if it's applicable in wikipedia, and of course, if you have time to do it or find interest on it. So I just will put here my "brainstorm" and you act as you consider. I'm a little busy today so I'll put a comment every time I can do a new test.

• First at all, one thinking. I tryed to put just the name of a place and it returns me the pages on wikipedias that matches the city and common categories. I think it's useful for people that want to start a new wikipedia article. Maybe can be interesting "export" the tool to wikipedia users. Maybe can be problems with overload of servers due to searches... :?

• As you know places in Commons are named in native language while in Wikipedias are in "local" wikipedia language. So there is cases as "Turpan", "Yarkand" that in wikipedias are called in a different way so it not appears in CommonSense. It is possible when CommonSense find a macth in a Wikipedia "read" the Interwiki entries? Example, test "Turpan". It's found as commons::en:Turfan because there is a redirection from commons::en:Turpan, but take a look to interwiki on that page and you'll find 9 wikipedias instead of 3.

• In "Turpan" example, commons::Category:Turpan is a child of commons::Category:Cities_along_the_Silk_Road. This is interesting for a "newcomer". Maybe a "Related categories" sections in CommonSense results?

• • you can get that info by clicking the "tree" link at the category.

Ok. --Colegota 17:03, 13 December 2005 (UTC)

• Humm... that's strange... if I put "Turpan" or "Turfan" it find some pages at wikis, but when I put

es: Las Ruinas de Jiaohe se encuentran a unos 8 Km al oeste de Turfán. Fue una ciudad fronteriza en tiempos de la dinastía Han que había de servir de protección hasta que fue conquistada y destruida por Gengis Khan.

en: Jiaohe ruins are 8 km west of Turfan. Was a border garrison town in the Han dinasty until Gengis Khan destroyed it.

(that includes "Turfan") there is no match pages... :?

• • I get matches: [3].

I mean "Wikipedia pages". In the above url there is only a Commons page. --Colegota 17:03, 13 December 2005 (UTC)

When reporting something like this, please provide the URL, so I can reproduce it. -- Duesentrieb^(?!) 16:42, 13 December 2005 (UTC)

Ok. --Colegota 17:03, 13 December 2005 (UTC)

• There is an commons::Category:Uyghur people, but the word "Uyghur" returns no macthes in commons categories. I suppose that there is an "exact match" search. It's possible a "word match search"?

• • word match search is not possible directly on the databases, because they lack an appropriate index. Also, it would be much, much slower. Sure, it would be nice to have, but it's not practicable right now.

Ok. --Colegota 17:03, 13 December 2005 (UTC)

• • Anyway... copying the full description is not a good way to get meaningful keywords, there's a lot of "noise" there. Better enter them by hand. For multi-word keywords, use "_" instead of space, like in a Wikipedia URL. -- Duesentrieb^(?!) 16:42, 13 December 2005 (UTC)

yes, but it's easy for me to take a text for a wikipedia or Internet page describing the place and "remove visually the noise" that select the meaningful keywords by myself. Usually I got the images but not the "knowledge". :) --Colegota 17:03, 13 December 2005 (UTC)

• It's possible to "move" a (random) image found with CommonSense from a wiki directly to commons without having to download it to PC and upload it later to Commons?

• • In theory, yes, but that would be cool. But it's hard to do: I would have to deal with your login, keep a session, parse + fill html forms, download and re-upload the picture (which may take quite long), etc. MediaWiki does not have a decent bot interface. That makes things harder. -- Duesentrieb^(?!) 12:40, 14 December 2005 (UTC)

(to be continued)

--Colegota 13:30, 13 December 2005 (UTC)

Spanish interface for CommonSense

moved here from commons:User talk:Duesentrieb -- Duesentrieb 15:32, 9 January 2006 (UTC)

Main page

Find out into which categories an image belongs on the commons.

Encuentra las categorías a las que pertenece una imagen en Commons.

Labels:

---

Set Laguage -> Cambiar idioma -> Español

Image -> Imagen

Keywords -> Palabras clave

Produce raw output (for bots) -> Producir salida "en crudo" (para bots)

Image is on Commons -> La imagen está en Commons

Search -> Buscar en

All Wikipedias -> Todas las Wikipedias

Additional -> Adicional

Find Categories -> Encontrar categorías

Random Orphan -> Huérfana al azar

Random image -> Imagen al azar

Only the wikis I listed -> Sólo en las wikis que indico

Image in a Wiki (or not yet uploaded) -> La imagen está en una wiki (o no ha sido subida aún)

Help text:

---

Please enter an image or some keywords (or both) to categorize. You can use the "Random Orphan" button to categorize an orphan image on the commons, or the "Random Image" button to categorize a random image from a given wiki.

Por favor, introduce una imagen y/o palabras clave para categorizar. Puedes usar el botón "Huérfana al azar" para categorizar imágenes huérfanas de Commons. O bien, el de "Imagen al azar" para categorizar una imagen al azar de una wiki dada.

You may give the domain names of additional wikis (e.g. fr.wiktionary.org) where the image may be used or the keywords may be found; for Wikipedias, you can just give the language code (e.g. en instead of en.wikipedia.org). You can specify multiple projects separated by commas.

Puedes poner los nombres de dominios de más wikis (ej. es.wiktionary.org) en las que la imagen puede ser usada o las palabras claves encontradas. O puedes poner el código del idioma (ej. "es", en lugar de es.wikipedia.org). Puedes especificar múltiples proyectos separados por comas.

Give the domain name of the wiki (e.g. fr.wiktionary.org) to search for the image and/or keywords; for Wikipedias, you can just give the language code (e.g. en instead of en.wikipedia.org).

Pon el nombre de dominio de la wiki (ej. es.wiktionary.org) en el que buscar la imagen y/o las palabras claves. Para las wikipedias, puedes poner simplemente el código del idioma (ej. "es", en lugar de es.wikipedia.org).

Credits:

---

This script is developed and maintained by Duesentrieb. It is work in progress but will eventually be released under the GPL. The source code is available on request.

Script desarrollado y mantenido por Duesentrieb. Se encuentra actualmente en desarrollo, pero será publicado oportunamente bajo GPL. El código fuente está disponible mediante petición.

Search results

Image Description of -> Descripción de la imagen

[edit description page] -> [editar la descripción de la página]

Searching for categories... -> Buscando categorías...

Image:Angers_rameau.jpg is used in the following pages:

Imagen:xxxxxxxxxx.jpg aparece en las siguientes páginas:

Use _keywords from the description text_ to find more categories

Usar _palabras clave a partir de la descripción_ para encontrar más categorías

Suggested Categories -> Categorías sugeridas

(explore) -> (explorar)

Please verify that the above categories indeed match the subject of the image before applying them. Please also look into those categories to see if there are more specific galleries or categories that match the image.

Por favor, comprueba que las categorías sugeridas se corresponden con el contenido de la imagen antes de aplicarlas. Por favor, mira también en el interior de dichas categorías para ver si hay galerías o categorías más específicas que concuerden con la imagen.

Suggested Galleries -> Galerías sugeridas

Nothing found, sorry. Try adding more wikis or entering some keywords.

Lo siento, no se encuentra nada. Inteta añadir más wikis o introducir más palabras clave.

The keywords match the following pages:

Las palabras clave concuerdan con las siguientes páginas:

No matches found in any of the wikis specified! Please try to add keywords or search more projects.

¡Ningún resultado encontrado en las wikis especificadas! Por favor, intenta añadir más palabras clave o buscar en más proyectos.

The image is not used in any of the given projects.

La imagen no se está utilizando en ninguno de los proyectos especificados.

Image not found on commons.wikimedia.org!

¡Imagen no encontrada en commons.wikimedia.org!

¿Any else? Regards, --Colegota 09:11, 14 December 2005 (UTC)

---

Wow, thanks! I'll make a spanish language file soon, probably tomorrow evening (I don't have much time today). A few things are missing, especially error messages - I can tell you exactly when I have integrated your translations. Thanks again! -- Duesentrieb^(?!) 12:42, 14 December 2005 (UTC)

Ok, I have put the first spanish version online - try it out! here are the messages that are missing:

• failed to connect to database for $1
• unknown project: $1
• Failed to load info for $1 from commons!
• Failed to load page $1 from commons!
• Keywords not found on any of the given projects.
• Please specify an image or some keywords
• Please specify a project to search in

I have posted the full language file here: commons:User:Duesentrieb/CommonSense messages - have a look if you like. And thank you for your help! -- Duesentrieb^(?!) 15:23, 14 December 2005 (UTC)

It looks fine but "credits". I suppose that there is no entries on message files for it. About message files, for next time you can publish it on a different page for every language (like this) and we can editi it directly. Regards, --Colegota 08:39, 15 December 2005 (UTC)

Error messages

failed to connect to database for $1

(1) Error conectando a la base de datos para $1

unknown project: $1

Proyecto desconocido: $1

Failed to load info for $1 from commons!

(1) ¡Error al cargar información para $1 desde Commons!

Failed to load page $1 from commons!

¡Error al cargar la página $1 desde Commons!

Keywords not found on any of the given projects.

No se han encontrado palabras clave en ninguno de los proyectos especificados.

Please specify an image or some keywords

Por favor, especifique una imagen o algunas palabras clave.

Please specify a project to search in

Por favor, especifique un proyecto en el que buscar

(1) Can be a little different depending on meaning of $1. If the result in English is like "for Image", will be better "para la Imagen". If it can have different meanings (Images, categories, keywords...) let me know.

Regards, --Colegota 07:56, 15 December 2005 (UTC)

logic templates on commons

On commons I saw your inclusion of ! in helper templates. Do you favor putting the logic templates in there too (boolxor, qif etc) or do you prefer we mirror the WP supercats- esoteric templates and or logic templates? -MakThorpe 17:51, 29 April 2006 (UTC)

I don't really care... for my tools to work, all templates should be categorized somehow (at least all templates thta are used on image pages). And i need clear categories for license things. The only reason i'm categorizing other stuff right now is to find out what license tags I have been missing :)

all that being said: With the new parser functions, I hope we can get rid if the logic and esotheric templates - so having one category "helper templates" for the remaining stuff is probably best. -- Duesentrieb 01:47, 30 April 2006 (UTC)

Improving bot grabbed categories

Hello. I see many miscategorized images on Wikimedia:Commons.

I notice many bot imported images have supercategories which should never go on individual images, for example "Category:Image source" or "Category:People by nationality". Perhaps the bot could have a list of inappropriate categories not to include on images?

Also, could the bot to use "(year) births" and "(year) deaths" categories? Example: Commons:Image:David Wilkie.jpg "Category:1785 births" "Category:1841 deaths", not "Category:1785" "Category:1841". "Category:(year)" should be date of image.

Thank you for your attention. -- Infrogmation 14:11, 18 July 2006 (UTC)

todo

Thanks for the suggestion. Maintaining a heard coded list of "bad" categories seems a bad idea - but if such categories where marked with a template, I could easily filter them out.

About the birth and death thigs: i didn't even know we had those categories on commons. Anyway, CommonSense does not know if the image shows a person, or if some year showing up is the date of birth, death, or when the image was taken. To get this right, simply add/fix the Commonscat template on the gallery in your local wiki. CommonSense looks for pages where the image is used, looks for categories this page is in, and tries to map them to commons, falling back on parent categories if no match is found. A match is found if the category has the same name, or there's a Commons or Commonscat template linking to commons. -- Duesentrieb 23:06, 18 July 2006 (UTC)

Fehlermeldung

Hallo Duesentrieb, das Programm funktioniert nicht mehr, es kommt immer wieder eine Fehlermeldung wenn er nach entsprechenden Kategorien sucht. Liesel 10:57, 14 October 2006 (UTC)

The error message looks typically like this:

Fatal error: Uncaught exception 'DBQueryError' with message 'A database error has occurred Query: SELECT page_id, page_namespace, page_title, page_len, page_touched, page_is_redirect, rev_id, rev_timestamp, old_id as text_id, old_text as text, old_flags as text_flags FROM text JOIN revision ON rev_text_id = old_id JOIN page ON rev_id = page_latest WHERE page_title = 'Cableway' AND page_namespace = 0 Function: fetchWikirecord Error: 1146 Table 'enwiki_p.revision' doesn't exist (zedler.ts-local) ' in /home/daniel/MediaWiki-live/phase3/includes/Database.php:684 Stack trace: #0 /home/daniel/MediaWiki-live/phase3/includes/Database.php(641): Database->reportQueryError('Table 'enwiki_p...', 1146, '? ...', 'fetchWikirecord', false) #1 /home/daniel/public_html/WikiSense-live/common/WikiAccess.php(880): Database->query('? ...', 'fetchWikirecord') #2 /home/daniel/public_html in /home/daniel/MediaWiki-live/phase3/includes/Database.php on line 684.

--Túrelio 13:29, 14 October 2006 (UTC)

If this message is German for "CommonSense appears to be broken", then I just came to say that a number of Commons users are reporting this too. Any idea when it will be fixed? pfctdayelise 01:30, 15 October 2006 (UTC)

I think everyone is getting it. --68.218.229.35 22:12, 16 October 2006 (UTC)

I have created a dummy-view for enwiki while the dump is replaying again. I hope, your tools work now. --DaB. 00:15, 18 October 2006 (UTC)

Mistreatment of ampersands

Try the Categorize tool on commons:Image:Bunbury & Vegas.jpg [4]. It cannot find the file because of the ampersand.

The tool itself handels the ampersand fine: [5]; The JavaScript code that creates the "extra tab" seems to have a problem with that, though. Please ask Arnomane about it. -- Duesentrieb 00:39, 5 November 2006 (UTC)

Adding categories that shouldn't be added

As I said on IRC, it automatically suggests: commons:Category:Categories requiring diffusion commons:Category:Articles to be merged

Yonatanh 21:13, 11 February 2007 (UTC)

css syntax error in generated source

Hi Duesentrieb, there is a minor css typo in the generated page, e.g. [6]: <div class='box' style='clear:both; magrin-top:1ex;'> --Herzi Pinki 20:12, 10 May 2007 (UTC)

another one in the same file:

                        div.thumb {
                            float:right;
                            margin: 1ex, 0, 1ex, 1ex;

margin args should be with separating spaces only, no commas --Herzi Pinki 20:19, 10 May 2007 (UTC)

Thanks for pointing this out. Fixed now. -- Duesentrieb 20:31, 10 May 2007 (UTC)

Bug

http://tools.wikimedia.de/~daniel/WikiSense/CommonSense.php?i=Oclusiva_velar_sonora.ogg&go-clean=yes

führt zu

Catchable fatal error: Object of class stdClass could not be converted to string in /home/daniel/public_html/WikiSense-live/common/WikiAccess.php on line 811

--82.21.106.117 17:28, 15 May 2007 (UTC)

FIxed. Thanks for noticing. -- Duesentrieb 23:41, 15 May 2007 (UTC)

Database Error:

When trying to access the Gallery I get this: Database Error: Host 'hemlock.ts-local' is not allowed to connect to this MySQL server (sql). 68.218.130.225 00:33, 4 July 2007 (UTC)

Database Error II:

Ich arbeite an einer Erweiterung der Seite Zellengefängnis Lehrter Straße. Dort möchte ich ein von mir aufgenommenes und bearbeitetes Panorama-Bild einstellen (weil es einfach fehlt!). Der Bildname ist:
von-allem-leid_panorama_w3795.jpg.

Wenn ich mein Bild kategorisieren will, erhalte ich immer folgende Meldung:
A database error has occurred Query: SELECT * FROM enwiki_p.image WHERE img_name = 'Von-allem-leid_panorama_w3795.jpg' Function: Error: 1146 Table 'enwiki_p.image' doesn't exist (sql-s2)

Eventuell steht das im Zusammenhang mit meinem Problem, dass das Bild zwar korrekt hochgeladen wurde, das Thumb aber nicht angezeigt wird. Anweisung:
[[Bild:von-allem-leid_panorama_w3795.jpg|thumb|upright=1.69|Zitat aus Albrecht Haushofers "Moabiter Sonette"]]

Was besagt die Meldung? Warum - verflixt noch eins - wird das Thumb nicht angezeigt? Hilfe!!!
--Lypô 00:12, 17 July 2007 (UTC)

Warning & Fatal error when searching categories via keywords

Hello,

A few searches worked, but eventually I received the following errors:

Searching for categories... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/daniel/MediaWiki-live/phase3/includes/Database.php on line 1566 Fatal error: Call to a member function selectField() on a non-object in /home/daniel/MediaWiki-live/phase3/includes/ExternalStoreDB.php on line 107

Thanks! Earthsound 15:28, 16 August 2007 (UTC)

Suggested categories and galeries

The tool look fine but something let me puzzled: who to change "suggested" in reality? -- fr:User:SerSpock 16:37, 21 October 2007 (UTC)

Looks Arabic

Looks arabic here. Maybe a cache problem? Jidanni 05:23, 16 November 2007 (UTC)

Broken?

Fatal error: Call to a member function selectField() on a non-object in /home/daniel/MediaWiki-live/phase3/includes/ExternalStoreDB.php on line 107

on every search I've tried so far --121.73.5.55 10:56, 10 December 2007 (UTC)

Interface Common Sense für nl.wikipedia.org

Bester Duesentrieb, das Wort categorie hat wie im Deutsch die Betonung auf der letzten Silbe. Mehrzahl ist deshalb immer: categorieën. Zu verbessern seien deshalb (in der Reihenfolge van oben bis unten):

categerieën → categorieën
Bezig met zoeken naar categoriën... → categorieën
Gebruik zoektermen uit de beschrijving om meer categorieë te vinden → ... categorieën ...
een meer specifieke categie van toepassing is voor de afbeelding → een specifiekere
categorie bij de afbeelding past.
und auch:
(oben:) altublieft → alsjeblieft (oder ( aber das ist gehobener): alstublieft )
(letzte Sätze:) zweimal "alstublieft" ist auf Niederländisch des guten zuviel. Sie können es besser
nur einmal verwenden als "alsjeblieft" auf der ersten Stelle oder die Abkürzung ajb. (anstatt
a.u.b.) ist auch üblich. Die Kongruenz spielt hier mit: mit "alstublieft" sollte man auch 
schreiben: "Controleert u ook alstublieft" und "Kijkt u ook alstublieft"! Das ist für Wikipedianen 
heute zu gehoben.

Also →

Controleer ajb. of de bovenstaande categorieën inderdaad
van toepassing zijn alvorens ze toe te voegen. Kijk ook in de categorie om te bepalen
of een specifiekere categorie bij de afbeelding past.

Ich war hier anlässlich http://tools.wikimedia.de/~daniel/WikiSense/CommonSense.php?u=nl&i=Conservative+Force+Gravity+Example.svg&kw=&go-clean=Zoek+categorie%C3%ABn&cl=nl.wikipedia.org&p=&w=nl.wikipedia.org&v=0#resulthttp://tools.wikimedia.de/~daniel/WikiSense/CommonSense.php?u=nl&i=Conservative+Force+Gravity+Example.svg&kw=&go-clean=Zoek+categorie%C3%ABn&cl=nl.wikipedia.org&p=&w=nl.wikipedia.org&v=0#result

Sie finden mich hier

Kollegiale Gruesse, Dartelaar [write me!] 16:46, 22 December 2007 (UTC)

bene baku

bene baku

benetel.afrikblog.com Vote on rewriting stewards policy is now open.

Editing User talk:Duesentrieb/CommonSense (comment) From Meta Jump to: navigation, search Warning: You are not logged in. Your IP address will be recorded in this page's edit history.

   Subject/headline: 

bene baku Please note that all contributions to Meta are considered to be released under the GNU Free Documentation License (see Meta:Copyrights for details). If you don't want your writing to be edited mercilessly and redistributed at will, then don't submit it here. You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. DO NOT SUBMIT COPYRIGHTED WORK WITHOUT PERMISSION!

  Cancel | Editing help (opens in new window) 

Do not copy text from other websites without permission. It will be deleted. Insert: – — … ° ≈ ≠ ± − × ÷ ← → · § Sign your name: 66.36.196.188 19:49, 21 January 2008 (UTC)

---

Wiki markup: {{}} | [] [[]] [[|]] [[Category:]] #REDIRECT[[]]

• (templates)

Symbols: ~ | ¡ ¿ † ‡ ↔ ↑ ↓ • # ¹ ² ³ ½ ⅓ ⅔ ¼ ¾ ⅛ ⅜ ⅝ ⅞ ‘ “ ’ ” ¢ $ € £ ¥ «» „“ Characters: Á á Ć ć É é Í í Ĺ ĺ Ń ń Ó ó Ŕ ŕ Ś ś Ú ú Ý ý Ź ź À à È è Ì ì Ò ò Ù ù  â Ĉ ĉ Ê ê Ĝ ĝ Ĥ ĥ Î î Ĵ ĵ Ô ô Ŝ ŝ Û û Ŵ ŵ Ŷ ŷ Ä ä Ë ë Ï ï Ö ö Ü ü Ÿ ÿ ß Ã ã Ẽ ẽ Ĩ ĩ Ñ ñ Õ õ Ũ ũ Ỹ ỹ Ç ç Ģ ģ Ķ ķ Ļ ļ Ņ ņ Ŗ ŗ Ş ş Ţ ţ Đ đ Ů ů Ǎ ǎ Č č Ď ď Ě ě Ǐ ǐ Ľ ľ Ň ň Ǒ ǒ Ř ř Š š Ť ť Ǔ ǔ Ž ž Ā ā Ē ē Ī ī Ō ō Ū ū Ȳ ȳ Ǣ ǣ ǖ ǘ ǚ ǜ Ă ă Ĕ ĕ Ğ ğ Ĭ ĭ Ŏ ŏ Ŭ ŭ Ċ ċ Ė ė Ġ ġ İ ı Ż ż Ą ą Ę ę Į į Ǫ ǫ Ų ų Ḍ ḍ Ḥ ḥ Ḷ ḷ Ḹ ḹ Ṃ ṃ Ṇ ṇ Ṛ ṛ Ṝ ṝ Ṣ ṣ Ṭ ṭ Ł ł Ő ő Ű ű Ŀ ŀ Ħ ħ Ð ð Þ þ Œ œ Æ æ Ø ø Å å Ə ə • Greek: Α α Β β Γ γ Δ δ Ε ε Ζ ζ Η η Θ θ Ι ι Κ κ Λ λ Μ μ Ν ν Ξ ξ Ο ο Π π Ρ ρ Σ σ ς Τ τ Υ υ Φ φ Χ χ Ψ ψ Ω ω Cyrillic: А а Б б В в Г г Ґ ґ Ѓ ѓ Д д Ђ ђ Е е Ё ё Є є Ж ж З з Ѕ ѕ И и І і Ї ї Й й Ј ј К к Ќ ќ Л л Љ љ М м Н н Њ њ О о П п Р р С с Т т Ћ ћ У у Ў ў Ф ф Х х Ц ц Ч ч Џ џ Ш ш Щ щ Ъ ъ Ы ы Ь ь Э э Ю ю Я я IPA: t̪ d̪ ʈ ɖ ɟ ɡ ɢ ʡ ʔ ɸ ʃ ʒ ɕ ʑ ʂ ʐ ʝ ɣ ʁ ʕ ʜ ʢ ɦ ɱ ɳ ɲ ŋ ɴ ʋ ɹ ɻ ɰ ʙ ʀ ɾ ɽ ɫ ɬ ɮ ɺ ɭ ʎ ʟ ɥ ʍ ɧ ɓ ɗ ʄ ɠ ʛ ʘ ǀ ǃ ǂ ǁ ɨ ʉ ɯ ɪ ʏ ʊ ɘ ɵ ɤ ə ɚ ɛ ɜ ɝ ɞ ʌ ɔ ɐ ɶ ɑ ɒ ʰ ʷ ʲ ˠ ˤ ⁿ ˡ ˈ ˌ ː ˑ ̪ •

Your changes will be visible immediately. For testing, please use the sandbox instead. On talk pages, please sign your comment by typing four tildes (66.36.196.188 19:49, 21 January 2008 (UTC)).

---

Please note: If you don't want your writing to be edited mercilessly or redistributed by others, do not submit it. Only public domain resources can be copied without permission—this does not include the vast majority of web pages or images.

Retrieved from "http://meta.wikimedia.org/wiki/User_talk:Duesentrieb/CommonSense" ViewsUser page Discussion Edit + History Personal toolsLog in / create account Navigation Main Page Goings-on Wikimedia News Translations Recent changes Random page Help Beyond the web Meet Wikimedians Events Chapters DVDs Wikimania Donate community Metapub Babel Babylon Planet Wikimedia Communication Projects Group Search

   Toolbox

What links here Related changes Upload file Special pages

Privacy policy About Meta Disclaimers

doppelte Kategorien

Bei der raw-Ausgabe erscheinen manchmal Kategorien und Galerien doppelt, z.B. http://tools.wikimedia.de/~daniel/WikiSense/CommonSense.php?u=de&i=Tiger.jpg&r=on&kw=&p=_20&go-clean=Kategorien+finden&cl=&w=de&v=0 --Luxo 22:12, 9 February 2008 (UTC)

Sehe gerade dass es nicht nur bei der raw-ausgabe ist: http://tools.wikimedia.de/~daniel/WikiSense/CommonSense.php?u=de&i=Tiger.jpg&kw=&p=_20&go-clean=Kategorien+finden&cl=&w=de&v=0#result --Luxo 22:24, 9 February 2008 (UTC)

Orphaned

I see Orphaned banner on http://tools.wikimedia.de/~daniel/WikiSense/Gallery.php?wikifam=commons.wikimedia.org&img_user_text=Barefact , and do not know what I should do to de-Orphane it. Any good advice? 68.4.254.157 05:57, 11 February 2008 (UTC)

Hidden categories

Manchmal (z.B. hier) wird die Category:Hidden categories aufgeführt, das ist eigentlich nicht so sinnvoll, da diese ja nur automatisch mit __HIDDENCAT__ verwendet werden sollte. Diese könnte man sicher rausfiltern. --Luxo 11:39, 25 May 2008 (UTC)

Defsort

Would it be possible, to transfer the defaultsort-line from the wiki, where the pic is taken from? At least for pictures from en-wp it would be usefull. Maybe it could be extracted from the category-lines, but that might be another step. --79.199.238.85 17:27, 21 August 2008 (UTC)

Image not found on commons.wikimedia.org!

but it is there, am I doing something wrong. [7]. Thanks Edmund Patrick 15:18, 14 September 2008 (UTC)

Meta Categories

Hiya. I've created a template on Commons, {{MetaCat}}, to identify categories which are just containers for other categories. These categories should not contain any media just sub categories. An example of this would be Food by country, which acts as a contain for thing like Cheese by country and Food of Spain. Can you make CommonSense aware of this template and not add files to categories tagged with it? Railwayfan2005 20:53, 16 January 2009 (UTC)

Nicht nachvollziehbare Verknüpfungen

Mir sind ein paar komische von CommonSense verursachte Zuordnungen aufgefallen. So führen bestimmte Wartungsvorlagen in der fr dazu, dass Bilder in commons:category:maintenance eingeordnet werden. Vermutlich sind das folgende Verknüpfungen:

1. fr: fr:Modèle:Pas fini und fr:Modèle:Suppression -> commons:category:maintenance
2. en: en:Template:Include-USGov -> commons:Category:Image sources

Das sind die zwei dicksten Brocken die mir aufgefallen sind. --Nachcommonsverschieber 20:30, 21 April 2009 (UTC)

Qualität der Ergebnisse

Hallo Duesentrieb, ich bin gestern zum ersten Mal auf das CommonSense-Tool aufmerksam geworden. Generell finde ich die Idee ganz toll, nur bei dem von mir hochgeladenen Bild waren nahezu alle vom Tool ergänzten Kategorien falsch. Kann sein, dass es sich hierbei nur um einen Einzelfall handelt, aber um ganz sicher zu gehen, frage ich lieber nochmal nach: gibt es Untersuchungen dazu, in wievielen Fällen das Tool danebenliegt? Ich bin nur ganz selten auf Commons und wenn ich nicht zufällig gestern nochmal dort vorbeigeschaut hätte, wäre das Bild wahrscheinlich bis in alle Ewigkeit falsch kategorisiert geblieben. Grüße --Frank Schulenburg 18:03, 1 June 2009 (UTC)

Broken?

Database Error: Unknown database 'u_multichill_commons_categories_p' (sql) on sql/u_multichill_commons_categories_p

Fatal error: Call to a member function addQuotes() on a non-object in /home/daniel/public_html/WikiSense-live/common/FilterCats.php on line 48

Thanks Secretlondon 20:51, 1 July 2009 (UTC)

Please filter out Category:Media with locations

I noticed that BotMultichill added this category to an image which did not include geocoding information. The category should never be added manually without the use of a template, so it can safely be excluded from suggestions. —LX (talk, contribs) 20:16, 22 July 2009 (UTC)

please check

• strange Category:First steps here
• wrong Category:Bundesarchiv here and with several other politicians

Thank you! --Elya 18:13, 9 August 2009 (UTC)

Commonsense not working

Hey Daniel. Any ideas why [8] isn't working? I can't help getting the feeling I'm doing it wrong somehow... Always so reliable :) Jarry1250 (talk) 16:44, 10 May 2010 (UTC)

Chile vs. chili

Looks like the tool has some problems distinguishing between the country Chile and the spice chili. E.g. [9], [10]. Palosirkka (talk) 14:14, 18 March 2012 (UTC)

Nonsense categorization of builings

In recent months, I have removed at Commons a lot of buildings that were for some reason categorized, usually simultaneously, in the following categories:

• Category:Cartography
• Category:Classification systems
• Category:Encodings
• Category:Geographic information systems
• Category:Identifiers

Recently, new images of buildings and landscapes, transferred from en.wikipedia have been categorized that way. The uploader I asked about it blamed the uploading bot, and the owner of the uploading bot told me that the CommonSense category finder may be the culprit. Can you please check seriously whether this is the case? It saves me or others repeatedly the time of having to clean up these categories by hand again and again. KKoolstra (talk) 11:42, 10 July 2012 (UTC)

Nonsense cats added

Please see Diff and add this autogenerated cat to a blacklist. This diff shows another nonsense category added by Common Sense functions. Thanks. --Denniss (talk) 17:28, 14 December 2012 (UTC)

Not working: curl error?

Every time I try to use CommonSense by choosing "Find categories" from the Vector dropdown, I keep getting errors like the following:

" - curl returned an error: Couldn't resolve host 'rr.pmtpa.wikimedia.org'
Failed to load info for Image:<filename> from commons.wikimedia.org!"

and then a whole bunch more of the curl error lines repeated below in smaller type. I assume this is a bug. --Darkwind (talk) 06:41, 20 January 2013 (UTC)

I am also getting this error, directly from the CommonSense page:

- curl returned an error: Couldn't resolve host 'rr.pmtpa.wikimedia.org'

Failed to load info for Image:Teresa Stanek Rea.jpg from commons.wikimedia.org!

Searching for categories...

. . . . . . . . . . . . . . . . . . . . . .

- curl returned an error: Couldn't resolve host 'rr.pmtpa.wikimedia.org'

(repeated 40 times or so)

- curl returned an error: Couldn't resolve host 'rr.pmtpa.wikimedia.org'

. Fatal error: Maximum execution time of 30 seconds exceeded in /home/daniel/public_html/WikiSense-live/common/FilterCats.php on line 70

TJRC (talk) 18:18, 5 February 2013 (UTC)

It's doing the same from images on English Wikipedia Ronhjones (talk) 16:45, 31 March 2013 (UTC)

Database Error: Unknown database 'u_multichill_commons_categories_p'

This showed up every time I tried to use CommonSense just now.

Database Error: Unknown database 'u_multichill_commons_categories_p' (sql-s2) on sql-s2/u_multichill_commons_categories_p
Fatal error: Call to a member function addQuotes() on a non-object in /home/daniel/public_html/WikiSense-live/common/FilterCats.php on line 48 

I didn't see it previously reported. JesseW (talk) 05:36, 31 May 2013 (UTC)

Not on English Wikipedia

I want to upload a photo from the US Federal Government, in PNG format, using Commonist. I am trying to use this tool to find categories. Here is the jpg version on my talk page:

http://en.wikipedia.org/wiki/File:Michael-Meehan_OfficialPhoto_4x5-214x300.jpg

Your tool does not find it. Must I have a PNG version on English Wikipedia for your tool to work? Alternative: If I add the photo on the commons, can I then find categories using this tool and add them to Commons? --Dthomsen8 (talk) 12:44, 9 July 2013 (UTC)

Clicking the random orphan button produces database error

When I click the "random orphan" button, I get an error: A database error has occurred

Query: SELECT I.page_title as title FROM page AS I USE INDEX(page_random) LEFT JOIN categorylinks AS L ON (I.page_id = L.cl_from AND L.cl_to NOT IN ('GFDL', 'GPL', 'LGPL', 'Public_domain', 'PD', 'PD-self', 'PD-user', 'PD_Old', 'PD_Art', 'PD_US', 'PD_US_Government', 'PD_NASA', 'PD_US_Military', 'Patents', 'Russian_official_symbols', 'PD_Soviet', 'CC-BY-SA-2.5', 'CC-BY-SA-2.1', 'CC-BY-SA-2.0', 'CC-BY-SA-1.0', 'CC-SA-1.0', 'CC-BY-1.0', 'CC-BY-2.0', 'CC-BY-2.5', 'BSD_images', 'Copyrighted_free_use', 'Copyrighted_free_use_provided_that', 'Self-published_work', 'Unknown', 'Own_work', 'Incomplete_license', 'Unknown')) LEFT JOIN ( imagelinks AS P JOIN page as A ON A.page_id = P.il_from AND A.page_namespace = 0 ) ON I.page_title = P.il_to WHERE I.page_namespace = 6 AND L.cl_from IS NULL AND P.il_to IS NULL AND I.page_random > 0.50099387648562 ORDER BY I.page_random LIMIT 1

Function: randomImage Error: 1176 Key 'page_random' doesn't exist in table 'page' (sql-s4)

67.100.127.81 02:20, 21 August 2013 (UTC)