User talk:Σ/Archive/2021/April

Crash in editorinteract.py

This only happens intermittently, but I've seen it a few times. -- RoySmith (talk) 20:46, 4 March 2021 (UTC)

https://sigma.toolforge.org/editorinteract.py?users=Deogyusan&users=174.112.21.209&users=70.55.11.97&users=70.55.8.116&users=8ya&users=Charlesn66&users=110.168.170.123&users=174.114.57.231&users=126.72.143.235&users=216.209.50.103&users=XiAdonis

Traceback (most recent call last):
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/connection.py", line 503, in _connect
    await self._request_authentication()
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/connection.py", line 785, in _request_authentication
    auth_packet = await self._read_packet()
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/connection.py", line 593, in _read_packet
    packet.check_error()
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.InternalError: (1226, "User 's51469' has exceeded the 'max_user_connections' resource (current value: 10)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/data/project/sigma/www/python/src/app.py", line 33, in inner
    return func(*a, **kw)
  File "/data/project/sigma/www/python/src/app.py", line 71, in editorinteract_py
    tpl, store = EditorInteract(params)()
  File "./editorinteract.py", line 28, in __call__
    loop.run_until_complete(self.do_query(store.server, store.query))
  File "/usr/lib/python3.7/asyncio/base_events.py", line 584, in run_until_complete
    return future.result()
  File "./editorinteract.py", line 157, in do_query
    user_edits = dict(zip(query.users, await asyncio.gather(*[get_user_edits(u, pool) for u in query.users])))
  File "./editorinteract.py", line 151, in get_user_edits
    async with p.acquire() as conn:
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/utils.py", line 98, in __aenter__
    self._conn = await self._coro
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/pool.py", line 135, in _acquire
    await self._fill_free_pool(True)
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/pool.py", line 181, in _fill_free_pool
    **self._conn_kwargs)
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/connection.py", line 75, in _connect
    await conn._connect()
  File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/aiomysql/connection.py", line 523, in _connect
    self._host) from e
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'enwiki.labsdb'")

New problem on interactions analysis tool

Hello, I got this anwer, after having tried this URL : https://sigma.toolforge.org/editorinteract.py?users=Eggishorn&users=The+Banner&users=&startdate=202000801&enddate=&ns=&server=enwiki Anything you can do ? Thank you cheers --Emigré55 (talk) 13:03, 15 March 2021 (UTC)

500 You shouldn't be seeing this page. Please report this to User:Σ on enwp. Include the current URL and the text below in your report. If you do not include this information, then there is nothing I can do to help. Traceback (most recent call last): File "/data/project/sigma/www/python/src/app.py", line 33, in inner return func(*a, **kw) File "/data/project/sigma/www/python/src/app.py", line 73, in editorinteract_py return tpl.render(store=store) File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/mako/template.py", line 462, in render return runtime._render(self, self.callable_, args, data) File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/mako/runtime.py", line 838, in _render **_kwargs_for_callable(callable_, data)) File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/mako/runtime.py", line 873, in _render_context _exec_template(inherit, lclcontext, args=args, kwargs=kwargs) File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/mako/runtime.py", line 899, in _exec_template callable_(context, *args, **kwargs) File "editorinteract_query_mako", line 48, in render_body File "editorinteract_query_mako", line 18, in pretty_date File "/data/project/sigma/www/python/venv/lib/python3.7/site-packages/arrow/arrow.py", line 203, in strptime dt = datetime.strptime(date_str, fmt) File "/usr/lib/python3.7/_strptime.py", line 577, in _strptime_datetime tt, fraction, gmtoff_fraction = _strptime(data_string, format) File "/usr/lib/python3.7/_strptime.py", line 359, in _strptime (data_string, format)) ValueError: time data '202000801000000' does not match format '%Y%m%d%H%M%S'

(talk page stalker) @Emigré55: Your start date has the wrong format; it should be "20200801" instead of "202000801". — The Earwig (talk) 13:24, 15 March 2021 (UTC)

I am such a fool! 😃 Thank you! and sorry for any inconvenience. kind regards, --Emigré55 (talk) 13:37, 15 March 2021 (UTC)

Feedback request: Politics, government, and law request for comment

Your feedback is requested at Talk:List of Middle Eastern superheroes on a "Politics, government, and law" request for comment. Thank you for helping out!
You were randomly selected to receive this invitation from the list of Feedback Request Service subscribers. If you'd like not to receive these messages any more, you can opt out at any time by removing your name.

Message delivered to you with love by Yapperbot :) | Is this wrong? Contact my bot operator. | Sent at 02:31, 28 March 2021 (UTC)

Username with a Greek Letter

How did you come up with a Sigma symbol as your username??? 108.88.82.1 (talk) 02:26, 8 April 2021 (UTC)

My previous username had a question mark in it, which made it a pain in the neck to type in the URL bar, since a question mark in a URL has a special meaning. So a URL leading to my userpage would erroneously look like this: https://en.wikipedia.org/wiki/User:Σ?action=history . When in reality, I'd need it to look like this: https://en.wikipedia.org/wiki/User:Σ%3Faction=history .

As for the choice of a sigma, I just wanted a single character username, and the Latin alphabet was already taken. →Σσς. (Sigma) 10:00, 9 April 2021 (UTC)

Feedback request: Politics, government, and law request for comment

Your feedback is requested at Talk:List of Middle Eastern superheroes on a "Politics, government, and law" request for comment. Thank you for helping out!
You were randomly selected to receive this invitation from the list of Feedback Request Service subscribers. If you'd like not to receive these messages any more, you can opt out at any time by removing your name.

Message delivered to you with love by Yapperbot :) | Is this wrong? Contact my bot operator. | Sent at 01:31, 3 April 2021 (UTC)

"🙌" listed at Redirects for discussion

A discussion is taking place to address the redirect 🙌. The discussion will occur at Wikipedia:Redirects for discussion/Log/2021 April 16#🙌 until a consensus is reached, and anyone, including you, is welcome to contribute to the discussion. 𝟙𝟤𝟯𝟺𝐪𝑤𝒆𝓇𝟷𝟮𝟥𝟜𝓺𝔴𝕖𝖗𝟰 (𝗍𝗮𝘭𝙠) 10:02, 16 April 2021 (UTC)

Archiving bot edit summaries

Hi Σ! An idea for lowercase sigmabot: when archiving discussions, I think it'd be helpful if, rather than just using the edit summary e.g. "Archiving 1 discussion(s) to User talk:Σ/Archive 47) (bot)", it instead named the discussion. That's more important than the archive name, really, which could just be linked. So we'd have instead e.g. "Moving 'Archiving bot edit summaries' discussion to archive (bot)". For archiving multiple discussions or discussions with really long titles it'd still have to be e.g. "Moving 4 discussions to archive (bot)" to avoid an overly long edit summary, but for the 1-discussion archiving (which I think is probably most common anyways), would it be possible to look into this? Cheers, {{u|Sdkb}} ^talk 22:14, 26 April 2021 (UTC)

Talk:LGBT rights by country or territory

why does User:lowercase sigmabot III keep archiving the iraq section in Talk:LGBT rights by country or territory?--79.180.252.83 (talk) 18:20, 29 April 2021 (UTC)

Because it's more than seven days old. Whilst on that matter, reverting an edit where a bot archived an old thread needs to be done properly - it's not sufficient to restore the thread to the main talk page, you must also remove it from the archive where there are now two copies, and in a few hours time (when the bot next visits that page) there will be three. --Redrose64 🌹 (talk) 18:36, 29 April 2021 (UTC)