User talk:Σ/Archive/2019/June

You've got mail

Hello, Σ/Archive/2019. Please check your email; you've got mail!
It may take a few minutes from the time the email is sent for it to show up in your inbox. You can at any time by removing the {{You've got mail}} or {{ygm}} template. Unicornblood2018 (talk) 12:41, 28 April 2019 (UTC)

@Unicornblood2018: I'm the wrong person to ask, check out WP:ARCHIVE for what happened. →Σσς. (Sigma) 03:06, 7 June 2019 (UTC)

Your Userpage

Hi Σ how did you get your userpage to display information but when i click "View Source" it only shows {{PleaseDontEdit/}} - JJBullet (Talk) 09:32, 3 May 2019 (UTC)

@JJBullet: Not only that, try copying and pasting the template's name from the source; you'll get "tidEtnoDesaelP". I suspect there is a right-to-left mark in the page (an invisible character that changes the direction of text rendering). e^πi (talk | contribs) 20:27, 4 May 2019 (UTC)

But I'm sorry I gave away your secret, Σ. I just got so excited when I saw the right-to-left marks used in an interesting way! e^πi (talk | contribs) 20:37, 4 May 2019 (UTC)

Just wanted to say that this is one of the most interesting userpages on Wikipedia and tracking down the true code is a scavenger hunt. StudiesWorld (talk) 01:43, 12 May 2019 (UTC)

Thank you!→Σσς. (Sigma) 03:06, 7 June 2019 (UTC)

User:MiszaBot/config

Greetings,

has it ever been considered to move User:MiszaBot/config to a different title (e.g Template:Automated archive)? I have been wondering for a long time why we are using the title of a deactivated bot and it's a little confusing. Jo-Jo Eumerus (talk, contributions) 09:14, 26 May 2019 (UTC)

Yes, but if you think about it, it's not a very good use of edits to change everybody's talk page for a non-cosmetic change. It's also a nice piece of history to keep around →Σσς. (Sigma) 03:05, 7 June 2019 (UTC)

Editor interaction tool

Hello, Σ/Archive/2019. Please check your email; you've got mail!
It may take a few minutes from the time the email is sent for it to show up in your inbox. You can at any time by removing the {{You've got mail}} or {{ygm}} template.

Mark Ironie (talk) 17:23, 5 June 2019 (UTC)

The tool is also not working for me. Queried Mark; he said it worked for him earlier today. It's not working for me right now. No idea why. - CorbieV ^☊ ☼ 22:21, 6 June 2019 (UTC)

And then suddenly it started working. It may have had something to do with looking up an account that had under 150 live edits in mainspace. Once it crossed that threshold, or something like that, it suddenly worked fine. Weird. Or maybe it was totally random glitching. *shrugs* - CorbieV ^☊ ☼ 01:18, 7 June 2019 (UTC)

Should be back up now→Σσς. (Sigma) 03:05, 7 June 2019 (UTC)

Edit summary search not working

I entered this query and it threw a HTTP 500, with this traceback:

        Traceback (most recent call last):
  File "./app.py", line 33, in inner
    return func(*a, **kw)
  File "./app.py", line 98, in summary_py
    tpl, store = Summary(params)()
  File "./summary.py", line 24, in __call__
    self.do_query(store.query, cursor)
  File "./summary.py", line 134, in do_query
    cur.execute(query.str, query.args)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/cursors.py", line 135, in execute
    self.errorhandler(exc, value)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/cursors.py", line 37, in errorhandler
    self.connection.errorhandler(self, errorclass, errorvalue)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/connections.py", line 117, in errorhandler
    raise errorvalue
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/cursors.py", line 130, in execute
    self._query(query)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/cursors.py", line 240, in _query
    conn.query(q)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/connections.py", line 346, in query
    self._result = MySQLResult(self)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/packet.py", line 270, in __init__
    self.first_packet = MysqlPacket(self.connection)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/packet.py", line 66, in __init__
    raise_mysql_exception(self.__data)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/err.py", line 149, in raise_mysql_exception
    _check_mysql_exception(errinfo)
  File "/data/project/sigma/www/python/venv/lib/python3.5/site-packages/cymysql/err.py", line 144, in _check_mysql_exception
    raise InternalError(errno, errorvalue)
cymysql.err.InternalError: (1054, "Unknown column 'r.rev_user_text' in 'where clause'")

Is this a short-term or long-term problem? --Redrose64 🌹 (talk) 22:13, 6 June 2019 (UTC)

Redrose64 - If I had to guess, I'd bet it has something to do with the recent schema changes (T223406)SQL^{Query me!} 22:18, 6 June 2019 (UTC)

A shorter-term stopgap solution is to switch to _compat tables - e.g. use revision_compat, etc. (per wikitech). Sounds like it may incur a bit of a performance hit, but should at least get everything back up and running. SQL^{Query me!} 22:20, 6 June 2019 (UTC)

Should be back up now →Σσς. (Sigma) 03:05, 7 June 2019 (UTC)

Thank you --Redrose64 🌹 (talk) 16:07, 7 June 2019 (UTC)