ListeriaBot

Interwiki linking

Hey Magnus, I love the new Wikidata list template functionality, but there is one problem with it. On English Wikipedia, we prefer having redlinks (or no links) over interwiki links. This is because interwiki links in article text are confusing and unexpected for readers. For example, if a reader clicked on the blue link for Landscape with a Church from List of paintings by Jacob van Ruisdael, they would expect to go to an English Wikipedia article about that painting, not a Wikidata page. Please consider changing this linking behavior for the bot. Thanks! Kaldari (talk) 21:44, 12 September 2015 (UTC)

@Kaldari: Check out the manual; adding "links=red" to the template call should do what you want. --Magnus Manske (talk) 22:03, 12 September 2015 (UTC)

@Magnus Manske: If I use links=local or links=red, the titles are no longer in italics. Is there a way to fix that? Kaldari (talk) 00:43, 14 September 2015 (UTC)

Actually, the italics only indicates links to Wikidata. Since neither "local" nor "red" will link to Wikidata anymore, this is a feature, not a bug. --Magnus Manske (talk) 08:33, 14 September 2015 (UTC)

@Magnus Manske: On English Wikipedia, all painting titles are supposed to be in italics, per standard English grammar. Kaldari (talk) 07:58, 15 September 2015 (UTC)

I'm sure they are, but implementing complex per-column options is time-consuming, and there is only so much I can do, as per my watch :-) --Magnus Manske (talk) 11:43, 15 September 2015 (UTC)

Hi Magnus! What about a links=reasonator? I'm sure you understand what I mean. -geraki ^talk 13:03, 5 November 2015 (UTC)

Done (example). --Magnus Manske (talk) 13:14, 5 November 2015 (UTC)

Ευχαριστώ! -geraki ^talk 12:15, 6 November 2015 (UTC)

A language fallback parameter would be handy, something like lang=en,fr.

1. Then a list of french paintings in english wikipedia could display the french titles instead of "Q21281161".
2. Also, it can be added to the reasonator link.

-geraki ^talk 12:22, 6 November 2015 (UTC)

I copy here the text I have written here:

Hi Magnus I have been messing around with this template in Basque Wikipedia and we find a problem with the links. In small Wikipedias most of the links are not going to work, as we don't have a very big collection of articles. For example if I try to get a list of all the films make by a director, I will get a lot of QXXXXX links. If I put to show the actors of this films the same happens. As the actors name doesn't make any variation in basque (Bud Spencer is eu:Bud Spcencer) it would be great to have a render option where the english (or another language) label appears as a red link. It will be easily readable by the people, and internally it is a red link, no more. Is there any way to achieve this? -Theklan (talk) 15:43, 15 February 2016 (UTC)

Gmail Thang dinh55 (talk) 20:29, 16 January 2020 (UTC)

Chemical structures

chemical structure (P117) is a file, but ListeriaBot only shows the file name and not an image. Example: User:Kopiersperre/Herbicides--Kopiersperre (talk) 13:41, 16 September 2015 (UTC)

@Magnus Manske: Hallo Magnus,

könntest du bitte ListeriaBot anweisen, P117 genauso wie P18 zu behandeln, da es sich auch um ein Bild handelt?--Kopiersperre (talk) 14:47, 8 October 2015 (UTC)

Erledigt, sollte beim nächsten Update behoben sein. --Magnus Manske (talk) 19:39, 8 October 2015 (UTC)

Danke--Kopiersperre (talk) 11:10, 10 October 2015 (UTC)

Query example: species named by Linnaeus

How could I get a list of species whose authority is Linneaus? I can't see a way to get a property that is inside a qualifier. -Theklan (talk) 16:28, 15 February 2016 (UTC)

ListeriaBot seems a little indecisive

For the last three edits, the bot has added and removed the same item a few times. This looks like a bug, because GNU Guix (Q18968627) has been untouched since then. NMaia (talk) 13:32, 26 May 2016 (UTC)

@Magnus Manske: Gentle ping. NMaia (talk) 15:09, 27 May 2016 (UTC)

The bot is fine. The data source is alternating. Probably a stale copy. --Magnus Manske (talk) 21:47, 28 May 2016 (UTC)

@Magnus Manske: does that mean the issue is in the Query Service? NMaia (talk) 22:15, 28 May 2016 (UTC)

As far as I can tell, yes. --Magnus Manske (talk) 19:02, 29 May 2016 (UTC)

Sort by item causing hiphop

@Magnus Manske: First list was fine, 2nd edit had wrong sorting, 3rd edit correct sorting. This makes the diff function less useful [1] 91.9.119.96 20:04, 19 June 2016 (UTC)

Well, you are using a "sort=item" parameter, which is not supported. You can't just make this stuff up and expect it to work... "item" will be ignored, and it shows whatever order comes back from WDQS. I have added "ORDER BY ?item" to the SPARQL, that should stabilize it, possibly after one change. --Magnus Manske (talk) 08:54, 21 June 2016 (UTC)

Stable sort order

When the parameter "sort" isn't given in {{Wikidata list}}, each edit tends to shuffle everything around a lot, making it harder to tell what was added or removed. Is there a way to sort just by Q-id, or anything else stable? --Yair rand (talk) 20:15, 5 January 2017 (UTC)

Ah, I see that you can just sort by ORDER BY ?item. Thanks for the helpful bot. :) --Yair rand (talk) 02:24, 9 January 2017 (UTC)

Is sort=P1448 not allowed?

It seems the sorting in the list sv:Användare:Innocent_bystander/Distrikt is not stable. Is there any reason why sorting by propery P1448 should not work?

• In this version from Jan 4 the objekt Asarums distrikt is correctly sorted as the first one in the section on Karlshamns kommun.
• But in this version from Jan 5 it is incorrectly sorted as the last one in the section.
• And in this version from Jan 6 it is back to where it was on Jan 4.

As far as I know there has been no changes in the Wikidata database that can explain these changes in the sorting. Any advice on how to deal with this problem is welcome. Larske (talk) 11:25, 7 January 2017 (UTC)

Fatal error

The Bot reports the following error:

Warning: parse_ini_file(/data/project//replica.my.cnf): failed to open stream: No such file or directory in /data/project/magnustools/public_html/php/common.php on line 57

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user @'10.68.23.47' (using password: NO) in /data/project/magnustools/public_html/php/common.php on line 126

Fatal error: Call to a member function real_escape_string() on boolean in /data/project/listeria/shared.inc on line 455

Greets, Harry Canyon (talk) 05:55, 1 June 2017 (UTC)

How to fix ?

creating a list at Odia wikipedia (https://or.wikipedia.org/s/14sj) shows the error 'Notice: Undefined property: Listeria::$header_template in /data/project/listeria/shared.inc on line 942'--MKar (talk) 04:46, 3 June 2017 (UTC)

Allow duplicate items?

Is there any way to allow for duplicate items to be displayed in a Wikidata list? Using {{Wikidata list}} with a SPARQL query seems to automatically remove all duplicate ?items from the query result. (Even better would be to be able to have queries without mandatory ?item fields at all...) --Yair rand (talk) 23:22, 9 July 2017 (UTC)

A strange typo with category items

I noticed that when ListeriaBot collects category items in its reports, it erroneously adds another column, so that items are rendered as "[[::d:Qxxx|Category:" and not as "[[:d:Qxxx|Category:". See User:Sannita/Governi for an example. Is it possible to fix this bug?  – The preceding unsigned comment was added by Sannita (talk • contribs) at 20:20, 25 August 2017‎ (UTC).

medium task

to prevent edits solely about order when order wasn't defined d1g (talk) 19:19, 28 August 2017 (UTC)

Recent Deaths list

Some IP incorrectly changed the date of Charles Manson's death to today. The bot picked this up and placed him on Wikidata:Database reports/Recent deaths and in Wikidata:Database reports/Recent deaths/gallery. I have fixed the date and the bot has recognized the change of date, but still treats it as if today's date is the claim. --Elisfkc (talk) 17:13, 17 January 2018 (UTC)

No items

The query on species:List of virus species returns "no items" when I use "Automatically update the list now", but the SPARQL query finds over 3K results. What have I missed? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 11:23, 15 February 2018 (UTC)

The query must return ?item, see the template documentation page. --Larske (talk) 11:52, 15 February 2018 (UTC)

Thank you. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 13:31, 15 February 2018 (UTC)

I think that this discussion is resolved and can be archived. If you disagree, don't hesitate to replace this template with your comment. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 13:31, 15 February 2018 (UTC)

Not working on Hiwiki

PS. Following error appearing

Trying to update सदस्य:Capankajsmilyo/श्रीदेवी... Return to सदस्य:Capankajsmilyo/श्रीदेवी Also, check out the current bot status! Status: No template match Notice: Undefined variable: wiki_id in /data/project/listeria/public_html/index.php on line 51

Help. Thanks. @Magnus Manske: Capankajsmilyo (talk) 03:06, 4 March 2018 (UTC)

Bug when no items, where previously there were items

I think there is a bug here. If a query returns items, the bot correctly creates the table. If at a later date, the same query now returns no items, it look like the table does not get updated. Is this the case? Thanks for taking a look.

I experience the same. --Hannolans (talk) 10:59, 20 March 2019 (UTC)

I'm having this problem too. @Magnus Manske: help? --LadiesMakingComics (talk) 17:40, 11 June 2019 (UTC)

@Gstupp, Hannolans, LadiesMakingComics, Magnus Manske: Bug or not, it is very unconvenient that ListeriaBot does not update with an empty table when there are no results. Maybe it is because it can not distinguish the case "no result as there is nothing to report" from "no result as something went wrong (timeout etc)". Anyway, here is what I do if I want to be sure to get the table udated by ListeriaBot even when there is no result from the original query:

• Add the following lines to the original query:

UNION 
{
 VALUES ?item { wd:Q226183 } # include a "dummy item" to always get a result from ListeriaBot
}

The result from this is that you will get a result that always include empty set (Q226183), even when there is an empty result from the original query, and thus ListeriaBot will always update the table.

This is particulary useful when you use the tool to track anomalies requiring some actions where the normal state is that there is no anomaly.

But of course I would also prefer that ListeriaBot is corrected (or upgraded) to always update the table. Possibly via a new optional parameter, like update_empty_table, to make it backwards compatible, should someone have built their universe based on the current behaviour of ListeriaBot.

--Larske (talk) 20:23, 1 November 2019 (UTC)

No updates since 11. Apr. 2018‎

Hello @Magnus Manske:, Wikidata:WikiProject Movies/new film items was not updated since 11. Apr. 2018‎, manually update is not possible, too. -- MovieFex (talk) 15:30, 20 April 2018 (UTC)

@Magnus Manske: list is updated now, but same problem at Wikidata:WikiProject Movies/lists/new films these days, last update 3. Feb. 2018‎. -- MovieFex (talk) 07:37, 29 April 2018 (UTC)

Wikidata:WikiProject France/Églises/39 : église abbatiale de Gigny

Hi Magnus ! You do a great job, but why does your robot User:ListeriaBot has just deleted the correct information about "église abbatiale de Gigny" I had added. Thanks in advance for your answer. Regards Cquoi (talk) 18:39, 24 April 2018 (UTC)

File missing

This is a bug I guess. Steak (talk) 12:23, 9 July 2018 (UTC)

KM Sorting

Could you please check the sorting of column KM between the bot result provided in German Wikipedia de:Benutzer:Derzno/Bilder and distanz out of the SPARQL below. The code is still the same but sorting works wrong by results of the bot. Q55723908 should be behind Q56241795.

SELECT ?item ?itemLabel ?befindet_sich_entlang ?befindet_sich_entlangLabel ?distanz ?distanzEinheitLabel ?bezugspunkt ?bezugspunktLabel WHERE {
  BIND(wd:Q445400 AS ?befindet_sich_entlang) .
  
  ?item p:P795 ?statementNode .
  ?statementNode ps:P795 ?befindet_sich_entlang .
  
  OPTIONAL {
    ?statementNode pqv:P2043 ?distanzNode .
    ?distanzNode wikibase:quantityAmount ?distanz .
    ?distanzNode wikibase:quantityUnit ?distanzEinheit .
  }
  OPTIONAL {
    ?statementNode pq:P2210 ?bezugspunkt .
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'de,en' }
}
ORDER BY ?distanz

Try it!

many thx in advance --Derzno (talk) 15:56, 24 August 2018 (UTC)

• @Derzno: I added "ORDER BY" in your query above. For it to work in the template, you need to remove the template parameter "|sort=label" as well.
  --- Jura 16:02, 24 August 2018 (UTC)

@Jura1:, thx but this is not the problem. Please have a look de:Benutzer:Derzno/Bilder and use the sort of KM, than you can see what's wrong with it. Don't hesitate to patch my user area ;) --Derzno (talk) 16:19, 24 August 2018 (UTC)

@Derzno: seems that sectioning and sort by quantity doesn't work well together. I could get it to work on Wikidata:WikiProject Q5/lists/people who died on their birthday.
--- Jura 16:34, 24 August 2018 (UTC)

@Jura1: many thx 4 u help. It seems thta the issue is more complicated. Anyhow I can "survive" with ORDER BY ?distanz so far. Take care and thx again. --Derzno (talk) 04:23, 25 August 2018 (UTC)

Wikidata:WikiProject Properties/Reports/Datatypes

Hello.On what basis are the types arranged from 1 to 16?Thanks David (talk) 16:46, 31 October 2018 (UTC)

• Number of properties. See "order by" in the SPARQL code. --- Jura 17:20, 31 October 2018 (UTC)

Display external URL in a shorter way

Hi @Magnus Manske:

I tried the bot on this page : Wikidata:WikiProject Materials/Standards/Testing.

Would it be possible to have the external URL displayed in a shorter way ?

I.e. http://www.astm.org/cgi-bin/resolver.cgi?D1894 could be :

• [2]
• or astm.org

This would make the tables more readable.

Regards

--Thibdx (talk) 23:28, 11 November 2018 (UTC)

Reverse editions

Hello: Why have you reversed these [3] editions? regards Ortisa (talk) 12:26, 22 November 2018 (UTC)

ListeriaBot errors

Hello, could you please have a look into [4]. I'll get a lot of errors like: Notice: Undefined offset: 814 in /data/project/listeria/shared.inc on line 786 No idea why and the input is a stupid copy and paste from an old but working page similar to this one. thx --Derzno (talk) 16:54, 14 January 2019 (UTC)

The names of the data types

Hello.Please use Template:Label it in the data type names in Wikidata:WikiProject Properties/Reports/Datatypes.Thanks David (talk) 09:27, 20 January 2019 (UTC)

ListeriaBot doesn't set the botflag for its edits

… as required following Wikidata:Bots#Bot requirements. Is there any reason for that? --Marsupium (talk) 02:25, 14 February 2019 (UTC)

Manche Listen werden nicht upgedated

Hallo Magnus, die Liste de:Wikipedia:Public Domain Day/2021 in Public Domain wird nicht mehr upgedated, während die Liste de:Wikipedia:Public Domain Day/2017 in Public Domain‎ noch funktioniert. Woran liegt das? --Sebastian Wallroth (talk) 13:38, 6 April 2019 (UTC)

Need help understanding »Women creators without commons category«

Hi Magnus,

I want to understand what the list Wikidata:WikiProject Women/Women creators without commons category is trying to achieve, and how I can address that pertaining to these two pictures I uploaded: Miriam Bliese and Helga Krause. The second picture was also placed into the list: Wikidata:WikiProject Women/Women without commons creator page – another working list, the purpose of which I don't quite understand.

Both these list are featured in the Wikidata:WikiProject Women, which I am fully supportive of. But both of the files I uploaded have a commons category – the woman's name – which is a subcategory of other commons categories. So what, in your opinion, needs to be addressed/improved here? Generally, it would be helpful not just for me, but for all Wikipedians, if you include a short description of what the lists are trying to achieve, and how to deal with entrants in the list. Both at the top of the list, and on the WikiProject Women page. Thanks, --Sprachraum (talk) 21:01, 25 July 2019 (UTC)

No update for 2 months

@Magnus Manske: In Wikidata:WikiProject Movies/new film items hasn't been an update for 2 months. -- MovieFex (talk) 11:27, 28 July 2019 (UTC)

I revised the query. If it stops again, it might help to increase the minimum QID (currently 65200900). --- Jura 12:26, 28 July 2019 (UTC)

"Misc" and "items" are in english also in wikipedia of different languages.

"Misc" and "items" are in english also in wikipedias of different languages.

Cannot became two optional parameters or automatically translated? --Arosio Stefano (talk) 16:51, 1 November 2019 (UTC)

Missing line in a list generated by the Bot

Hello, can you understand why the article "église Saint-Sernin de Calmont (Q41755063)" is missing in the list of churches in Haute-Garonne generated by this Bot ? I checked several times the article and everything seems ok to me. Thanks in advance for your support, --FHd (talk) 21:31, 25 November 2019 (UTC)

Another examples are église Saint-Vincent de Bagnères-de-Bigorre (Q22939898)" or "église Saint-Jean de Bagnères-de-Bigorre (Q17190250) missing in the list of churches in Hautes-Pyrénées generated by this Bot, like all elements of the same localisation (P131). Thanks in advance for having a look, --FHd (talk) 09:10, 15 December 2019 (UTC)

 Done Ayack (talk) 09:35, 15 December 2019 (UTC)

Thank you. What did you for that? The list of churches in Haute-Garonne is still not updated. --FHd (talk) 13:53, 15 December 2019 (UTC)

 OK Done also for Calmont

Links to the Fries Museum don't work

None of the links to the Fries Museum seem to work in this list. When clicking the error message "404 Not Found" appears. What is the problem? Regards, Gouwenaar (talk) 08:20, 6 May 2020 (UTC)

@Gouwenaar: this has nothing to do with this robot. Another case of link rot I'm afraid. Multichill (talk) 17:56, 28 November 2020 (UTC)

Coronavirus

Hi, I'd like to suggest renaming Wikidata:Lists/corona virus deaths to Wikidata:Lists/coronavirus deaths, which seems to be the correct virus name. Regards, —capmo (talk) 03:44, 24 June 2020 (UTC)

Wikidata:WikiProject Movies/reports/random/film

Is there a problem with ListeriaBot as Wikidata:WikiProject Movies/reports/random/film is not updated anymore. Even when manually triggering the update, nothing happens. --Christian140 (talk) 10:22, 30 June 2020 (UTC)

"Status: No template match" on trwiki

Hello,

On my Turkish sandbox page I tried to run a query which worked fine on my English sandbox page. But it said ""Status: No template match"

Any ideas please?

Chidgk1 (talk) 14:04, 20 July 2020 (UTC)

@Magnus Manske: The status seems fine for other users. My user is not whitelisted on Turkish Wikipedia - so do you think that is the reason? If so would it be possible to amend the error message in case the same problem occurs for other users in future? Chidgk1 (talk) 06:37, 24 July 2020 (UTC)

Unable to edit certain projects

ListeriaBot is perfectly able to update many lists, but it always fails to update Wikidata:WikiProject sum of all paintings/Top creators by number of paintings, Wikidata:WikiProject sum of all paintings/Top creators by number of collections, and Wikidata:WikiProject sum of all paintings/Top creators by number of Wikipedia articles, no matter how often I launch it. There seem to be a problem with the "top creator" topic in general. Please check it and repair it! Thank you, --Edelseider (talk) 08:55, 20 September 2020 (UTC)

Bot not working

ListeriaBot has not been able to update this page in three days now. Reporting it here. --79.24.120.120 18:03, 17 November 2020 (UTC)

Still not working after more than a week. --Folengo (talk) 19:55, 21 November 2020 (UTC)

Sum of all paintings

ListeriaBot has not updated this table here for a long time and a manual update isn't working either... Maybe someone can help out here? Kruusamägi (talk) 18:41, 4 December 2020 (UTC)

If this talk page is no longer used please make it obvious

Hello Magnus. Your bot is very useful thanks but I wonder if this talk page is not useful any more. For example if we should only use the support button on the user page please write in big letters here. Otherwise people will be wasting time leaving more messages here which will not be replied to. Or maybe put a title on this talk page saying it is not for support but just a forum. Thanks Chidgk1 (talk) 14:23, 27 February 2021 (UTC)

Bot not working correctly

Look at Wikidata:Database reports/no statements/dewiki/all.

The bot is not replacing the former list of the day before but it is appending the new list to the old one. So the content is growing by 50kB each time the bot runs. You can find "Diskriminierung (Außenwirtschaft)" four times in the list of 09:38, 1 December 2021.

--Fidoez (talk) 15:58, 3 December 2021 (UTC)

I found a solution, see github --Fidoez (talk) 18:08, 8 December 2021 (UTC)

Add column headings at bottom of tables

Hi, is it possible to update your bot to duplicate column heading titles of wikitables at the bottom of the wikitable? I made a manual edit to add this, but your bot removed my edit :-/. Repeating or duplicating column heading titles or descriptions is common on long tables, and it helps readers by eliminating (or reducing) the need for repeated scrolling to see the description of each column. Regards. Militum professio scriniarii (talk) 21:00, 16 December 2022 (UTC)

Bot Not Working for 5 days

The bot is still have not updated this page for about five days from now, needing for an urgent repair to update periodically into this page.Wikidata:Database reports/Recent deaths Telex80 (talk) 05:42, 12 February 2023 (UTC)

The update data is still broken, I already update the recent death database just for the cause Telex80 (talk) 18:21, 13 February 2023 (UTC)

Bot not working again

Urgently to say, the bot is currently about to update for wikidata stats for Wikidata:Database reports/Recent deaths but the thing is once I've update per day it usually said :

Last line: Return val: 101 Telex80 (talk) 17:43, 16 March 2023 (UTC)

Can you add mt.wikipedia.org to the bot?

I noticed that mtwiki is not included in the bot status, which might be a reason why it's not working there. Mtanti (talk) 08:37, 9 April 2023 (UTC)

Wikidata:Database reports/no statements/

Hi! Many thanks for your good work on Wikidata. Could you generate list like that: Wikidata:Database reports/no statements/enwiki for plwiki? I would be very grateful. Kind regards :) Gower (talk) 22:09, 4 December 2023 (UTC)

There you go! --Magnus Manske (talk) 13:28, 5 December 2023 (UTC)

Bot not updating for 3 days

I was now tryin to update the Wikidata list of recent deaths and the birthdays today since February 17 2024, I usually done this periodicallly, can someone fix this asap Telex80 (talk) 19:51, 18 February 2024 (UTC)

ListeriaBot has problems, working on it, might take a few days. --Magnus Manske (talk) 10:17, 19 February 2024 (UTC)

Thanks for the status update. I'm noticing that the list at Wikidata:WikiProject Higher education/New items hasn't been updated in many months. Cheers, Sdkb ^talk 05:35, 20 February 2024 (UTC)

Fell asleep

Hello! Listeriabot fell asleep yesterday. The bot status is empty, it did not perform the updates requested yesterday. Please look at it! Thx Pallor (talk) 10:15, 5 April 2024 (UTC)

For the bot: agriculture

Online translation: please update page Wikidata:WikiProject Agriculture/Tools-tasks/Agriculture - there are changes in it. Ыфь77 (talk) 13:50, 14 July 2024 (UTC)

How to change a likely flawed query?

On Talk:Q742487 the bot is creating and updating a list of nootropics. However, with its current query it doesn't add CE-123 (Q85749829) even after adding instance of: drug to it and subclass of: chemical compound to drug (its an instance of designer drug). Could somebody please:

1. adjust the query (I think by changing/removing ?item wdt:P279 wd:Q11173 or by also including instance of: nootropic and not just subject has role: nootropic items)
2. explain how to see who created a query and how to properly request it to be changed
3. add some info so that this is already clear at the page where it says "This list is periodically updated by a bot."
4. explain what your view is on the relative incompleteness of this list and probably many others means – Category:Nootropics contains far more items so doesn't this mean Wikidata is very incomplete compared to Wikipedia which itself is quite incomplete and that items need to at least be synced with that cat and if so why is it not done there? (For example if a person was looking for a list of notable nootropics it would make more sense to go to or forward them to the WP category rather than this WD query or the table created from it.)

Prototyperspective (talk) 16:35, 2 September 2024 (UTC)