Interwiki linking edit

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)Reply

@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)Reply
@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)Reply
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)Reply
@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)Reply
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)Reply

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

Done (example). --Magnus Manske (talk) 13:14, 5 November 2015 (UTC)Reply
Ευχαριστώ! -geraki talk 12:15, 6 November 2015 (UTC)Reply

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)Reply

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)Reply

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

Chemical structures edit

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)Reply

@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)Reply
Erledigt, sollte beim nächsten Update behoben sein. --Magnus Manske (talk) 19:39, 8 October 2015 (UTC)Reply
Danke--Kopiersperre (talk) 11:10, 10 October 2015 (UTC)Reply

Query example: species named by Linnaeus edit

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)Reply

ListeriaBot seems a little indecisive edit

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)Reply

@Magnus Manske: Gentle ping. NMaia (talk) 15:09, 27 May 2016 (UTC)Reply
The bot is fine. The data source is alternating. Probably a stale copy. --Magnus Manske (talk) 21:47, 28 May 2016 (UTC)Reply
@Magnus Manske: does that mean the issue is in the Query Service? NMaia (talk) 22:15, 28 May 2016 (UTC)Reply
As far as I can tell, yes. --Magnus Manske (talk) 19:02, 29 May 2016 (UTC)Reply

Sort by item causing hiphop edit

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

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)Reply

Stable sort order edit

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)Reply

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)Reply

Is sort=P1448 not allowed? edit

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?

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)Reply

Fatal error edit

The Bot reports the following error:

Warning: parse_ini_file(/data/project// 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 @'' (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/ on line 455

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

How to fix ? edit

creating a list at Odia wikipedia ( shows the error 'Notice: Undefined property: Listeria::$header_template in /data/project/listeria/ on line 942'--MKar (talk) 04:46, 3 June 2017 (UTC)Reply

Allow duplicate items? edit

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)Reply

A strange typo with category items edit

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).Reply

medium task edit

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

Recent Deaths list edit

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)Reply

No items edit

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)Reply

The query must return ?item, see the template documentation page. --Larske (talk) 11:52, 15 February 2018 (UTC)Reply
Thank you. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 13:31, 15 February 2018 (UTC)Reply
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)Reply

Not working on Hiwiki edit

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)Reply

Bug when no items, where previously there were items edit

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)Reply
I'm having this problem too. @Magnus Manske: help? --LadiesMakingComics (talk) 17:40, 11 June 2019 (UTC)Reply
@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:
 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)Reply

No updates since 11. Apr. 2018‎ edit

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)Reply

@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)Reply

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

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)Reply

File missing edit

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

KM Sorting edit

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 .
    ?statementNode pqv:P2043 ?distanzNode .
    ?distanzNode wikibase:quantityAmount ?distanz .
    ?distanzNode wikibase:quantityUnit ?distanzEinheit .
    ?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)Reply

@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)Reply
@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)Reply
@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)Reply

Wikidata:WikiProject Properties/Reports/Datatypes edit

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

Display external URL in a shorter way edit

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. could be :

This would make the tables more readable.


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

Reverse editions edit

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

ListeriaBot errors edit

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/ 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)Reply

The names of the data types edit

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)Reply

ListeriaBot doesn't set the botflag for its edits edit

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

Manche Listen werden nicht upgedated edit

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)Reply

Need help understanding »Women creators without commons category« edit

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)Reply

No update for 2 months edit

@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)Reply

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)Reply

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

"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)Reply

Missing line in a list generated by the Bot edit

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)Reply

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)Reply
  Done Ayack (talk) 09:35, 15 December 2019 (UTC)Reply
  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)Reply
  OK Done also for Calmont

Links to the Fries Museum don't work edit

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)Reply

@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)Reply

Coronavirus edit

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)Reply

Wikidata:WikiProject Movies/reports/random/film edit

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)Reply

"Status: No template match" on trwiki edit


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)Reply

@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)Reply

Unable to edit certain projects edit

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)Reply

Bot not working edit

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

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

Sum of all paintings edit

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)Reply

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

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)Reply

Bot not working correctly edit

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)Reply

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

Add column headings at bottom of tables edit

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)Reply

Bot Not Working for 5 days edit

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)Reply

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)Reply

Bot not working again edit

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)Reply

Can you add to the bot? edit

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)Reply

Wikidata:Database reports/no statements/ edit

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)Reply

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

Bot not updating for 3 days edit

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)Reply

ListeriaBot has problems, working on it, might take a few days. --Magnus Manske (talk) 10:17, 19 February 2024 (UTC)Reply
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, Sdkbtalk 05:35, 20 February 2024 (UTC)Reply

Fell asleep edit

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)Reply