[00:00:42] gn8 folks [00:26:23] Nemo_bis: New WP favicon? [00:27:01] Susan: yes [00:27:08] idk the details but I overheard that yesterday [00:27:22] On en.wiki? [00:27:48] yes [00:30:10] Jasper_Deng: IPv6 on the toolserver was disabled due to a recent toolserver maintenance disaster [00:30:44] Betacommand: well, it wasn't /totally/ disabled, bots running from it on-wiki and some tools use IPv6 [00:31:07] for example, when a WHOIS tool was banned by the WHOIS provider, it mentioned that the IPv6 address was banned [00:31:19] Jasper_Deng: odd [00:31:40] Today, a simplewiki bot edited logged-out, and it was from a TS IPv6 [00:32:57] Jasper_Deng: I thought nosy had set ipv4 only. During the recent server IP re-allocation process things got harry [00:34:08] Betacommand: idk.... http://simple.wikipedia.org/?diff=4362658&oldid=2132444 [01:17:30] Jasper_Deng: I haven't heard anything other than Nemo's comment. [01:17:33] About a favicon. [01:21:19] Susan: You can blame Isarra ;) [01:23:12] Hmm. [01:23:21] I thought she was just updating it. [01:23:26] Did she change it more dramatically? [01:41:56] Is it dramatic? [01:42:09] * Isarra belches. [02:10:53] what file should the admin change on a wiki in order for the TOC to not be floating for ALL users whom would access any page on that wiki ? [02:10:57] is it global.css ? [02:12:32] Common.css [02:12:39] * Jasper_Deng doesn't know what you'd add though [03:38:17] [75e99b7b] 2013-04-13 03:37:21: Fatal exception of type MWException [03:38:21] * legoktm pokes Reedy  [03:38:25] (on wikidata) [03:41:13] legoktm: don't you think you should give more details? [03:41:48] Jasper_Deng: he is asking Reedy to look it up in the log, to see what caused it... [03:41:54] yeah.... [03:43:57] "MediaWiki exception" is my nickname. [03:44:53] Susan: that isn't your only nickname ;) [03:49:02] I'm the sassmaster. [03:53:51] [[Tech]]; Rickyrab; /* Background color (differentiate between article namespace and other namespaces) */; https://meta.wikimedia.org/w/index.php?diff=5390152&oldid=5386750&rcid=4067694 [03:54:26] [[Tech]]; Rickyrab; /* Beige background color, Vector skin */; https://meta.wikimedia.org/w/index.php?diff=5390153&oldid=5390152&rcid=4067696 [04:19:41] [[Tech]]; MZMcBride; /* Removing tabs */ +reply; https://meta.wikimedia.org/w/index.php?diff=5390160&oldid=5390153&rcid=4067706 [04:27:11] [[Tech]]; MZMcBride; /* Beige background color, Vector skin */ +reply; https://meta.wikimedia.org/w/index.php?diff=5390162&oldid=5390160&rcid=4067708 [04:29:01] [[Tech]]; MZMcBride; /* Move sidebar links to bottom (similar to MySkin) */ +reply; https://meta.wikimedia.org/w/index.php?diff=5390165&oldid=5390162&rcid=4067711 [04:30:08] Is image.img_name varchar or varbinary as is now on the Toolserver? [04:33:41] [[Tech]]; MZMcBride; /* Removing tabs */ better; https://meta.wikimedia.org/w/index.php?diff=5390169&oldid=5390165&rcid=4067715 [04:42:33] Could someone give me the DESCRIBE image; from the cluster? [04:45:35] Krinkle, maybe. [04:45:42] Otherwise, ask Reedy when he's around/alive. [04:45:47] Or DaB. [04:45:52] Dispenser: On it [04:46:09] show create table image; should also be useful. [04:46:53] * Susan NP: "Magic" by B.o.B from "B.o.B Presents: The Adventures Of Bobby Ray" [04:47:29] Haven't seen the create table trick before [04:48:32] ugh, sql script returns as PHP object [04:48:56] https://gist.github.com/anonymous/26009f3438e3028eb476 [04:48:58] just tell me if img_name is VARCHAR or VARBINARY on the clusters [04:49:11] img_name is varbinary(255). [04:49:15] varbinary(255) [04:49:25] I'll check two other wikis [04:49:30] Why's the documentation lagging? [04:49:39] You're not using the mysql console? [04:49:54] Susan: db hosts change from time to time. [04:50:02] https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/core.git;a=blob;f=maintenance/tables.sql;hb=HEAD [04:50:03] https://www.mediawiki.org/wiki/Image_table#Versions [04:50:07] and I don't want to hook into a master, and there are lots of slaves. [04:50:27] varbinary(255) for img_name on aawiki and enwiki [04:50:38] As I recall, there was some funkiness between MySQL 4 and 5 re: img_name. [04:50:50] Because MySQL 5 doesn't support ... something. [04:50:52] I don't remember. [04:51:04] https://github.com/wikimedia/mediawiki-core/blob/master/maintenance/tables.sql#L797-801 [04:51:10] It is varbinary in master as well [04:51:31] Dispenser: Why did you suspect it wouldn't be up to date on the cluster? [04:51:40] Some updates we ignore but usually not. [04:51:56] It's important that it match page.page_title. [04:53:15] I wanted to rule out an idiot requesting a TS change to fix a bug [04:54:35] A transexual change. [04:55:13] Hmm, two S's. [04:56:12] Krinkle: Would you mind posting the describe on [[mw:Image table#Versions]] [04:56:39] No, I will not. I'll instead execute it on my localhost with a fresh install of MediaWiki and post that [04:56:54] cluster is not typical mediawiki state. [04:57:40] Well the tables.sql hasn't been updated so that might be a problem [04:57:41] mediawiki-vagrant! [04:58:25] Dispenser: What do you mean? [04:59:47] done, https://www.mediawiki.org/wiki/Manual:Image_table#Versions [05:00:25] thanks [05:22:15] Dispenser: Hm.. I see what you mean [05:22:29] Dispenser: It is varbinary on cluster, but varchar in tables.sql [05:22:41] I thought it was the same [05:22:57] hence my wondering [05:23:07] But on my localhost it is also varbinary [05:23:47] I didn't make any manual changes [05:24:04] i bet it was all domas's doing >.> [05:24:30] Conversion script? [05:25:01] let me do a clean install [05:25:07] http://stackoverflow.com/questions/5978484/what-is-the-advantage-of-using-varbinary-over-varchar-here [05:25:13] that one links to an svn revision in mediawiki [05:25:16] however that one has been reverted [05:25:34] https://www.mediawiki.org/wiki/Special:Code/MediaWiki/80547 [05:25:56] It doesn't do crap with trailing whitespace [05:29:24] varchar strips whitespace (per spec(!)), slower comparisons (varchar defaults to case-insensitive), and lots of confusion with latin1 and utf8 (an issue with python's oursql) [05:29:49] Dispenser: Fresh install on mysql 3.5.7, I get varchar(255) for image [05:30:00] Now I'll run update.php (shouldn't do anything since the wiki is empty) [05:30:44] Yep, still varchar. [05:33:08] I created the db manually with table.sql [05:33:11] lets try install.php [05:39:12] Dispenser: That's it [05:39:31] Dispenser: If the default collation of the database is binary then those columns will become varbinary [05:39:42] Either done by mediawiki or my mysql on install [05:39:53] (as opposed to latin1 or utf-8) [05:41:25] narrowed down to mysql [05:41:25] So is that something we'll have to write a test for? [05:41:59] creating table with field type varchar is turned into varbinary my MySQL (version 5.6.10) [05:42:05] by* [05:42:09] not done by mediawiki [05:42:19] Tried manually with mysql [21:08:38] * Nemo_bis awards Susan a barnstar for "Some mixture of comment 10, comment 11, comment 12, comment 15, and comment 16, [21:08:38] I guess." [21:09:48] :-) [21:11:52] where? [21:12:29] [[Tech]]; DragonflySixtyseven; /* Classic skin and CSS */ new section; https://meta.wikimedia.org/w/index.php?diff=5392651&oldid=5390169&rcid=4070422 [21:13:01] [[Tech]]; DragonflySixtyseven; fix; https://meta.wikimedia.org/w/index.php?diff=5392652&oldid=5392651&rcid=4070423 [21:16:53] Hah [21:16:58] Slight technical hitch [21:17:37] http://meta.wikimedia.org/wiki/Tech#Classic_skin_and_CSS can anyone help make vector usable [21:19:18] [[Tech]]; DragonflySixtyseven; /* Classic skin and CSS */; https://meta.wikimedia.org/w/index.php?diff=5392657&oldid=5392652&rcid=4070428 [21:24:03] Hmm [21:24:08] I'm annoyed at something [21:24:34] At English Wikipedia I have an alternate to ShakespeareFan00 - which is Sfan00-IMG [21:24:55] Sfan00-Img is currently blocked on English Wikisource owing to mutlipleaccount confusion [21:25:08] At English Wikipedia I switch from Sfan00_IMG to ShakespeareFan00 [21:25:19] And then transfer over to Wikisource... [21:25:26] intending to use the main-account [21:25:47] At which point the main account gets an IP-block because it's been used by the same IP as a blocked account [21:26:24] Considering that I was changing back to an account which was agreed to be the main account with Wikisource admins, I'm puzzled. [21:26:36] 'and one man in his time plays many parts' [21:26:53] I think explaining this to admins is probably the fastest way to get that resolved [21:27:23] I've already sent the IP-block noitce to the admin that blocked Sfan00_IMG at English Wikisource.. [21:27:54] The software is working as designed... [21:28:08] the software was designed? :) [21:28:41] but it's annoying to get an IP-block (which also disables talk page access) when you'd switched accounts precisely because the alternate wasn't in use. [21:29:10] (and had been agreed as not being in use with admin that blocked the alternate and set the auto-block) [21:30:16] It's not a problem [21:30:26] http://meta.wikimedia.org/wiki/Tech#Classic_skin_and_CSS can anyone help make vector usable [21:30:36] as such... [21:30:54] But it's annoying that I got an IP-block because I WAS playing by the rules.. [21:32:43] just speak to a wikiquote admin [21:32:47] er, wikisource [21:33:26] There are none around at the moment [21:33:32] I pinged them in #wikisource [21:34:13] I also sent an e-mail to the blockign admin, but it hasn't come through the system, because I can't see a copy in my inbox [21:35:11] It's unfair that I get an IP-block because I switched accounts to the unblocked one that I'd agreed was the main account [21:35:48] but the software is working as designed... [21:35:58] (Given that vandals do IP hop)