User talk:ListeriaBot

From Wikidata
Jump to navigation Jump to search

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)

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

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)

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

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)

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

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

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?[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)

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)

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)

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)

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

medium task[edit]

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

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)

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)

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

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.

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)

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

File missing[edit]

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

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)

  • @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[edit]

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

Reverse editions[edit]

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

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)