[03:48:55] does the MediaWiki interface have a way to find a username given the corresponding actor id? [04:01:47] ksft, what are you referring to by interface? [04:02:01] the actor table records the user/name of each actor ID [04:14:15] the usual web interface, I mean [04:14:21] I'm trying to debug a query [04:37:39] no, the actor ID isn't exposed in the UI [13:41:10] ksft: you can do a debug select * from actor where actor_id=xx through ;) [16:48:25] thanks -- I was just hoping to avoid running the query again, but I found the bug anyway [16:48:39] is there a reliable way to parse log_params with SQL? [17:30:06] ksft: I doubt so [17:30:25] you can do some regex magic, but that's all I can think of [19:09:35] log_params is PHP serialize() so you really have to use PHP to do it [19:11:59] ah, would be nice if it used the relationala database model [19:12:51] that ship sailed a long time ago... [19:13:19] relational* [19:13:29] Reedy: what do you mean? [19:13:49] The tables and setup was created years and years ago [19:15:40] and sometimes over-normalisation is not a positive thing [19:16:46] just storing it as json would be a lot more portable these days, for sure [19:17:07] With numbers dbms having json support these days [19:17:28] *numerous [19:19:14] There's ways to read it without PHP, but none really in MySQL: https://pypi.org/project/phpserialize/ / https://code.google.com/archive/p/serialized-php-parser/ / etc